How-to Guides for Mac Excel Alt Key Shortcuts

Welcome! Here you’ll find step-by-step guides for every Excel ribbon shortcut on Mac, made possible with Accelerator Keys.

Quick Access Toolbar (Alt+1-0)

• Alt+1 - Quick Access Position 1
• Alt+2 - Quick Access Position 2
• Alt+3 - Quick Access Position 3
• Alt+4 - Quick Access Position 4
• Alt+5 - Quick Access Position 5
• Alt+6 - Quick Access Position 6
• Alt+7 - Search
• Alt+8 - Document Actions
• Alt+9 - Document Actions
• Alt+0 - Quick Access Position 10

Home Tab - Clipboard

• Alt+H+V - Paste Menu
• Alt+H+V+P - Paste
• Alt+H+V+S - Paste Special
• Alt+H+V+F - Paste Formula
• Alt+H+V+O - Paste Formula and Formatting
• Alt+H+V+K - Paste Keep Source Formatting
• Alt+H+V+M - Paste Destination Formatting
• Alt+H+V+B - Paste No Borders
• Alt+H+V+W - Paste Keep Source Column Widths
• Alt+H+V+T - Paste Transpose
• Alt+H+V+V - Paste Values
• Alt+H+V+A - Paste Values and Number Formatting
• Alt+H+V+E - Paste Values and Source Formatting
• Alt+H+V+R - Paste Formatting
• Alt+H+V+N - Paste Link
• Alt+H+V+U - Paste Picture
• Alt+H+V+I - Paste Linked Picture
• Alt+H+X - Cut
• Alt+H+C - Copy Menu
• Alt+H+C+C - Copy
• Alt+H+C+P - Copy as Picture
• Alt+H+F+P - Format Painter

Home Tab - Font & Formatting

• Alt+H+F+F - Font Selection
• Alt+H+F+S - Font Size
• Alt+H+F+G - Increase Font Size
• Alt+H+F+K - Decrease Font Size
• Alt+H+1 - Bold
• Alt+H+2 - Italic
• Alt+H+3 - Underline Menu
• Alt+H+3+U - Underline
• Alt+H+3+D - Double Underline
• Alt+H+H - Fill Color
• Alt+H+F+C - Font Color

Home Tab - Borders

• Alt+H+B - Borders Menu
• Alt+H+B+O - Bottom Border
• Alt+H+B+P - Top Border
• Alt+H+B+L - Left Border
• Alt+H+B+R - Right Border
• Alt+H+B+N - No Border
• Alt+H+B+A - All Borders
• Alt+H+B+S - Outside Borders
• Alt+H+B+T - Thick Outside Borders
• Alt+H+B+B - Bottom Double Border
• Alt+H+B+H - Thick Bottom Border
• Alt+H+B+D - Top and Bottom Border
• Alt+H+B+C - Top and Thick Bottom Border
• Alt+H+B+U - Top and Double Bottom Border
• Alt+H+B+W - Draw Border
• Alt+H+B+G - Draw Border Grid
• Alt+H+B+E - Erase Border
• Alt+H+B+I - Line Color
• Alt+H+B+Y - Line Style
• Alt+H+B+M - More Borders

Home Tab - Alignment

• Alt+H+A+T - Align Top
• Alt+H+A+M - Align Middle
• Alt+H+A+B - Align Bottom
• Alt+H+A+L - Align Left
• Alt+H+A+C - Align Center
• Alt+H+A+R - Align Right
• Alt+H+F+Q - Orientation Menu
• Alt+H+F+Q+O - Angle Counterclockwise
• Alt+H+F+Q+L - Angle Clockwise
• Alt+H+F+Q+V - Vertical Text
• Alt+H+F+Q+U - Rotate Text Up
• Alt+H+F+Q+D - Rotate Text Down
• Alt+H+F+Q+M - Format Cell Alignment
• Alt+H+5 - Decrease Indent
• Alt+H+6 - Increase Indent
• Alt+H+W - Wrap Text Menu
• Alt+H+W+W - Wrap Text
• Alt+H+W+S - Shrink to Fit
• Alt+H+M - Merge & Center Menu
• Alt+H+M+C - Merge & Center
• Alt+H+M+A - Merge Across
• Alt+H+M+M - Merge Cells
• Alt+H+M+U - Unmerge Cells

Home Tab - Number Formatting

• Alt+H+N - Number Format
• Alt+H+A+N - Accounting Format
• Alt+H+A+N+M - More Accounting Formats
• Alt+H+P - Percentage Style
• Alt+H+K - Comma Style
• Alt+H+0 - Increase Decimals
• Alt+H+9 - Decrease Decimals

Home Tab - Conditional Formatting

• Alt+H+L - Conditional Formatting Menu
• Alt+H+L+H - Highlight Cells Rules
• Alt+H+L+H+G - Greater Than
• Alt+H+L+H+L - Less Than
• Alt+H+L+H+B - Between
• Alt+H+L+H+E - Equal To
• Alt+H+L+H+T - Text That Contains
• Alt+H+L+H+A - A Date Occurring
• Alt+H+L+H+D - Duplicate Values
• Alt+H+L+H+M - More Rules
• Alt+H+L+T - Top/Bottom Rules
• Alt+H+L+T+T - Top 10 Items
• Alt+H+L+T+P - Top 10%
• Alt+H+L+T+B - Bottom 10 Items
• Alt+H+L+T+O - Bottom 10%
• Alt+H+L+T+A - Above Average
• Alt+H+L+T+V - Below Average
• Alt+H+L+T+M - More Rules
• Alt+H+L+D - Data Bars
• Alt+H+L+S - Color Scales
• Alt+H+L+I - Icon Sets
• Alt+H+L+N - New Rule
• Alt+H+L+C - Clear Rules Menu
• Alt+H+L+C+S - Clear Rules from Selected Cells
• Alt+H+L+C+E - Clear Rules from Entire Sheet
• Alt+H+L+C+T - Clear Rules from This Table
• Alt+H+L+C+P - Clear Rules from This PivotTable
• Alt+H+L+R - Manage Rules

Home Tab - Format as Table & Cell Styles

• Alt+H+T - Format as Table
• Alt+H+T+N - New Table Style
• Alt+H+T+P - New PivotTable Style
• Alt+H+J - Cell Styles
• Alt+H+J+N - New Cell Style
• Alt+H+J+M - Merge Styles

Home Tab - Cells (Insert)

• Alt+H+I - Insert Menu
• Alt+H+I+I - Insert Cells
• Alt+H+I+R - Insert Rows
• Alt+H+I+C - Insert Columns
• Alt+H+I+S - Insert Sheet
• Alt+H+I+E - Insert Copied Cells

Home Tab - Cells (Delete)

• Alt+H+D - Delete Menu
• Alt+H+D+D - Delete Cells
• Alt+H+D+R - Delete Rows
• Alt+H+D+C - Delete Columns
• Alt+H+D+T - Delete Table Rows
• Alt+H+D+Q - Delete Table Columns
• Alt+H+D+S - Delete Sheet

Home Tab - Cells (Format)

• Alt+H+O - Format Menu
• Alt+H+O+H - Row Height
• Alt+H+O+A - AutoFit Row Height
• Alt+H+O+W - Column Width
• Alt+H+O+I - AutoFit Column Width
• Alt+H+O+D - Default Column Width
• Alt+H+O+U - Hide & Unhide Menu
• Alt+H+O+U+R - Hide Rows
• Alt+H+O+U+C - Hide Columns
• Alt+H+O+U+S - Hide Sheet
• Alt+H+O+U+O - Unhide Rows
• Alt+H+O+U+L - Unhide Columns
• Alt+H+O+U+H - Unhide Sheet
• Alt+H+O+R - Rename Sheet
• Alt+H+O+M - Move or Copy Sheet
• Alt+H+O+T - Tab Color
• Alt+H+O+P - Protect Sheet
• Alt+H+O+L - Lock Cell
• Alt+H+O+E - Format Cells

Home Tab - Editing (AutoSum)

• Alt+H+U - AutoSum Menu
• Alt+H+U+S - Sum
• Alt+H+U+A - Average
• Alt+H+U+C - Count Numbers
• Alt+H+U+M - Max
• Alt+H+U+I - Min
• Alt+H+U+F - More Functions

Home Tab - Editing (Fill)

• Alt+H+F+I - Fill Menu
• Alt+H+F+I+D - Fill Down
• Alt+H+F+I+R - Fill Right
• Alt+H+F+I+U - Fill Up
• Alt+H+F+I+L - Fill Left
• Alt+H+F+I+A - Fill Across Worksheets
• Alt+H+F+I+S - Fill Series
• Alt+H+F+I+J - Fill Justify
• Alt+H+F+I+F - Flash Fill

Home Tab - Editing (Clear)

• Alt+H+E - Clear Menu
• Alt+H+E+A - Clear All
• Alt+H+E+F - Clear Formats
• Alt+H+E+C - Clear Contents
• Alt+H+E+M - Clear Comments
• Alt+H+E+L - Clear Hyperlinks
• Alt+H+E+R - Remove Hyperlinks

Home Tab - Editing (Sort & Filter)

• Alt+H+S - Sort & Filter Menu
• Alt+H+S+S - Sort A to Z
• Alt+H+S+O - Sort Z to A
• Alt+H+S+U - Custom Sort
• Alt+H+S+F - Filter
• Alt+H+S+C - Clear Filter
• Alt+H+S+Y - Reapply Filter

Home Tab - Editing (Find & Select)

• Alt+H+F+D - Find & Select Menu
• Alt+H+F+D+F - Find
• Alt+H+F+D+R - Replace
• Alt+H+F+D+G - Go To
• Alt+H+F+D+S - Go To Special
• Alt+H+F+D+U - Formulas
• Alt+H+F+D+M - Notes
• Alt+H+F+D+C - Conditional Formatting
• Alt+H+F+D+N - Constants
• Alt+H+F+D+V - Data Validation
• Alt+H+F+D+O - Select Objects
• Alt+H+F+D+P - Selection Pane

Home Tab - Add-ins

• Alt+H+A+S - Add-ins

Insert Tab - Tables

• Alt+N+V - PivotTable
• Alt+N+S+P - Recommended PivotTables
• Alt+N+T - Table

Insert Tab - Forms

• Alt+N+F+F - Forms Menu
• Alt+N+F+F+N - New Form
• Alt+N+F+F+P - Preview Form
• Alt+N+F+F+E - Edit Form
• Alt+N+F+F+S - Send Form

Insert Tab - From Picture

• Alt+N+F+P - From Picture Menu
• Alt+N+F+P+F - Picture From File
• Alt+N+F+P+C - Picture From Clipboard

Insert Tab - Illustrations (Pictures)

• Alt+N+P - Picture
• Alt+N+P+I - Place in Cell Menu
• Alt+N+P+O - Place over Cells Menu
• Alt+N+P+B - Picture from File
• Alt+N+P+F - Place in Cell
• Alt+N+P+I+B - Photo Browser (In Cell)
• Alt+N+P+I+F - Picture from File (In Cell)
• Alt+N+P+I+S - Stock Images (In Cell)
• Alt+N+P+I+O - Online Pictures (In Cell)
• Alt+N+P+O+B - Photo Browser (Over Cells)
• Alt+N+P+O+F - Picture from File (Over Cells)
• Alt+N+P+O+S - Stock Images (Over Cells)
• Alt+N+P+O+O - Online Pictures (Over Cells)

Insert Tab - Illustrations (Other)

• Alt+N+S+H - Shapes
• Alt+N+N+S - Icons
• Alt+N+S+3 - 3D Models Menu
• Alt+N+S+3+D - 3D from Device
• Alt+N+S+3+S - Stock 3D Models
• Alt+N+M+1 - SmartArt Menu
• Alt+N+M+1+L - SmartArt List
• Alt+N+M+1+P - SmartArt Process
• Alt+N+M+1+C - SmartArt Cycle
• Alt+N+M+1+H - SmartArt Hierarchy
• Alt+N+M+1+R - SmartArt Relationship
• Alt+N+M+1+M - SmartArt Matrix
• Alt+N+M+1+D - SmartArt Pyramid
• Alt+N+M+1+T - SmartArt Picture
• Alt+N+S+C - Screenshot Menu
• Alt+N+S+C+C - Screen Clipping
• Alt+N+U - Symbols
• Alt+N+E - Equations

Insert Tab - Controls

• Alt+N+C+B - Checkbox

Insert Tab - Charts

• Alt+N+R - Recommended Charts
• Alt+N+S+Z - PivotChart
• Alt+N+C+1 - Column Chart
• Alt+N+N+1 - Line Chart
• Alt+N+Q - Pie Chart
• Alt+N+H+I - Hierarchy Chart
• Alt+N+S+A - Statistical Chart
• Alt+N+D - Scatter Chart
• Alt+N+I+1 - Waterfall Chart
• Alt+N+S+D - Combo Chart
• Alt+N+M+2 - Map Chart

Insert Tab - Sparklines

• Alt+N+Z+K - Sparklines Menu
• Alt+N+Z+K+S+L - Line Sparkline
• Alt+N+Z+K+S+O - Column Sparkline
• Alt+N+Z+K+S+W - Win/Loss Sparkline

Insert Tab - Filters

• Alt+N+S+F - Slicer
• Alt+N+S+T - Timeline

Insert Tab - Links

• Alt+N+I+2 - Link

Insert Tab - Comments

• Alt+N+C+2 - New Comment

Insert Tab - Text

• Alt+N+X - Text Box
• Alt+N+H+F - Header & Footer
• Alt+N+W - WordArt
• Alt+N+J - Object

Insert Tab - Symbols

• Alt+N+E - Equation
• Alt+N+U - Symbol

Page Layout Tab - Themes

• Alt+P+T+H - Themes
• Alt+P+T+H+B - Browse Themes
• Alt+P+T+H+A - Save Theme
• Alt+P+T+C - Theme Colors
• Alt+P+T+F - Theme Fonts

Page Layout Tab - Page Setup

• Alt+P+M - Margins
• Alt+P+M+A - Custom Margins
• Alt+P+O - Orientation
• Alt+P+S+Z - Size
• Alt+P+R - Print Area
• Alt+P+R+S - Set Print Area
• Alt+P+R+C - Clear Print Area
• Alt+P+B - Breaks
• Alt+P+B+I - Insert Page Break
• Alt+P+B+R - Remove Page Break
• Alt+P+B+A - Reset All Page Breaks
• Alt+P+G - Background
• Alt+P+I - Print Titles
• Alt+P+S+P - Page Setup

Page Layout Tab - Scale to Fit

• Alt+P+W - Width
• Alt+P+H - Height

Page Layout Tab - Sheet Options

• Alt+P+V+G - View Gridlines
• Alt+P+P+G - Print Gridlines
• Alt+P+V+H - View Headings
• Alt+P+P+H - Print Headings

Formulas Tab

• Alt+M+F - Insert Function
• Alt+M+M - Define Name
• Alt+M+C - Create from Selection
• Alt+M+P - Trace Precedents
• Alt+M+D - Trace Dependents
• Alt+M+A+A - Remove All Arrows
• Alt+M+B - Calculate Now

Data Tab

• Alt+A+T - Filter
• Alt+A+C - Clear Filter
• Alt+A+Y - Reapply Filter
• Alt+A+S+S - Sort
• Alt+A+S+A - Sort A to Z
• Alt+A+S+D - Sort Z to A
• Alt+A+E - Text to Columns
• Alt+A+V+V - Data Validation
• Alt+A+G+G - Group
• Alt+A+U+U - Ungroup

View Tab

• Alt+W+L - Normal View
• Alt+W+P - Page Layout View
• Alt+W+I - Page Break Preview
• Alt+W+F+F - Freeze Panes
• Alt+W+F+R - Freeze Top Row
• Alt+W+F+C - Freeze First Column
• Alt+W+Q - Zoom
• Alt+W+J - Zoom to 100%
• Alt+W+G - Zoom to Selection

---

View complete shortcuts list →

Download Accelerator Keys →