Keyboard Shortcuts

Excel Keyboard Shortcuts for Windows and Mac

Using Excel Keyboard shortcut keys is the best best way to increase your productivity. You can save valuable time while performing tasks on MS Excel. Using the mouse to do all the tasks reduces your productivity. Hence, we will recommend you to use Excel Shortcuts rather than mouse.

In this page, we are providing the list of Excel Keyboard Shortcuts so that you can refer it and start using them in your day-to-day activities while working on Microsoft Excel.

We have segregated the list of shortcuts basis their functionalities. Please refer the below tables and start using it.

Working With Excel Files

FUNCTIONWINDOWSMAC
New fileCtrl + N⌘ + N
OpenCtrl + O⌘ + O
SaveCtrl + S⌘ + S
Save asF12⌘ + Shift + S
PrintCtrl + P⌘ + P
Print previewCtrl + F2
Close workbookCtrl + W⌘ + W
Close ExcelAlt + F4⌘ + Q

Working With Data

FUNCTIONWINDOWSMAC
CopyCtrl + C⌘ + C
CutCtrl + X⌘ + X
FindCtrl + F⌘ + F
Find and replaceCtrl + HControl + H
Find nextShift + F4⌘ + G
Find previousCtrl + Shift + F4⌘ + Shift + G
PasteCtrl + V⌘ + V
Paste specialCtrl + Alt + VControl + ⌘ + V
RedoCtrl + Y⌘ + Y
UndoCtrl + Z⌘ + Z

Moving Within a Workbook

FUNCTIONWINDOWSMAC
Move right[icon name="arrow-right" class="" unprefixed_class=""][icon name="arrow-right" class="" unprefixed_class=""]
Move left[icon name="arrow-left" class="" unprefixed_class=""][icon name="arrow-left" class="" unprefixed_class=""]
Move up [icon name="arrow-up" class="" unprefixed_class=""][icon name="arrow-up" class="" unprefixed_class=""]
Move down[icon name="arrow-down" class="" unprefixed_class=""][icon name="arrow-down" class="" unprefixed_class=""]
Move right to next full cellCtrl + [icon name="arrow-right" class="" unprefixed_class=""]Ctrl + [icon name="arrow-right" class="" unprefixed_class=""]
Move left to next full cellCtrl + [icon name="arrow-left" class="" unprefixed_class=""]Ctrl + [icon name="arrow-left" class="" unprefixed_class=""]
Move up to next full cellCtrl + [icon name="arrow-up" class="" unprefixed_class=""]Ctrl + [icon name="arrow-up" class="" unprefixed_class=""]
Move down to next full cellCtrl + [icon name="arrow-down" class="" unprefixed_class=""]Ctrl + [icon name="arrow-down" class="" unprefixed_class=""]
Move to beginning of row HomeHomeFn + [icon name="arrow-left" class="" unprefixed_class=""]
Move to last cellCtrl + EndFn + Crtl + [icon name="arrow-right" class="" unprefixed_class=""]
Move to first cellCtrl + HomeFn + Option + [icon name="arrow-left" class="" unprefixed_class=""]
Scroll right one screenAlt + PgDnFn + Option + [icon name="arrow-up" class="" unprefixed_class=""]
Scroll left one screenAlt + PgUpFn + Option + [icon name="arrow-down" class="" unprefixed_class=""]
Scroll up one screenPgUpFn + [icon name="arrow-up" class="" unprefixed_class=""]
Scroll down one screenPgDnFn + [icon name="arrow-down" class="" unprefixed_class=""]
End modeEndFn + [icon name="arrow-right" class="" unprefixed_class=""]

Selecting Cells

FUNCTIONWINDOWSMAC
Go to cellCtrl + GControl + G
Select allCtrl + A⌘ + A
Select rowShift + SpaceShift + Space
Select columnCtrl + SpaceControl + Space
Select current regionCtrl + Shift + *Shift + Control + Space
Select current arrayCtrl + /Control + /
Select all precedentsCtrl + Shift + {Control + Shift + {
Select direct dependentsCtrl + ]Control + ]
Select all dependentsCtrl + Shift + }Control + Shift + }
Select only visible cellsAlt + ;⌘ + Shift + Z
Add cell range to selectionShift + ClickShift + Click
Add one-off cells to selectionCtrl + Click⌘ + Click
Move active cell right to non-adjacent selectionCtrl + Alt + [icon name="arrow-right" class="" unprefixed_class=""]Ctrl + Option + [icon name="arrow-right" class="" unprefixed_class=""]
Move active cell left to non-adjacent selectionCtrl + Alt + [icon name="arrow-left" class="" unprefixed_class=""]Ctrl + Option + [icon name="arrow-left" class="" unprefixed_class=""]
Move selection one column leftOption + Tab
Move selection one column right Option + Shift + Tab
Toggle selection add modeShift + F8Fn + Shift + F8
Clear selectionEscEsc
Expand selection to the rightShift + [icon name="arrow-right" class="" unprefixed_class=""]Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Expand selection to the leftShift + [icon name="arrow-left" class="" unprefixed_class=""]Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Expand selection upShift + [icon name="arrow-up" class="" unprefixed_class=""]Shift + [icon name="arrow-up" class="" unprefixed_class=""]
Expand selection downShift + [icon name="arrow-down" class="" unprefixed_class=""]Shift + [icon name="arrow-down" class="" unprefixed_class=""]
Expand selection to last full cell to the rightCtrl + Shift + [icon name="arrow-down" class="" unprefixed_class=""]⌘ + Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Expand selection to last full cell to the leftCtrl + Shift + [icon name="arrow-left" class="" unprefixed_class=""]⌘ + Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Expand selection to last full cell upCtrl + Shift + [icon name="arrow-up" class="" unprefixed_class=""]⌘ + Shift + [icon name="arrow-up" class="" unprefixed_class=""]
Expand selection to last full cell downCtrl + Shift + [icon name="arrow-down" class="" unprefixed_class=""]⌘ + Shift + [icon name="arrow-down" class="" unprefixed_class=""]
Expand selection up full screenShift + PgUpFn + Shift + [icon name="arrow-up" class="" unprefixed_class=""]
Expand selection down full screenShift + PgDnFn + Shift + [icon name="arrow-down" class="" unprefixed_class=""]
Expand selection to beginning of rowShift + HomeFn + Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Expand selection to first worksheet cellCtrl + Shift + HomeFn + Control + Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Expand selection to last worksheet cellCtrl + Shift + EndFn + Control + Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Toggle extend selection modeF8Fn + F8
Select only cells with commentsCtrl + Shift + OFn + Control + Shift + O
Select row differencesCtrl + \Control + Shift + |
Select direct precedentsCtrl + [Control + [

Working With Active Cells

FUNCTIONWINDOWSMAC
Only select active cellShift + BackspaceShift + Delete
Show active cellCtrl + Backspace⌘ + Delete
Move active cell clockwise Ctrl + .Control + .
Move active cell down EnterShift + Return
Move active cell right TabTab
Move active cell leftShift + TabShift + Tab

Editing Formulas

FUNCTIONWINDOWSMAC
Edit active cellF2Control + U
Cancel entryEscEsc
Delete to end of lineCtrl + DeleteControl + Delete
Delete character in back of cursorBackspaceBackspace
Delete character in front of cursorDeleteFn + Delete
New line within cellAlt + EnterControl + Option + Return
Add character to the right to selectionShift + [icon name="arrow-right" class="" unprefixed_class=""]Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Add character to the left to selectionShift + [icon name="arrow-left" class="" unprefixed_class=""]Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Move one word rightShift + [icon name="arrow-right" class="" unprefixed_class=""]Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Move one word leftCtrl+ [icon name="arrow-left" class="" unprefixed_class=""]Control + [icon name="arrow-left" class="" unprefixed_class=""]
Add word to right to selectionCtrl+ Shift + [icon name="arrow-right" class="" unprefixed_class=""]Control + Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Add word to left to selectionCtrl+ Shift + [icon name="arrow-left" class="" unprefixed_class=""]Control + Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Select from beginning of cell to current positionShift + HomeFn + Shift + [icon name="arrow-left" class="" unprefixed_class=""]
Select from current position to end of cellShift + EndFn + Shift + [icon name="arrow-right" class="" unprefixed_class=""]
Insert commentShift + F2Fn + Shift + F2

Entering Data

FUNCTIONWINDOWSMAC
Commit and move downEnterReturn
Commit and move upShift + EnterShift + Return
Commit and move rightTabTab
Commit and move leftShift + TabShift + Tab
Commit and stay in same cell Ctrl + EnterControl + Return
Enter data in multiple cellsCtrl + EnterControl + Return
Insert current dateCtrl + ;Control + Return
Insert current dateCtrl + ;Control + ;
Insert current timeCtrl + Shift + :Control + Shift + :
Fill from cell aboveCtrl + DControl + Shift + :
Fill from cell aboveCtrl + DControl + D
Fill from cell to leftCtrl + RControl + R
Fill formula from cell aboveCtrl + 'Control + '
HyperlinkCtrl + K⌘ + K
Display AutocompleteAlt + [icon name="arrow-down" class="" unprefixed_class=""]Option + [icon name="arrow-down" class="" unprefixed_class=""]

Using the Ribbon

FUNCTIONWINDOWSMAC
Show / hide RibbonCtrl + F1⌘ + Option + R
Enter Windows hotkey combinationAlt
HelpF1

Formatting Cells

FUNCTIONWINDOWSMAC
Open format dialogueCtrl + 1⌘ + 1
Re-apply formatF4Control + Y
Align centerAlt + H + A + C⌘ + E
Align leftAlt + H + A + L⌘ + L
Align rightAlt + H + A + R⌘ + R
IndentAlt + H + 6Control + Option + Tab
Un-indentAlt + H + 5Control + Option + Shift + Tab
Increase font sizeAlt + H + FG ⌘ + Shift + >
Decrease font sizeAlt + H + FK⌘ + Shift + <
Format as generalCtrl + Shift + ~Control + Shift + ~
Format as currencyCtrl + Shift + $Control + Shift + $
Format as percentage Ctrl + Shift + %Control + Shift + %
Format as scientificCtrl + Shift + ^Control + Shift + ^
Format as dateCtrl + Shift + #Control + Shift + #
Format as timeCtrl + Shift + @Control + Shift + @
Format as numberCtrl + Shift + ! Control + Shift + !
BoldCtrl + B⌘ + B
ItalicCtrl + I⌘ + I
UnderlineCtrl + U⌘ + U
Strikethrough Ctrl + 5⌘ + Shift + X
Add shadow⌘ + Shift + W
Add outline⌘ + Shift + D
Border allCtrl + Shift + & ⌘ + Option +&
Border rightAlt + R⌘ + Option + [icon name="arrow-right" class="" unprefixed_class=""]
Border leftAlt + L⌘ + Option + [icon name="arrow-left" class="" unprefixed_class=""]
Border topAlt + T⌘ + Option + [icon name="arrow-up" class="" unprefixed_class=""]
Border bottomAlt + B⌘ + Option + [icon name="arrow-down" class="" unprefixed_class=""]
Border interior horizontalAlt + H
Border interior vertical Alt + V
Remove bordersCtrl + Shift + _ ⌘ + Option + _

Calculations

FUNCTIONWINDOWSMAC
Toggle reference (relative, mixed and absolute)F4⌘ + T
Calculate all sheetsF9Fn + F9
Calculate only active sheetShift + F9Fn + Shift + F9
AutosumAlt + =⌘ + Shift + T
Insert functionShift + F3Fn + Shift + F3
Show function argumentsCtrl + Shift + A Control + Shift + A
Commit array formulaCtrl + Shift + Enter Control + Shift + Return
Evaluate part of formulaF9Fn + F9
Toggle formula barCtrl + Shift + UControl + Shift + U
Show formula builderCtrl + AControl + A
Define nameCtrl + F3Control + L
Create nameCtrl + Shift + F3Control + Shift + F3
Paste name into formulaF3

Worksheets and Workbooks

FUNCTIONWINDOWSMAC
New worksheetShift + F11Shift + F11
Next worksheetCtrl + PgDnFn + Control + [icon name="arrow-down" class="" unprefixed_class=""]
Previous worksheetCtrl + PgUpFn + Control + [icon name="arrow-up" class="" unprefixed_class=""]
Next workbookCtrl + TabControl + Tab
Previous workbookCtrl + Shift + TabControl + Shift + Tab
Next paneF6F6
Previous paneShift + F6Shift + F6
Minimize windowCtrl + F9⌘ + M
Maximize windowCtrl + F1
Select multiple worksheets Shift + ClickShift + Click
Select one-off single worksheets Ctrl + Click⌘ + Click

Rows and Columns

FUNCTIONWINDOWSMAC
Insert rows / columns dialogue Ctrl + Shift + +Control + I
Insert rowsCtrl + Shift + +Control + I
Insert columnsCtrl + Shift + +Control + I
Delete dialogCtrl + -Control + -
Delete rowsCtrl + -Control + -
Delete columnsCtrl + -Control + -
Delete cellsCtrl + -Control + -
Clear cellsDeleteFn + Delete
GroupAlt + Shift + [icon name="arrow-right" class="" unprefixed_class=""]⌘ + Shift + K
UngroupAlt + Shift + [icon name="arrow-left" class="" unprefixed_class=""]⌘ + Shift + J
Group dialogAlt + Shift + [icon name="arrow-right" class="" unprefixed_class=""]⌘ + Shift + K
Ungroup dialogAlt + Shift + [icon name="arrow-left" class="" unprefixed_class=""]⌘ + Shift + J
Hide columnsCtrl +Control +
Hide rowsCtrl + 9Control + 9
Unhide rowsCtrl + Shift + 9Control + Shift + 9
Unhide columnsCtrl + Shift + Control + Shift +
Toggle outline symbolsCtrl + 8Control + 8

Charts, Filters, and Pivots

FUNCTIONWINDOWSMAC
Create chartAlt + F1Fn + Option + F1
Create chart (new sheet) F11Fn + F11
AutofilterCtrl + Shift + L ⌘ + Shift + F
Open filtersAlt + [icon name="arrow-down" class="" unprefixed_class=""]Option + [icon name="arrow-down" class="" unprefixed_class=""]
Insert tableCtrl + TControl + T
Group pivot table itemsAlt + Shift +[icon name="arrow-right" class="" unprefixed_class=""]⌘ + Shift + K
Ungroup pivot table itemsAlt + Shift +[icon name="arrow-left" class="" unprefixed_class=""]⌘ + Shift + J
Hide pivot table itemCtrl + -Ctrl + -
Create pivot chartAlt + F1
Create pivot chart on new sheetF11Fn + F11
Pivot table wizardAlt + D + P⌘ + Option + P

Helper Modules

FUNCTIONWINDOWSMAC
Spell checkF7F7
ThesaurusShift + F7Shift + F7
VBA editorAlt + F11 Fn + Option + F11
MacrosAlt + F8Fn + Option + F8
Hide or showCtrl + 6Control + 6
DuplicateCtrl + D⌘ + D
Modify cell styleAlt + '⌘ + Shift + L
Control menuAlt + Space?
Shortcut menuShift + F1Fn + Shift + F1

LEAVE A REPLY

Please enter your comment!
Please enter your name here