EXCEL QUICK REFERENCE
Document type: Commonly used shortcut keys
User type: Windows OS
Version: supports up to MS Excel 2019
Level: Basic to Advanced
Suitable for: Interview preparation/Excel practical exam/Speeding-up manual job
Note 1: Functions/calculations/sum work with “=”. Hence start any function say, =ALT+ N+ V returns a
pivot table of the data.
Note 2: The plus sign with each shortcut represents “and”, it is simply combining the function and
the symbol together. Hence you press “CTRL and S” together and not CTRL plus(+) S.
CTRL functions
Keys Functions
CTRL+ - Delete Row/Column menu
CTRL+ ; Display date
CTRL+ ~ Show formulas/values
CTRL+ ‘ (apostrophe) Copy above formula
CTRL+ [ Go to precedent cells
CTRL+ ] Go to dependent cells
CTRL+ A Select all
CTRL+ B Bold
CTRL+ C Copy
CTRL+ D Fill down (Copy above)
CTRL+ E Flash fill
CTRL+ F Find
CTRL+ G Go to
CTRL+ H Replace
CTRL+ I Italic
CTRL+ K Insert hyperlink
CTRL+ L/CTRL+ T Create table
CTRL+ P Print preview
CTRL+ Q Quick analysis
CTRL+ R Fill the selected cells to the adjacent right cell
CTRL+ S Save document
CTRL+ U Underline
CTRL+ V Paste
CTRL+ W Close window
CTRL+ X Cut
CTRL+ Y Redo
CTRL+ Z Undo
1|Page
, EXCEL QUICK REFERENCE
CTRL+ 0 Hide column
CTRL+ 1 Format box
CTRL+ 5 Strike-through
CTRL+ 9 Hide row
CTRL+ F1 Min/Restore ribbon
CTRL+ F3 Name a cell
CTRL+ F4 Close window
CTRL+ F9 Minimize workbook
CTRL+ F10 Maximize window
CTRL+ F12 Open file
CTRL+ DEL Delete text to the end of the line
CTRL+ END Go to the last content
CTRL+ ENTER Fill selection entry
CTRL+ ALT+ V Paste special box
CTRL+ Arrow keys Got to the end of data range
CTRL+ Home Move to cell “A1”
CTRL+ Minus sign Delete selected cells
CTRL+ Pg up/Down Switch worksheets
CTRL+ Space Select column
CTRL+ Tab Switch workbooks
CTRL+ SHIFT+ L Auto filter
SHIFT functions
Keys Functions
SHIFT+ F2 Inserts or edits a cell comment
SHIFT+ F3 Displays the (Insert > Function) dialog box
SHIFT+ F4 Repeats the last find
SHIFT+ F5 Find/Replace dialogue box
SHIFT+ F6 Moves to the previous pane in a workbook (if the
window is split)
SHIFT+ F7 Thesaurus
SHIFT+ F8 Add to selection
SHIFT+ F9 Calculates active sheet
SHIFT+ F10 Displays the (Shortcut) menu for the selected
item
SHIFT+ F10+ m Delete column
SHIFT+ F11 Inserts a new worksheet
SHIFT+ F12 Saves, Displays the (File > Save As) dialog box if a
new workbook
SHIFT+ SPACEBAR Selects the current row
SHIFT+ TAB Moves to cell to the left
SHIFT+ HOME Extends the selection to the first column
SHIFT+ ENTER Move to cell above
SHIFT+ Arrow keys or Pg up/Pg down Select a cell range
SHIFT+ ALT+ Right arrow Group rows/columns
SHIFT+ALT+ Left arrow Ungroup rows/columns
2|Page
Document type: Commonly used shortcut keys
User type: Windows OS
Version: supports up to MS Excel 2019
Level: Basic to Advanced
Suitable for: Interview preparation/Excel practical exam/Speeding-up manual job
Note 1: Functions/calculations/sum work with “=”. Hence start any function say, =ALT+ N+ V returns a
pivot table of the data.
Note 2: The plus sign with each shortcut represents “and”, it is simply combining the function and
the symbol together. Hence you press “CTRL and S” together and not CTRL plus(+) S.
CTRL functions
Keys Functions
CTRL+ - Delete Row/Column menu
CTRL+ ; Display date
CTRL+ ~ Show formulas/values
CTRL+ ‘ (apostrophe) Copy above formula
CTRL+ [ Go to precedent cells
CTRL+ ] Go to dependent cells
CTRL+ A Select all
CTRL+ B Bold
CTRL+ C Copy
CTRL+ D Fill down (Copy above)
CTRL+ E Flash fill
CTRL+ F Find
CTRL+ G Go to
CTRL+ H Replace
CTRL+ I Italic
CTRL+ K Insert hyperlink
CTRL+ L/CTRL+ T Create table
CTRL+ P Print preview
CTRL+ Q Quick analysis
CTRL+ R Fill the selected cells to the adjacent right cell
CTRL+ S Save document
CTRL+ U Underline
CTRL+ V Paste
CTRL+ W Close window
CTRL+ X Cut
CTRL+ Y Redo
CTRL+ Z Undo
1|Page
, EXCEL QUICK REFERENCE
CTRL+ 0 Hide column
CTRL+ 1 Format box
CTRL+ 5 Strike-through
CTRL+ 9 Hide row
CTRL+ F1 Min/Restore ribbon
CTRL+ F3 Name a cell
CTRL+ F4 Close window
CTRL+ F9 Minimize workbook
CTRL+ F10 Maximize window
CTRL+ F12 Open file
CTRL+ DEL Delete text to the end of the line
CTRL+ END Go to the last content
CTRL+ ENTER Fill selection entry
CTRL+ ALT+ V Paste special box
CTRL+ Arrow keys Got to the end of data range
CTRL+ Home Move to cell “A1”
CTRL+ Minus sign Delete selected cells
CTRL+ Pg up/Down Switch worksheets
CTRL+ Space Select column
CTRL+ Tab Switch workbooks
CTRL+ SHIFT+ L Auto filter
SHIFT functions
Keys Functions
SHIFT+ F2 Inserts or edits a cell comment
SHIFT+ F3 Displays the (Insert > Function) dialog box
SHIFT+ F4 Repeats the last find
SHIFT+ F5 Find/Replace dialogue box
SHIFT+ F6 Moves to the previous pane in a workbook (if the
window is split)
SHIFT+ F7 Thesaurus
SHIFT+ F8 Add to selection
SHIFT+ F9 Calculates active sheet
SHIFT+ F10 Displays the (Shortcut) menu for the selected
item
SHIFT+ F10+ m Delete column
SHIFT+ F11 Inserts a new worksheet
SHIFT+ F12 Saves, Displays the (File > Save As) dialog box if a
new workbook
SHIFT+ SPACEBAR Selects the current row
SHIFT+ TAB Moves to cell to the left
SHIFT+ HOME Extends the selection to the first column
SHIFT+ ENTER Move to cell above
SHIFT+ Arrow keys or Pg up/Pg down Select a cell range
SHIFT+ ALT+ Right arrow Group rows/columns
SHIFT+ALT+ Left arrow Ungroup rows/columns
2|Page
