Complete Mac Excel Shortcut Cheat Sheet: Ribbon, Mouse and Mac Excel Shortcuts

Complete Mac Excel Shortcut Cheat Sheet: Ribbon, Mouse and Mac Excel Shortcuts

Excel for Mac has more than one efficient way to run a command. You can choose it visually in the Ribbon, point and click with the mouse, use a native Mac keyboard shortcut where Excel provides one, or use a Windows-style command sequence through Mac Excel Shortcuts. This reference puts those approaches in one place.

Quick answer: For a one-off task, use the Ribbon: select your data, open the relevant tab, and choose the command. For mouse-first work, right-click the selection and use the contextual menu where the command is available. For repeat work, use a native shortcut such as ⌘C, ⌘V, ⌘B, ⌘F, or ⌘⇧L; use the listed Alt sequence with Mac Excel Shortcuts when you want the Windows Excel-style command path on a Mac.

How to read this Mac Excel cheat sheet

The command sequences below come from the supplied Excel workbook and use Windows-style Ribbon letters, for example Alt H V V for Paste Values. They are Mac Excel Shortcuts sequences, not built-in single-key Mac shortcuts. Press the keys in order after enabling the Mac Excel Shortcuts workflow.

Native shortcuts are shown separately when they are common and useful. Excel’s menu labels can vary slightly by version, so use the command name as the anchor when following the Ribbon or mouse route.

Three ways to use almost every Excel command on Mac

1. Ribbon method

Select the cell, range, table, chart, or worksheet first. Then open the named Ribbon tab—such as Home, Data, Formulas, or View—and choose the command. This is the best method when you are learning or need to see related options.

2. Mouse method

Click the target, then right-click it to check the contextual menu. Common actions such as cut, copy, paste, insert, delete, format cells, sort, filter, and table actions are often available there. When an action is not in the right-click menu, use the Ribbon; the command names in the table tell you where to look.

3. Mac Excel Shortcuts method

Use the sequence in the final column. For example, Alt H A C maps to Home → Alignment → Center. This approach is ideal for people moving from Windows Excel or anyone who wants repeatable, keyboard-led Ribbon navigation on a Mac.

Essential native Mac Excel shortcuts

These are built-in keyboard shortcuts—not Mac Excel Shortcuts sequences.

Essential native Mac Excel shortcuts
ActionNative Mac shortcut
Copy⌘C
Cut⌘X
Paste⌘V
Undo / Redo⌘Z / ⌘Y
Bold / Italic / Underline⌘B / ⌘I / ⌘U
Find / Replace⌘F / ⌘H
Save⌘S
Select all⌘A
Toggle Filter⌘⇧L
Calculate workbook / sheetF9 / ⇧F9

Complete Mac Excel Shortcuts cheat sheet

Clipboard and Home commands

Clipboard and Home commands
CommandRibbon locationMac Excel Shortcuts sequence
PasteHome → ClipboardAlt H V P
Paste SpecialHome → ClipboardAlt H V S
Paste ValuesHome → ClipboardAlt H V V
Paste FormulasHome → ClipboardAlt H V F
Paste FormattingHome → ClipboardAlt H V R
CutHome → ClipboardAlt H X
CopyHome → ClipboardAlt H C
Format PainterHome → ClipboardAlt H F P
Font dialogHome → FontAlt H F F
Font SizeHome → FontAlt H F S
Increase Font SizeHome → FontAlt H F G
Decrease Font SizeHome → FontAlt H F K
BoldHome → FontAlt H 1
ItalicHome → FontAlt H 2
UnderlineHome → FontAlt H 4
All BordersHome → Font → BordersAlt H B A
Bottom BorderHome → Font → BordersAlt H B B
Top BorderHome → Font → BordersAlt H B T
Left BorderHome → Font → BordersAlt H B L
Right BorderHome → Font → BordersAlt H B R
Outside BordersHome → Font → BordersAlt H B O
No BorderHome → Font → BordersAlt H B N
Fill ColorHome → FontAlt H H
Font ColorHome → FontAlt H F C
Top AlignHome → AlignmentAlt H A T
Middle AlignHome → AlignmentAlt H A M
Bottom AlignHome → AlignmentAlt H A B
Left AlignHome → AlignmentAlt H A L
CenterHome → AlignmentAlt H A C
Right AlignHome → AlignmentAlt H A R
Wrap TextHome → AlignmentAlt H W
Merge & CenterHome → AlignmentAlt H M C
Merge AcrossHome → AlignmentAlt H M A
Merge CellsHome → AlignmentAlt H M M
Unmerge CellsHome → AlignmentAlt H M U
CurrencyHome → NumberAlt H K
Percent StyleHome → NumberAlt H L
Conditional FormattingHome → StylesAlt H L
Insert RowHome → CellsAlt H I R
Insert ColumnHome → CellsAlt H I C
Delete RowHome → CellsAlt H D R
Delete ColumnHome → CellsAlt H D C
AutoFit Column WidthHome → Cells → FormatAlt H O I
AutoFit Row HeightHome → Cells → FormatAlt H O A
AutoSumHome → EditingAlt =
Flash FillHome → EditingCtrl+E
Fill DownHome → EditingCtrl+D
Fill RightHome → EditingCtrl+R
FindHome → Editing → Find & SelectCtrl+F
ReplaceHome → Editing → Find & SelectCtrl+H
Go ToHome → Editing → Find & SelectF5

Sort, filter and data commands

Sort, filter and data commands
CommandRibbon locationMac Excel Shortcuts sequence
Sort A to ZData → Sort & FilterAlt A S A
Sort Z to AData → Sort & FilterAlt A S D
Custom SortData → Sort & FilterAlt A S S
FilterData → Sort & FilterCtrl+Shift+L
Reapply FilterData → Sort & FilterAlt A Y 3
Clear FilterData → Sort & FilterAlt A C
Text to ColumnsData → Data ToolsAlt A E
Remove DuplicatesData → Data ToolsAlt A M
Data ValidationData → Data ToolsAlt A V V
ConsolidateData → Data ToolsAlt A N
What-If AnalysisData → ForecastAlt A W
GroupData → OutlineAlt A G G
UngroupData → OutlineAlt A G U
SubtotalData → OutlineAlt A B
Refresh AllData → Get & TransformCtrl+Alt+F5

Insert and page layout commands

Insert and page layout commands
CommandRibbon locationMac Excel Shortcuts sequence
PivotTableInsert → TablesAlt N V
Recommended PivotTablesInsert → TablesAlt N S
TableInsert → TablesCtrl+T or Alt N T
PicturesInsert → IllustrationsAlt N P
ShapesInsert → IllustrationsAlt N SH
SmartArtInsert → IllustrationsAlt N M
LinkInsert → LinksCtrl+K
EquationInsert → SymbolsAlt =
SlicerInsert → FiltersAlt N S F
MarginsPage Layout → Page SetupAlt P M
OrientationPage Layout → Page SetupAlt P O
SizePage Layout → Page SetupAlt P S
Print AreaPage Layout → Page SetupAlt P R
BreaksPage Layout → Page SetupAlt P B
Print TitlesPage Layout → Page SetupAlt P I

Formula and calculation commands

Formula and calculation commands
CommandRibbon locationMac Excel Shortcuts sequence
Insert FunctionFormulas → Function LibraryShift+F3
AutoSumFormulas → Function LibraryAlt M U
Name ManagerFormulas → Defined NamesCtrl+F3
Define NameFormulas → Defined NamesAlt M M D
Create from SelectionFormulas → Defined NamesCtrl+Shift+F3
Trace PrecedentsFormulas → Formula AuditingAlt M P
Trace DependentsFormulas → Formula AuditingAlt M D
Remove ArrowsFormulas → Formula AuditingAlt M A A
Show FormulasFormulas → Formula AuditingCtrl+`
Error CheckingFormulas → Formula AuditingAlt M X
Calculate NowFormulas → CalculationF9
Calculate SheetFormulas → CalculationShift+F9

View and review commands

View and review commands
CommandRibbon locationMac Excel Shortcuts sequence
Normal viewView → Workbook ViewsAlt W L
Page Break PreviewView → Workbook ViewsAlt W I
Page Layout viewView → Workbook ViewsAlt W P
GridlinesView → ShowAlt W V G
Formula BarView → ShowAlt W V F
HeadingsView → ShowAlt W V H
ZoomView → ZoomAlt W Q
100% ZoomView → ZoomAlt W J
New WindowView → WindowAlt W N
Freeze PanesView → WindowAlt W F
Freeze Top RowView → WindowAlt W R
Freeze First ColumnView → WindowAlt W C
SplitView → WindowAlt W S
Hide WorkbookView → WindowAlt W H
Unhide WorkbookView → WindowAlt W U
View MacrosView → MacrosAlt W M
Record MacroView → MacrosAlt W R
SpellingReview → ProofingF7
ThesaurusReview → ProofingShift+F7
New CommentReview → CommentsCtrl+Alt+M
New NoteReview → NotesShift+F2
Protect SheetReview → ProtectAlt R P S
Protect WorkbookReview → ProtectAlt R P W

Which method should you choose?

Which method should you choose?
SituationBest choiceWhy
You are learning a commandRibbonThe label and nearby options make the command easy to verify.
You are already pointing at a cell or tableMouseA right-click menu is quick for local actions such as formatting, sorting, and inserting.
You repeat a command all dayNative shortcut or Mac Excel ShortcutsIt removes pointer travel and makes the action consistent.
You are moving from Windows ExcelMac Excel ShortcutsThe Alt sequences retain familiar Ribbon-navigation muscle memory.
You need an option not shown in a contextual menuRibbonThe complete command set lives in the Ribbon and its dialogs.

Important notes before relying on shortcut sequences

  • Start with the correct selection. A cell, range, table, chart, or sheet selection changes which commands Excel makes available.

  • Some commands open a dialog or menu; choose the needed option and press Return to confirm.

  • Commands with the same sequence in the source list can be context dependent. For example, Alt H L is listed for both Percent Style and Conditional Formatting, so verify the command in your current Mac Excel Shortcuts configuration before automating a workflow.

  • Function keys may require holding fn on Mac keyboards, depending on your macOS keyboard settings.

Summary: the fastest way to work in Excel on Mac

Use the Ribbon when you need clarity, the mouse when the command is local to your selection, and keyboard workflows when repetition matters. The cheat sheet above gives you a practical map of the workbook’s Mac Excel Shortcuts sequences across Home, Data, Insert, Formulas, View, and Review. Learn five commands you use every day first—then add the next five from the same section.

← Back to all articles