Full List Of Excel Shortcuts

Keyboard short-cuts can make life much easier when using Excel… You may already have your favourites and use them all the time but here is a list of them all.

F1 Display Excel Help
CTRL+F1 Display or hide the ribbon
ALT+F1 Create a chart using selected data range
ALT+SHIFT+F1 Insert new worksheet
F2 Edit active cell with cursor placed at the end of the cell’s contents
SHIFT+F2 Add or Edit a comment
CTRL+F2 Display Print Preview
F3 Display Paste Name dialog box if there are any
SHIFT+F3 Display Insert Function dialog box
F4 Repeat last command
CTRL+F4 Close selected workbook window
ALT+F4 Close Excel
F5 Display GoTo dialog box
CTRL+F5 Restore the window size of the selected workbook window
F6 Switch between worksheet, ribbon, task pane, and Zoom controls
CTRL+F6 Switch to the next workbook window
F7 Display the Spelling dialog box to check spelling in the active worksheet or selected range
CTRL+F7 Move the workbook window when it is not maximized using the arrow keys before pressing ENTER to finish or ESC to cancel
F8 Extend the current selection using the arrow keys
SHIFT+F8 Add a non-adjacent cell or range to a selection of cells using the arrow keys
CTRL+F8 Resize a window that is not maximised using the arrow keys
ALT+F8 Display the Macro dialog box to create, run, edit or delete a macro
F9 Calculate all worksheets in all open workbooks
SHIFT+F9 Calculate Active Worksheet
CTRL+ALT+F9 Calculate all worksheets in all open workbooks
CTRL+ALT+SHIFT+F9 Recheck dependent formulas then calculate all cells in all open workbooks
CTRL+F9 Minimise a workbook window to an icon
F10 or ALT Toggles key tips on or off
SHIFT+F10 Display shortcut menu for a selected item
ALT+SHIFT+F10 Display the menu or message for an Error Checking button
CTRL+F10 Maximize or restore the selected workbook window
F11 Creates a chart using the currently selected data
SHIFT+F11 Insert New Worksheet
ALT+F11 Open VBA Editor
F12 Save As
CTRL+PgUp Switch to next worksheet to the right
CTRL+PgDn Switch to next worksheet to the left
CTRL+SHIFT+( Unhide hidden rows within selection
CTRL+SHIFT+& Apply outline border to the selected cells
CTRL+SHIFT_ Remove outline border from the selected cells
CTRL+SHIFT+~ Apply General number format
CTRL+SHIFT+$ Apply Currency format with two decimal places (negative numbers have parentheses)
CTRL+SHIFT+% Apply Percentage format with no decimal places
CTRL+SHIFT+^ Apply Scientific number format with two decimal places
CTRL+SHIFT+# Apply Date format (day, month, and year)
CTRL+SHIFT+@ Apply Time format (hour and minute, and AM or PM)
CTRL+SHIFT+! Apply Number format with two decimal places, thousands separator, and minus sign (-) for negative values
CTRL+SHIFT+* Select the current region around the active cell (the data area enclosed by blank rows and blank columns or an entire PivotTable report
CTRL+SHIFT+: Enter current time into the cell
CTRL+SHIFT+” Copy value from the cell above the active cell into the cell or the Formula Bar
CTRL+SHIFT+Plus (+) Display the Insert dialog box to insert blank cells
CTRL+Minus (-) Display the Delete dialog box to delete the selected cells
CTRL+; Enter the current date into the selected cell
ALT+; Selects visible cells only within the current selection
CTRL+` Alternate between displaying cell values and displaying formulas
CTRL+’ Copy a formula from the cell above the active cell into the cell or the Formula Bar
CTRL+1 Display Format Cells dialog box
CTRL+2 or CTRL+B Apply or remove bold formatting
CTRL+3 or CTRL+I Apply or remove italic formatting
CTRL+4 or CTRL+U Apply or remove underlining
CTRL+5 Apply or remove strikethrough
CTRL+6 Alternate between hiding and displaying objects
CTRL+8 Display or hide the outline symbols
CTRL+9 Hide selected rows
CTRL+0 Hide selected columns
CTRL+A Select the current region. Pressing CTRL+A a second time or if there is no data selects the entire worksheet
CTRL+C Copy selected cells
CTRL+D Use the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below
CTRL+F or SHIFT+F5 Display Find and Replace dialog box, with the Find tab selected.
CTRL+SHIFT+F  Open Format Cells dialog box with the Font tab selected.
SHIFT+F4 Repeat last Find action
CTRL+H DisplayFind and Replace dialog box, with the Replace tab selected
CTRL+G or F5 Display Go To dialog box
CTRL+K Display the Insert or Edit Hyperlink dialog box
CTRL+L Display the Create Table dialog box
CTRL+N Create a new blank workbook
CTRL+O Display Open dialog box to open or find a file
CTRL+SHIFT+O Select all cells that contain comments
CTRL+P Display the Print tab
CTRL+SHIFT+P Open Format Cells dialog box with the Font tab selected
CTRL+R Use the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right
CTRL+S Save the active file with its current file name, location, and file format
CTRL+T Display Create Table dialog box
CTRL+SHIFT+U Switch between expanding and collapsing of the formula bar
CTRL+V Paste contents of the Clipboard after either copying or cuttingCTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program.
CTRL+W Close the selected workbook window
CTRL+X Cut the selected cells
CTRL+Y Repeat the last command or action, if possible
CTRL+Z Undo the last command or to delete last typed entry
CTRL+BACKSPACE Navigate to your selected cell if it is out of view
5/5 (1)

Please rate this