Excel Shortcut Keys Free PDF Download

MS Excel Shortcuts

Using shortcuts saves a lot of time and it shows your proficiency in application usage. Here we have listed a complete list of Microsoft Excel keyboard shortcuts and their descriptions. These are categorized by Excel shortcuts with Function Keys, Control Keys and Miscellaneous. All these keys work with Excel 2019, 2016, 2013, Excel 2010, Excel 2007 and prior versions.

MS Excel Shortcut Keys PDF Download
MS Excel Shortcut Keys PDF Download

Download MS Excel Shortcut Free PDF

You can also download the complete Excel Shortcut Keys PDF for offline usage. This PDF file contains Excel Shortcuts listed below grouped by shortcuts keys with Function Key, Control Key, Shift Key and miscellaneous.

Shortcuts with Function Key

Function KeysDescription
F1Open “Microsoft Office Excel Help“.
F2Edit an Excel cell.
F3Displays the “Paste Name” dialog box.
F4Repeats the last action.
F5Opens “Go To” dialog box.
F6Switches between worksheet and menu / Ribbon.
F7Spelling Check.
F8Switches Extend mode on / off.
F9Calculates all worksheets in all open workbooks.
F10Highlights shortcut keys of Menu and Ribbon items.
F11Creates chart of selected cells.
F12Opens “Save As” dialog box.
Shortcuts with Function Key

Shortcuts with Control Key

Control KeysDescription
CTRL + 1Opens the “Format Cells” dialog box.
CTRL + 2Makes selected cell text bold.
CTRL + 3Makes selected cell text italic.
CTRL + 4Makes selected cell text underline.
CTRL + 5Makes selected cell text strikethrough.
CTRL + 6Displays / hides objects.
CTRL + 8Displays/hides outline symbols.
CTRL + 9Hides selected rows.
CTRL + 0Hides selected columns.
CTRL + ACTRL + A once will select current data range, second time it will select whole sheet and third time it will select whole worksheet.
CTRL + BMakes selected cell text bold.
CTRL + CCopy data.
CTRL + DFill Down command to paste topmost cell to all selected cells below it.
CTRL + FOpens “Find and Replace” dialog box with “Find” tab.
CTRL + GOpens “Go To” dialog box.
CTRL + HOpens “Find and Replace” dialog box with “Replace” tab.
CTRL + IMakes selected cell text italic.
CTRL + KOpens insert “Insert Hyperlink” dialog box.
CTRL + NOpens new workbook.
CTRL + OOpens “Open” dialog box.
CTRL + POpens “Print“dialog box.
CTRL + RFill Right” command to paste leftmost cell to all selected cells in the right side.
CTRL + SOpens “Save As” dialog box.
CTRL + TOpens “Create Table” dialog box.
CTRL + UMakes selected cell text underline.
CTRL + VPaste data.
CTRL + WClose current sheet.
CTRL + XCut data.
CTRL + YRedo last action.
CTRL + ZUndo last action.
CTRL + :Insert current system time.
CTRL + ;Insert current system date.
CTRL + “Copy value of cell above it.
CTRL + ‘Copy formula of cell above it.
Shortcuts with Control Key

Shortcuts with Shift Key

KeysDescription
Shift + F1What’s this? help
Shift + F2Add / edit comment
Shift + F3Insert function
Shift + F4Find next without opening find and replace dialogue box
Shift + F5Opens find and replace dialogue box and edit search term
Shift + F6Switch between workbook panes in split Window mode and switch between help task pane and window if no split Window
Shift + F7Open Research task panel
Shift + F8Select cells/cells range with Arrow Key
Shift + F9Recalculate formulas in active worksheet
Shift + F10Displays shortcut menu (Mouse right click options)
Shift + F11Add new worksheet in worksheet
Shift + F12Save workbook
Shortcuts with Shift Key

Miscellaneous Excel Shortcuts

KeysDescription
ESCEscapes dialog box, message box and discards text while writing in cell.
TABselects right side cell.
SHIFT + TABselects left side cell.
CTRL + TABSwitches to next tab in dialog box.
CTRL + SHIFT + TABSwitches to previous tab in dialog box.
BACKSPACEClears the whole content of the active cell if a cell selected. Clear a character to left side while editing or writing content in cell.
ENTERMoves to one cell downwards.
ALT + ENTERInserts a line break within a cell.
CTRL + ENTERPaste copied cell to all selected cells.
SHIFT + ENTERMoves to one cell upwards.
SPACEBARChecks / Unchecks the checkbox, radio button and works like ENTER key in dialog box.
CTRL + SPACEBARSelects an entire column in a worksheet.
SHIFT + SPACEBARSelects an entire row in a worksheet.
CTRL + SHIFT + SPACEBARCTRL + SHIFT + SPACEBAR once will select current data range, second time it will select whole sheet cells and third time it will select whole worksheet.
ALT +SPACEBARDisplays the Control menu for the Microsoft Office Excel window.
DELETERemoves the text data from cell (Not formatting).
HOMEMoves to the leftmost cell in the row.
CTRL + HOMEMoves to the top-left cell of a worksheet.
CTRL + SHIFT + HOMESelects cells to the beginning of the data range from current cell.
ENDMoves to the cell in the lower-right corner of the window (If SCROLL LOCK is turned on).
CTRL + ENDMoves to the last cell in the lower-right corner of window.
CTRL + SHIFT ENDSelects cells to the end of the data range from current cell.
PAGE UPMoves the current view of worksheet to one screen up.
CTRL + PAGE UPMoves to the previous sheet in workbook.
ALT + PAGE UPMoves the current view of worksheet to one screen to the left.
CTRL + SHIFT + PAGE UPMoves to the previous sheet in workbook.
PAGE DOWNMoves the current view of worksheet to one screen down.
CTRL + PAGE DOWNMoves to the next sheet in workbook.
ALT + PAGE DOWNMoves the current view of worksheet to one screen to the right.
CTRL + SHIFT + PAGE DOWNMoves to the next sheet in workbook.
ARROWMove to one cell left / right / up / down.
CTRL + ARROWMove to extreme left / right / up / down in a selected data range or blank sheet.
SHIFT + ARROWSelect / deselect one cell in the left / right / up / down from current cell.
CTRL + SHIFT + ARROWSelect / deselect current range of data or blank sheet in the left / right / up / down from current cell.
ALT + DOWN ARROWShow a list of data in cells above to current cell as a dropdown.
Miscellaneous Excel Shortcuts

F-Lock Excel Shortcuts

The above-updated list of Excel shortcuts works on all new versions of MS Excel. If your laptop has F-Lock key (Fn) on the keyboard you may need to press F-Lock key along with the original shortcut to perform the task.

For example, F1 with F-Lock key will open the Help dialogue box. The F-Lock key was not present in earlier keyboards but it was added to derive more commands from existing keys by Microsoft back in 2001.

Was this article helpful?
YesNo