Pinterest Pixel

333 Excel Shortcuts for Windows and Mac

Microsoft Excel is a powerful tool which has many Excel keyboard shortcuts to make you faster and... read more

Download Excel Workbook
Bryan
Posted on

Overview

333 Excel Shortcuts for Windows and Mac

Microsoft Excel is a powerful tool which has many Excel keyboard shortcuts to make you faster and more efficient.

Instead of memorizing all of these useful Excel keyboard shortcuts, we have compiled a list for you so you can apply to your Excel worksheet straight away.

Below we have created a FREE downloadable PDF cheat sheet and a full searchable list of the 333 Excel Shortcuts for both in Windows and Mac for you!

Download it, print it and post it to your wall so that you can get a quick reminder of the best Excel keyboard shortcuts out there. Share it with your friends and colleagues as well and they will thank you for it!

 

Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below…for FREE!

333 Excel Shortcuts for Windows and Mac

333 Excel Shortcuts for Windows and Mac

DOWNLOAD THE 333 EXCEL SHORTCUTS PDF CHEAT SHEET

We also have a free video tutorial on the 333 Excel Keyboard Shortcuts which you can view here:

Watch it on YouTube and give it a thumbs-up!

Download the YouTube Excel practice file

 

Full List of the 333 Excel Keyboard Shortcuts for Windows and Mac!

Here is the list of the Microsoft Excel Keyboard Shortcuts for Windows and Mac.

Windows keyboard shortcuts are on the left side, while the Mac keyboard shortcuts are on the right.

Or try to filter them out...

Frequent Shortcuts

Add bordersCtrl Shift & 0
Add or remove filterCtrl Shift L F
BoldCtrl B B
Center align cell contentsAlt H A C E
Choose a fill colorAlt H H
Close workbookCtrl W W
CopyCtrl C C
CutCtrl X X
Delete columnCtrl - -
Display find and replace (find)Ctrl F F
Display find and replace (replace)Ctrl H^ H
Find next matchShift F4 G
Find previous matchCtrl Shift F4 G
Hide selected columnsCtrl 0 0
Hide selected rowsCtrl 9 9
Left align cell contentsAlt H A L L
New workbookCtrl N N
Open context menuShift F10Fn F10
Open workbookCtrl O O
PasteCtrl V V
PrintCtrl P P
Remove cell contentsDeleteFn Delete
Right align cell contentsAlt H A R R
Save workbookCtrl S S
UndoCtrl Z Z
Unhide columnsCtrl Shift 0 0
Unhide rowsCtrl Shift 9 9
Zoom inCtrl Alt + +
Zoom outCtrl Alt - -

Inside the Ribbon

Activate selected buttonSpaceSpace
Expand / collapse the ribbonCtrl F1 R
Move to left commandShift Tab Tab
Move to right commandTabTab
Move to submenu when a main menu is open
Move to the next command in open menu
Open a context menuShift F10Fn F10
Open the list for selected command
Open the menu for selected buttonAlt
Select active tab and activate access keysAlt
Select active tab and activate access keysF10
See also  How to View Multiple Worksheets in Excel

Cell Navigation

Cycle through text boxes / imagesCtrl Alt 5
Enter the End modeEndFn
Exit navigation of text boxes / imagesEscEsc
Extend selection of cells to last used cell Ctrl Shift EndFn
Move one cell down
Move one cell left
Move one cell right
Move one cell up
Move one screen down in worksheetPgDnFn
Move one screen left in worksheetAlt PgUpFn
Move one screen right in worksheetAlt PgDnFn
Move one screen up in a worksheetPgUpFn
Move to beginning of a worksheetCtrl HomeFn
Move to bottom edge of data regionCtrl
Move to cell in the upper left corner Home ScrLkFn
Move to last cell on a worksheetCtrl EndFn
Move to left edge of data regionCtrl
Move to next cell to the rightTabTab
Move to next sheet in workbookCtrl PgDnFn
Move to previous sheet in workbookCtrl PgUpFn
Move to right edge of data regionCtrl
Move to the previous cellShift Tab Tab
Move to top edge of data regionCtrl
Open list of choices on a cellAlt
Show Go To DialogCtrl G G

Formatting Cells

Apply Currency formatCtrl Shift $ $
Apply Date formatCtrl Shift # #
Apply General formatCtrl Shift ~ ~
Apply Number formatCtrl Shift ! !
Apply or remove bold formattingCtrl B B
Apply or remove italic formattingCtrl I I
Apply or remove strikethrough formattingCtrl 5 X
Apply or remove underlineCtrl U U
Apply outline border to cellsCtrl Shift & 0
Apply Percentage formatCtrl Shift % %
Apply Scientific formatCtrl Shift ^ ^
Apply Time formatCtrl Shift @ @
Check spellingF7Fn F7
Copy formula from above cellCtrl ' '
Copy selected cellsCtrl C C
Cut selected cellsCtrl X X
Display the Quick Analysis optionsCtrl Q
Edit active cellF2 U
Enter current dateCtrl ; ;
Enter current timeCtrl Shift ; ;
Fill down from cell aboveCtrl D^ D
Fill right from cell leftCtrl R^ R
Format fonts in Format Cells dialogCtrl Shift F F
Insert a noteShift F2Fn F2
Insert TableCtrl T T
Insert threaded commentCtrl Shift F2
Open and edit a noteShift F2Fn F2
Open and reply to threaded commentCtrl Shift F2
Open Delete dialog to delete cellsCtrl - -
Open Format Cells dialogCtrl 1 1
Open Insert dialog to insert cellsCtrl Shift + +
Open Paste Special dialogCtrl Alt V^ V
Open the Insert hyperlink dialogCtrl K K
Paste selected cellsCtrl V V
Remove outline border to selected cellsCtrl Shift _ _
Show or hide objectsCtrl 6 6
Show or hide outline symbolsCtrl 8^ 8
Toggle formulas on and offCtrl ` `

Making Selections

Complete cell entry and select above cellShift Enter Return
Extend cell selection downwardsShift
Extend cell selection to the leftShift
Extend cell selection to the rightShift
Extend cell selection to topCtrl Shift HomeFn
Extend cell selection upwardsShift
Extend selection to last bottom cellCtrl Shift
Extend selection to last left cellCtrl Shift
Extend selection to last right cellCtrl Shift
Extend selection to last top cellCtrl Shift
Fill selected cell range with the current entryCtrl Enter Return
Repeat last actionCtrl Y Y
Select all objects when an object is selectedCtrl Shift Space
Select current and next worksheetCtrl Shift PgDn
Select current and previous worksheetCtrl Shift PgUp
Select current arrayCtrl /^ /
Select current region around the cellCtrl Shift * Space
Select differences in columnCtrl Shift | |
Select differences in rowCtrl \^ \
Select entire columnCtrl Space Space
Select entire rowShift Space Space
Select entire worksheetCtrl A A
Select first command on menuHomeFn
Select only visible cellsAlt ; Z
Start a new lineAlt Enter Return
Toggle add to selection modeShift F8Fn F8
Toggle extend modeF8Fn F8
Undo last actionCtrl Z Z
See also  How to Find Duplicates in Excel

Working with Formulas

Autosum selection of cellsAlt = T
Calculate active worksheetShift F9Fn F9
Calculate all worksheetsF9Fn F9
Cancel entry in formula barEscEsc
Check your formulaF9Fn F9
Complete entry in formula barEnterReturn
Copy the value from the cell aboveCtrl Shift " "
Create chart in a new sheetF11Fn F11
Create embedded chartAlt F1Fn F1
Define name for referencesCtrl F3Fn F3
Display function arguments dialogCtrl A^ A
Display message for error checking buttonAlt Shift F10
Edit active cellF2 U
Expand or collapse formula barCtrl Shift U U
Force Calculate all worksheetsCtrl Alt F9
Input array formulaCtrl Shift Enter Return
Insert a functionShift F3Fn F3
Insert function argumentsCtrl Shift A A
Invoke Flash FillCtrl E
Move to end of text when in the formula barCtrl EndFn
Move to next record of data formEnterReturn
Open macro dialogAlt F8Fn F8
Open Visual Basic For Applications (VBA) EditorAlt F11Fn F11
Paste a nameF3
Select text in formula bar to endCtrl Shift EndFn
Toggle absolute or relative referencesF4 T

Ribbon Tabs

Go to Search fieldAlt Q
Open Data tabAlt A
Open File pageAlt F
Open Formulas tabAlt M
Open Home tabAlt H
Open Insert tabAlt N
Open Page Layout tabAlt P
Open Review tabAlt R
Open View tabAlt W

Power Pivot

Cancel process or close dialogCtrl Esc
Copy selected dataCtrl C C
Delete tableCtrl D^ D
Move tableCtrl M
Move to first cell in tableCtrl HomeFn
Move to first cell of rowCtrl
Move to last cell in tableCtrl EndFn
Move to last cell of rowCtrl
Move to next tableCtrl PgDnFn
Move to previous tableCtrl PgUpFn
Move to the first cell of columnCtrl
Move to the last cell of columnCtrl
Open AutoFilter Menu dialogAlt
Open Go To dialogF5Fn F5
Recalculate all formulasF9Fn F9
Redo last actionCtrl Y Y
Rename tableCtrl R^ R
Save fileCtrl S S
Select cells to first column cellShift PgDnFn
Select cells to first row cellShift HomeFn
Select cells to last column cellShift PgUpFn
Select cells to last row cellShift EndFn
Select current columnCtrl Space Space
Select current rowShift Space Space
Select entire tableCtrl A A
Undo last actionCtrl Z Z
See also  How to Wrap Text in Excel - 4 Quick & Easy Methods

Function Keys

Add non-adjacent cell to a selectionShift F8Fn F8
Add or update cell noteShift F2Fn F2
Calculate all worksheetsF9Fn F9
Calculates active worksheetShift F9Fn F9
Close ExcelAlt F4 Q
Close workbook windowCtrl F4 W
Create chart of the selected rangeF11Fn F11
Display message for error checking buttonAlt Shift F10
Display shortcut menuShift F10Fn F10
Edit the active cell
F2 U
Force calculate all worksheetsCtrl Alt F9
Insert new worksheetAlt Shift F1Fn F11
Insert new worksheetShift F11Fn F11
Maximize workbookCtrl F10Fn F10
Minimize workbookCtrl F9 M
Open Excel HelpF1 /
Open Go To dialogF5Fn F5
Open Insert Function dialogShift F3Fn F3
Open Macro dialogAlt F8Fn F8
Open Paste Name dialogF3
Open print previewCtrl F2 P
Open Save As dialogF12 S
Open Spelling dialogF7Fn F7
Open ThesaurusShift F7Fn F7
Open VBA EditorAlt F11Fn F11
Perform moving of windowCtrl F7
Perform resizing of windowCtrl F8
Repeat last actionF4 Y
Restore window size of workbookCtrl F5
Show or hide ribbonCtrl F1 R
Switch panesF6Fn F6
Switch panes in reverseShift F6Fn F6
Switch to next workbookCtrl F6 Tab
Toggle extend modeF8Fn F8
Toggle key tipsF10

Drag and Drop

Drag and copyCtrl Drag Drag
Drag and cutDragDrag
Drag and insertShift Drag Drag
Drag and insert copyCtrl Shift Drag Drag
Drag selection to worksheetAlt Drag Drag
Drag to duplicate the worksheetCtrl Drag Drag

Macros and VBA

Autocomplete codeCtrl Space
Delete line of codeCtrl Y
Open Intellisense DropdownCtrl J
Open Visual Basic For Applications (VBA) EditorAlt F11Fn F11
Redo last actionAlt E R
Show quick infoCtrl I
Step through codeF8 I

Pivot Table

Group selected itemsAlt Shift
Hide selected item or fieldCtrl -
Open Calculated Field dialogShift Ctrl =
Open field list for cellAlt
Open old PivotTable WizardAlt D P
Refresh Pivot TableCtrl Alt F5
Refresh Pivot TableAlt F5
Select entire tableCtrl Shift *
Select first item in Field ListHome
Select last item in Field ListEnd
Select next item in Field List
Select or clear a check boxSpace
Select previous item in Field List
Ungroup selected itemsAlt Shift

Power BI

Activate Selection paneF6
Collapse a table
Comment lines in DAXCtrl /
Comment multiple lines in DAXCtrl K C
CopyCtrl C
Copy line down in DAXAlt Shift
Copy line up in DAXAlt Shift
Create line break with auto-indentShift Enter
Delete a word in DAXCtrl Delete
Delete multiple lines in DAXCtrl Shift K
Enter lines of code in DAXCtrl Alt
Enter lines of code in DAXCtrl Alt
Expand a table
Find the highlighted wordCtrl D
Go to line number in DAXCtrl G
Indent line in DAXCtrl ]
Insert cursor in DAXAlt Click
Insert line above in DAXCtrl Shift Enter
Insert line below in DAXCtrl Enter
Interact with a SlicerCtrl
Jump to matching bracket in DAXCtrl Shift \
Move an object down in layeringCtrl Shift B
Move an object up in layeringCtrl Shift F
Move focus backward in sectionShift Tab
Move focus between sectionsCtrl F6
Move focus forward in sectionTab
Move focus to Visual menuAlt Shift F10
Move line down in DAXAlt
Move line up in DAXAlt
Multi-selectCtrl Shift
Multi-select objectsCtrl Space
New line in DAXAlt Enter
Open context menuShift F10
Outdent line in DAX Ctrl [
PasteCtrl V
Restart IntellisenseAlt I
Select all occurrences of current selectionCtrl Shift L
Select all occurrences of current wordCtrl F2
Select an objectSpace
Select current line in DAXCtrl I
Select nearest word in DAXAlt Shift
Select objectEnter
Show dataAlt Shift F11
Show keyboard shortcutsShift ?
Toggle commenting of codeAlt Shift A
Toggle commenting of lines that has a wordCtrl +
Toggle object visibilityCtrl Shift S
Uncomment lines in DAXCtrl \
Uncomment multiple lines in DAXCtrl K U
See also  028: The Best Microsoft Excel Tips & Tricks in 2020!

Others

Add border bottom in Format CellsAlt B
Add border downard diagonal in Format CellsAlt D
Add border horizontal interior in Format CellsAlt H
Add border left in Format CellsAlt L
Add border right in Format CellsAlt R
Add border top in Format CellsAlt T
Add border upward diagonal in Format CellsAlt U
Add border vertical interior in Format CellsAlt V
Clear cell contentBackspaceDelete
Clear cell content while keeping cell formatDeleteFn Delete
Clear slicer filterAlt C C
Close an open menu or dialogEscEsc
Delete one character to the leftBackspaceDelete
Delete one character to the rightDeleteFn Delete
Delete to the end of lineCtrl Delete Delete
Display control menu for Excel windowAlt Space?
In End Mode, move to bottom cell in columnEnd
In End Mode, move to left cell in rowEnd
In End Mode, move to right cell in rowEnd
In End Mode, move to top cell in columnEnd
Insert new line in cellAlt Enter Return
Move to start of rowHomeFn
Move to unlocked cells in protected worksheetTabTab
Open dropdown listAlt
Select or clear a check boxSpaceSpace
Selects the entire worksheetCtrl Shift Space A
Switch to next tab in dialogCtrl Tab Tab
Switch to Normal viewAlt W L
Switch to Page Break Preview viewAlt W I
Switch to Page Layout viewAlt W P
Switch to previous tab in dialogCtrl Shift Tab Tab
Toggle End modeEndFn
Toggle full screenCtrl Shift F1 F
Toggle total row of tableCtrl Shift T T

 

Download Our Excel Shortcuts PDF Cheat Sheet for Windows and Mac below…for FREE!

333 Excel Shortcuts for Windows and Mac

333 Excel Shortcuts for Windows and Mac

DOWNLOAD THE 333 EXCEL SHORTCUTS PDF CHEAT SHEET

Further Learning:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

333 Excel Shortcuts for Windows and Mac | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!