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.
Action
Windows key combination
Mac key combination
GENERAL SHORTCUTS
Create a new workbook
Ctrl-N
⌘-N
Open a workbook
Ctrl-O
⌘-O
Save a workbook
Ctrl-S
⌘-S
Close a workbook
Ctrl-W
⌘-W
Print a workbook
Ctrl-P
⌘-P
Display the Find dialog box
Ctrl-F
Control-F
Display the Go To dialog box
F5
F5
Undo the last action
Ctrl-Z
⌘-Z or Control-Z
Redo the last action
Ctrl-Y
⌘-Y or Control-Y
Insert or edit a cell comment
Shift-F2
⌘-Shift-F2
Select all cells that contain comments
Ctrl-Shift-O
Spell-check the active worksheet or selected range
F7
F7
WORKSHEET NAVIGATION
Move one screen up / down
PgUp / PgDn
Page Up / Page Down or Fn-down arrow / Fn-up arrow
Move one screen to the left / right
Alt-PgUp / Alt-PgDn
Option-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-PgDn
Control-Page Down / Control-Page Up or Option-right arrow / Option-Left arrow
Move one cell up / down
up arrow / down arrow
up arrow / down arrow
Move to the next cell to the right
Tab
right arrow
Move to the cell to the left
Shift-Tab
left arrow
Move to the beginning of a row
Home
Home or Fn-left arrow
Move to the beginning of a worksheet
Ctrl-Home
Control-Home or Control-Fn-Left arrow
Move to the last cell that has content in it
Ctrl-End
Control-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 box
Ctrl-G or F5
Ctrl-G or F5
Switch between the worksheet, the Ribbon, the task pane, and Zoom controls
F6
F6
If more than one worksheet is open, switch to the next one
Ctrl-F6
⌘-~
WORKING WITH DATA
Select a row
Shift-Spacebar
Shift-Spacebar
Select a column
Ctrl-Spacebar
Control-Spacebar
Select an entire worksheet
Ctrl-A or Ctrl-Shift-Spacebar
⌘-A
Extend selection by a single cell
Shift-arrow key
Shift-arrow key
Extend selection down / up one screen
Shift-PgDn / Shift-PgUp
Shift-PgDn / Shift-PgUp or Shift-Fn-down arrow / Shift-Fn-up arrow
Extend selection to the beginning of a row
Shift-Home
Shift-Home or Shift-Fn-left arrow
Extend selection to the beginning of the worksheet
Ctrl-Shift-Home
Control-Shift-Home or Control-Shift-Fn-left arrow
Hide selected rows
Ctrl-9
⌘-9 or Control-9
Unhide hidden rows in a selection
Ctrl-Shift-(
⌘-Shift-( or Control-Shift-(
Hide selected columns
Ctrl-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 contents
Ctrl-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-Enter
Enter / Shift-Enter
Cancel your entry in a cell
Esc
Esc
Insert the current date
Ctrl-;
Control-;
Insert the current time
Ctrl-Shift-;
⌘-;
Display the Create Table dialog box
Ctrl-T or Ctrl-L
Control-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
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
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.
combination
combination
comments
worksheet or selected range
Fn-down arrow /
Fn-up arrow
left / right
Option-Page Down or
Fn-Option-up arrow /
Fn-Option-down arrow
the left / right
Control-Page Up or
Option-right arrow
/ Option-Left arrow
worksheet
Control-Fn-Left arrow
has content in it
Control-Fn-right arrow
left while in a cell
right while in a cell
the Ribbon, the task pane, and
Zoom controls
is open, switch to the next one
Ctrl-Shift-Spacebar
one screen
Shift-PgUp or
Shift-Fn-down arrow /
Shift-Fn-up arrow
beginning of a row
Shift-Fn-left arrow
beginning of the worksheet
Control-Shift-Fn-left arrow
a selection
in a selection
to the clipboard
into a cell
dialog box
Control-Option-V
move to the next cell down / up
dialog box
the cursor to the end of the text
⌘-Fn-right arrow
text from the cursor to the end
⌘-Shift-Fn-right arrow
for selected cells that contain data
(Windows) / Modify Cell Style dialog
box (Mac)
selection
two decimal places
no decimal places
month, and year
12-hour clock
and cell values
from the cell above into the
current one
workbooks that are open
Search box
cursor is on a chart
is on a chart
cursor is on a table
cursor is on an image
Popular Post
5G Radiation Is Harmful
December 14, 202110 hidden Office 365 features to boost
September 30, 2021iPhone 13 vs. iPhone 12, 12 Pro
September 19, 2021Popular Categories
Instagram Feeds
Follow on Instagram
Popular Tags
Archives
Recent Posts
Recent Comments
Archives
Categories
Meta