Blog Details

  • Home
  • Useful Excel keyboard shortcuts
admin September 6, 2021 0 Comments

Excel’s Ribbon is great for finding everything you might ever want to do in a spreadsheet, particularly things you don’t do frequently, like managing and querying data connections or automatically grabbing geographic statistics from the internet and inserting them into cells.

But if you’re looking to do things fast, you’ll find keyboard shortcuts far more useful. Why bother to lift your hands from the keyboard if you want to open or close a file, apply formatting to cells, navigate through workbooks, undo and redo actions, calculate all worksheets in all open workbooks, and more? With keyboard shortcuts you won’t have to.

There are keyboard shortcuts to accomplish a vast array of tasks in the Excel desktop client, in both the Windows and Mac versions.

ActionWindows key
combination
Mac key
combination
GENERAL SHORTCUTS
 Create a new workbookCtrl-N⌘-N
 Open a workbookCtrl-O⌘-O
 Save a workbookCtrl-S⌘-S
 Close a workbookCtrl-W⌘-W
 Print a workbookCtrl-P⌘-P
 Display the Find dialog boxCtrl-FControl-F
 Display the Go To dialog boxF5F5
 Undo the last actionCtrl-Z⌘-Z or Control-Z
 Redo the last actionCtrl-Y⌘-Y or Control-Y
 Insert or edit a cell commentShift-F2⌘-Shift-F2
 Select all cells that contain
comments
Ctrl-Shift-O 
 Spell-check the active
worksheet or selected range
F7F7
WORKSHEET NAVIGATION
 Move one screen up / downPgUp / PgDnPage Up / Page Down or
Fn-down arrow /
Fn-up arrow
 Move one screen to the
left / right
Alt-PgUp / Alt-PgDnOption-Page Up /
Option-Page Down or
Fn-Option-up arrow /
Fn-Option-down arrow
 Move one worksheet tab to
the left / right
Ctrl-PgUp / Ctrl-PgDnControl-Page Down /
Control-Page Up or
Option-right arrow
/ Option-Left arrow
 Move one cell up / downup arrow / down arrowup arrow / down arrow
 Move to the next cell to the rightTabright arrow
 Move to the cell to the leftShift-Tableft arrow
 Move to the beginning of a rowHomeHome or Fn-left arrow
 Move to the beginning of a
worksheet
Ctrl-HomeControl-Home or
Control-Fn-Left arrow
 Move to the last cell that
has content in it
Ctrl-EndControl-End or
Control-Fn-right arrow
 Move to the word to the
left while in a cell
Ctrl-left arrow⌘-left arrow
 Move to the word to the
right while in a cell
Ctrl-right arrow⌘-right arrow
 Display the Go To dialog boxCtrl-G or F5Ctrl-G or F5
 Switch between the worksheet,
the Ribbon, the task pane, and
Zoom controls
F6F6
 If more than one worksheet
is open, switch to the next one
Ctrl-F6⌘-~
WORKING WITH DATA
 Select a rowShift-SpacebarShift-Spacebar
 Select a columnCtrl-SpacebarControl-Spacebar
 Select an entire worksheetCtrl-A or
Ctrl-Shift-Spacebar
⌘-A
 Extend selection by a single cellShift-arrow keyShift-arrow key
 Extend selection down / up
one screen
Shift-PgDn / Shift-PgUpShift-PgDn /
Shift-PgUp or
Shift-Fn-down arrow /
Shift-Fn-up arrow
 Extend selection to the
beginning of a row
Shift-HomeShift-Home or
Shift-Fn-left arrow
 Extend selection to the
beginning of the worksheet
Ctrl-Shift-HomeControl-Shift-Home or
Control-Shift-Fn-left arrow
 Hide selected rowsCtrl-9⌘-9 or Control-9
 Unhide hidden rows in
a selection
Ctrl-Shift-(⌘-Shift-( or Control-Shift-(
 Hide selected columnsCtrl-0⌘-0 or Control-0
 Unhide hidden columns
in a selection
Ctrl-Shift-)⌘-Shift-) or Control-Shift-)
 Copy cell’s contents
to the clipboard
Ctrl-C⌘-C or Control-C
 Copy and delete cell’s contentsCtrl-X⌘-X or Control-X
 Paste from the clipboard
into a cell
Ctrl-V⌘-V or Control-V
 Display the Paste Special
dialog box
Ctrl-Alt-V⌘-Option-V or
Control-Option-V
 Finish entering data in a cell and
move to the next cell down / up
Enter / Shift-EnterEnter / Shift-Enter
 Cancel your entry in a cellEscEsc
 Insert the current dateCtrl-;Control-;
 Insert the current timeCtrl-Shift-;⌘-;
 Display the Create Table
dialog box
Ctrl-T or Ctrl-LControl-T
 When in the formula bar, move
the cursor to the end of the text
Ctrl-End⌘-End or
⌘-Fn-right arrow
 When in the formula bar, select all
text from the cursor to the end
Ctrl-Shift-End⌘-Shift-End or
⌘-Shift-Fn-right arrow
 Display Quick Analysis options
for selected cells that contain data
Ctrl-Q 
 Create, run, edit, or delete a macroAlt-F8Option-F8
FORMATTING CELLS AND DATA
 Display the Format Cells dialog boxCtrl-1⌘-1 or Control-1
 Display the Style dialog box
(Windows) / Modify Cell Style dialog
box (Mac)
Alt-‘Option-‘
 Apply a border to a cell or selectionCtrl-Shift-&⌘-Option-0
 Remove a border from a cell or
selection
Ctrl-Shift-_ (underscore)⌘-Option– (hyphen)
 Apply the Currency format with
two decimal places
Ctrl-Shift-$Control-Shift-$
 Apply the Number formatCtrl-Shift-~Control-Shift-~
 Apply the Percentage format with
no decimal places
Ctrl-Shift-%Control-Shift-%
 Apply the Date format using day,
month, and year
Ctrl-Shift-#Control-Shift-#
 Apply the Time format using the
12-hour clock
Ctrl-Shift-@Control-Shift-@
 Insert a hyperlinkCtrl-K⌘-K or Control-K
WORKING WITH FORMULAS
 Begin a formula==
 Insert an AutoSum functionAlt-=⌘-Shift-T
 Insert a functionShift-F3Shift-F3
 Toggle between displaying formulas
and cell values
Ctrl-`Control-`
 Copy and paste the formula
from the cell above into the
current one
Ctrl-‘Control-Shift-“
 Calculate all worksheets in all
workbooks that are open
F9F9
 Calculate the current worksheetShift-F9Shift-F9
 Expand or collapse the formula barCtrl-Shift-UControl-Shift-U
RIBBON NAVIGATION
 Display Ribbon shortcutsAlt 
 Go to the File tabAlt-F 
 Go to the Home tabAlt-H 
 Go to the Insert tabAlt-N 
 Go to the Page Layout tabAlt-P 
 Go to the Formulas tabAlt-M 
 Go to the Data tabAlt-A 
 Go to the Review tabAlt-R 
 Go to the View tabAlt-W 
 Put cursor in the Tell Me or
Search box
Alt-Q 
 Go to the Chart Design tab when
cursor is on a chart
Alt-JC 
 Go to the Format tab when cursor
is on a chart
Alt-JA 
 Go to the Table Design tab when
cursor is on a table
Alt-JT 
 Go to the Picture Format tab when
cursor is on an image
Alt-JP 
 Go to the Draw tab (if available)Alt-JI 
 Go to the Power Pivot tab (if available)Alt-B