Excel Keyboard Shortcuts
Navigate, select, fill and format faster in Microsoft Excel. Most also work in Google Sheets.
Excel Keyboard Shortcuts — 21 shortcuts
Action
Windows
Mac
Save the file
WindowsCtrl+S
Mac⌘ Cmd+S
Edit the selected cell
WindowsF2
Mac⌃ Control+U
Autosum a column
WindowsAlt+=
Mac⌘ Cmd+⇧ Shift+T
Paste values only
WindowsCtrl+Alt+V
Mac⌃ Control+⌘ Cmd+V
Insert today’s date
WindowsCtrl+;
Mac⌃ Control+;
Insert a row
WindowsCtrl+Shift++
Mac⌘ Cmd+⇧ Shift++
Select the whole column
WindowsCtrl+Space
Mac⌃ Control+Space
Select the whole row
WindowsShift+Space
Mac⇧ Shift+Space
Go to cell A1
WindowsCtrl+Home
Mac⌃ Control+Fn+←
Move to the next sheet
WindowsCtrl+PgDn
Mac⌥ Option+→
Add a new sheet
WindowsShift+F11
MacFn+⇧ Shift+F11
Delete the row
WindowsCtrl+-
Mac⌘ Cmd+-
Fill down
WindowsCtrl+D
Mac⌘ Cmd+D
Fill right
WindowsCtrl+R
Mac⌘ Cmd+R
Format as currency
WindowsCtrl+Shift+4
Mac⌃ Control+⇧ Shift+4
Format as a percentage
WindowsCtrl+Shift+5
Mac⌃ Control+⇧ Shift+5
Open format cells
WindowsCtrl+1
Mac⌘ Cmd+1
Lock a cell reference
WindowsF4
Mac⌘ Cmd+T
Show the formulas
WindowsCtrl+`
Mac⌃ Control+`
Add a filter
WindowsCtrl+Shift+L
Mac⌘ Cmd+⇧ Shift+F
Insert a function
WindowsShift+F3
MacFn+⇧ Shift+F3
Frequently asked questions
What is the keyboard shortcut to save the file in Excel?
On Windows, press Ctrl + S. On Mac, press Cmd + S.
What is the keyboard shortcut to edit the selected cell in Excel?
On Windows, press F2. On Mac, press Control + U.
What is the keyboard shortcut to autosum a column in Excel?
On Windows, press Alt + =. On Mac, press Cmd + Shift + T.
What is the keyboard shortcut to paste values only in Excel?
On Windows, press Ctrl + Alt + V. On Mac, press Control + Cmd + V.
What is the keyboard shortcut to insert today’s date in Excel?
On Windows, press Ctrl + ;. On Mac, press Control + ;.