CTRL COMBINATION SHORTCUT KEYS IN EXCEL
CTLR AND ALPHABETIC COMBINATION SHORTCUTS
CTRL+A
|
Select entire worksheet
|
CTRL+B
|
Applies or removes bold formatting
|
CTRL+C
|
Copies the selected cells
|
CTRL+D
|
Fill down from cell above
|
CTRL+E
|
Flash fill
|
CTRL+F
|
Display find and replace
|
CTRL+I
|
Applies or removes italic formatting
|
CTRL+K
|
Insert Hyperlink
|
CTRL+L
|
Create Table
|
CTRL+N
|
Create New Worksheet
|
CTRL+O
|
Open Worksheet
|
CTRL+P
|
Print
|
CTRL+Q
|
Quick Analysis
|
CTRL+R
|
Fill Right
|
CTRL+S
|
Save Worksheet
|
CTRL+T
|
Create Table
|
CTRL+U
|
Applies or removes underlining
|
CTRL+V
|
Paste the selected cells
|
CTRL+W
|
Closes the selected worksheet window
|
CTRL+X
|
Cuts the selected cells
|
CTRL+Y
|
Repeats the last action
|
CTRL+Z
|
Undo
|
CTRL AND NUMBER COMBINATION SHORTCUT KEYS
CTRL+1
|
Format Cells
|
CTRL+2
|
Bold all highlighted cells in the section
|
CTRL+3
|
Italic all highlighted cells in the section
|
CTRL+4
|
Underline all highlighted cells in the section
|
CTRL+5
|
Applies or removes Strikethrough
|
CTRL+6
|
Show or hide Objects
|
CTRL+7
|
Show or hide Toolbars
|
CTRL+8
|
Display Outline symbols
|
CTRL+9
|
Hides the Selected Row
|
CTRL+0
|
Hides the Selected Column
|
CTRL AND FUNCTION KEY COMBINATION SHORTCUT KEYS
CTRL+F1
|
Help
|
CTRL+F2
|
-
|
CTRL+F3
|
Open Excel Name Manager
|
CTRL+F4
|
Closes current Window
|
CTRL+F5
|
Restores window size
|
CTRL+F6
|
Next worksheet
|
CTRL+F7
|
Moves the window
|
CTRL+F8
|
Resizes the window
|
CTRL+F9
|
Minimize current window
|
CTRL+F10
|
Maximize currently selected window
|
CTRL+F11
|
Inserts a macro sheet
|
CTRL+F12
|
Open a file
|
CTRL AND SYMBOL COMBINATION SHORTCUT KEYS
CTRL+-
|
Deletes selected row or column
|
CTRL++
|
Insert
|
CTRL+;
|
Enters current date
|
CTRL+’
|
Copies above cell formula
|
CTRL+`
|
Changes between displaying cell values
|
CTRL+/
|
Selects the containing the active cell
|
CTRL+\
|
Selects the cells that have a static value
|
CTRL+[
|
Selects all cells referenced by formulas in the highlighted section
|
CTRL+]
|
Selects cells that contain formulas that reference the active cell
|
No comments: