1
Finance and Data Analyst excel shortcuts
Very useful for all finance and data analyst aspirant and
working professionals
Editing shortcuts
Excel shortcuts Microsoft excel
Fill right Ctrl + R
Insert worksheet Shift + F11
Define a name for a cell Ctrl + F3
Insert column Alt + I + C
Display shortcut menu (i.e., same as right click) Shift + F10
Insert Row Alt + I + R
Start new line with same reference Alt + enter
Fill down (e.g., copy formula down in selected cells) Ctrl + D
Insert argument names and parentheses for a Ctrl + shift + A
function after typing a function name in a formula
Insert or edit cell comment Shift + F2
Edit active cell F2
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Paste special Alt + E + S
Paste F3
name into formula
Toggle references F4
File Shortcuts
2
New Ctrl + N
Open Ctrl + O
Save Workbook Ctrl + S
Save F12
Print Ctrl + P
Open Print Preview window Ctrl + F2
Go to next workbook CTRL + Tab
Close file Ctrl + F4
Close all open excel files Alt + F4
Ribbon Shortcuts
Show ribbon accelerator keys ALT
Show/hide ribbon Ctrl + F1
Paste Special Shortcuts
Paste Special formats Ctrl + V + T
Paste Special Values Ctrl + Alt + V + V
Paste special formulas Ctrl + Alt + V + F
Paste special comments Ctrl + Alt + V + C
Clear shortcuts
Clear cell data Delete
3
Clear cell format Alt + H + E + F
Clear cell comments Alt + H + E + M
Clear all data (data, formats, and comments) Alt + H + E + A
Data editing
Edit the active cell (edit mode) F2
While editing cell, allow use of arrow keys to F2
create references
Confirm change and get out of cell Enter
Cancel a cell entry and get out of cell Esc
Insert line break within cell Alt + Enter
Highlight within a cell Shift + left/right
Highlight contiguous items Ctrl + Shift + left/right
Jump to beginning of cell contents Home
Jump to end of cell contents End
Delete character to left Backspace
Delete character to right Delete
Accept autocomplete suggestion Tab
Referencing a cell from another worksheet Ctrl + Page up/down + arrows
Other Data editing Shortcuts
Fill down form cell above Ctrl + D
Fill right from cell left Ctrl + R
Find and replace Ctrl + F
Show all constants F5 + Alt + S+ O
Highlight cell with comments F5 + Alt + S + C
4
Selection shortcuts
Select a cell range Shift + arrows
Highlight a contagious range Ctrl + shift + arrows
Extend selection up one screen Shift + page up
Extend selection down one screen Shift + page down
Extend section left one screen Alt + shift + page up
Extend section right one screen Alt + shift + page down
Select all Ctrl + A
Shortcuts that help in common use
Enter date Ctrl +;
Enter time Ctrl + shift +:
Show formula / Show values (Keys to the left Ctrl + ‘
of 1)
Select cells which refer to the active cell Ctrl + J
(Useful before deleting a cell in a worksheet)
Drives menu bar Alt
Next open program Alt + tab
Auto sum Alt + =
Navigation shortcuts
Move from cell to cell Arrows
Go to F5
Go to cell A1 Ctrl + Home
Got o beginning of row Home
Select the adjacent cell Shift + arrow
Select entire row Shift + spacebar
5
Select entire column Ctrl + spacebar
Select all to the start of the sheet Ctrl + shift + home
Select all to the last used cell of the sheet Ctrl + shift + end
Select to the end of last use cell in Ctrl + shift + arrow
row/column
Select the last used cell in row/column Ctrl + arrow
Move one screen up Page up
Move one screen down Page down
Move one screen left Alt + page up
Move one screen right Alt + page down
