Supported alt key ribbon shortcuts on Mac

Try 900+ Excel and PowerPoint ribbon shortcuts on your Mac now

Quick Access Toolbar

Quick Access Position 1

alt 1

Quick Access Position 2

alt 2

Quick Access Position 3

alt 3

Quick Access Position 4

alt 4

Quick Access Position 5

alt 5

Quick Access Position 6

alt 6

Search

alt 7

Document Actions

alt 8

Document Actions

alt 9

Quick Access Position 10

alt 0

Home tab

Paste Special

alt h v s

Paste Formula

alt h v f

Paste Formula and Formatting

alt h v o

Paste Keep Source Formatting

alt h v k

Paste Destination Formatting

alt h v m

Paste No Borders

alt h v b

Paste Keep Source Column Widths

alt h v w

Paste Transpose

alt h v t

Paste Values

alt h v v

Paste Values and Number Formatting

alt h v a

Paste Values and Source Formatting

alt h v e

Paste Formatting

alt h v r

Paste Link

alt h v n

Paste Picture

alt h v u

Paste Linked Picture

alt h v i

Paste

alt h v p

Copy

alt h c c

Copy as Picture

alt h c p

Cut

alt h x

Format Painter

alt h f p

Font Selection

alt h f f

Font Size

alt h f s

Increase Font Size

alt h f g

Decrease Font Size

alt h f k

Bold

alt h 1

Italic

alt h 2

Underline Menu

alt h 3

Underline

alt h 3 U

Double Underline

alt h 3 D

Fill Color

alt h h

Borders Menu

alt h b

Bottom Border

alt h b o

Top Border

alt h b p

Left Border

alt h b l

Right Border

alt h b r

No Border

alt h b n

All Borders

alt h b a

Outside Borders

alt h b s

Thick Outside Borders

alt h b t

Bottom Double Border

alt h b b

Thick Bottom Border

alt h b h

Top and Bottom Border

alt h b d

Top and Thick Bottom Border

alt h b c

Top and Double Bottom Border

alt h b u

Draw Border

alt h b w

Draw Border Grid

alt h b g

Erase Border

alt h b e

Line Color

alt h b i

Line Style

alt h b y

More Borders

alt h b m

Font Color

alt h f c

Align Top

alt h a t

Align Middle

alt h a m

Align Bottom

alt h a b

Align Left

alt h a l

Align Center

alt h a c

Align Right

alt h a r

Decrease Indent

alt h 5

Increase Indent

alt h 6

Orientation Menu

alt h f q

Angle Counterclockwise

alt h f q o

Angle Clockwise

alt h f q l

Vertical Text

alt h f q v

Rotate Text Up

alt h f q u

Rotate Text Down

alt h f q d

Format Cell Alignment

alt h f q m

Wrap Text Menu

alt h w

Wrap Text

alt h w w

Shrink to Fit

alt h w s

Merge & Center Menu

alt h m

Merge & Center

alt h m c

Merge Across

alt h m a

Merge Cells

alt h m m

Unmerge Cells

alt h m u

Number Format

alt h n

Accounting Format

alt h a n

More Accounting Formats

alt h a n m

Percentage Style

alt h p

Comma Style

alt h k

Increase Decimals

alt h 0

Decrease Decimals

alt h 9

Conditional Formatting

alt h l

Highlight Cells

alt h l h

Highlight Cells Greater Than

alt h l h g

Highlight Cells Less Than

alt h l h l

Highlight Cells Between

alt h l h b

Highlight Cells Equal To

alt h l h e

Highlight Text that Contains

alt h l h t

Highlight A Date Occuring

alt h l h a

Highlight Duplicate Values

alt h l h d

Highlight Cells More Rules

alt h l h m

Top/Bottom Rules

alt h l t

Format Top 10 Items

alt h l t t

Format Top 10%

alt h l t p

Format Bottom 10 Items

alt h l t b

Format Bottom 10%

alt h l t o

Format Above Average

alt h l t a

Format Below Average

alt h l t v

Format Top/Bottom More Rules

alt h l t m

Data Bars

alt h l d

Color Scales

alt h l s

Icon Sets

alt h l i

New Rule

alt h l n

Clear Rules Menu

alt h l c

Clear Rules From Cells

alt h l c s

Clear Rules From Sheet

alt h l c e

Clear Rules From Table

alt h l c t

Clear Rules From Pivot Table

alt h l c p

Manage Rules

alt h l r

Format as Table

alt h t

New Table Style

alt h t n

New Pivot Table Style

alt h t p

Cell Styles

alt h j

New Cell Style

alt h j n

Merge Styles

alt h j m

Insert Menu

alt h i

Insert Cells

alt h i i

Insert Rows

alt h i r

Insert Columns

alt h i c

Insert Sheet

alt h i s

Insert Copied Cells

alt h i e

Delete Menu

alt h d

Delete Cells

alt h d d

Delete Rows

alt h d r

Delete Columns

alt h d c

Delete Table Rows

alt h d t

Delete Table Columns

alt h d q

Delete Sheet

alt h d s

Format Menu

alt h o

Row Height

alt h o h

AutoFit Row Height

alt h o a

Column Width

alt h o w

AutoFit Column Width

alt h o i

Default Column Width

alt h o d

Hide & Unhide Menu

alt h o u

Hide Rows

alt h o u r

Hide Columns

alt h o u c

Hide Sheet

alt h o u s

Unhide Rows

alt h o u o

Unhide Columns

alt h o u l

Unhide Sheet

alt h o u h

Rename Sheet

alt h o r

Move or Copy Sheet

alt h o m

Tab Color

alt h o t

Protect Sheet

alt h o p

Lock Cell

alt h o l

Format Cells

alt h o e

Auto Sum

alt h u s

Auto Average

alt h u a

Auto Count Numbers

alt h u c

Auto Max

alt h u m

Auto Min

alt h u i

Auto More Functions

alt h u f

Fill Down

alt h f i d

Fill Right

alt h f i r

Fill Up

alt h f i u

Fill Left

alt h f i l

Fill Across Worksheets

alt h f i a

Fill Series

alt h f i s

Fill Justify

alt h f i j

Flash Fill

alt h f i f

Clear All

alt h e a

Clear Formats

alt h e f

Clear Contents

alt h e c

Clear Comments and Notes

alt h e m

Clear Hyperlinks

alt h e l

Remove Hyperlinks

alt h e r

Sort A to Z

alt h s s

Sort Z to A

alt h s o

Custom Sort

alt h s u

Filter

alt h s f

Clear Filter

alt h s c

Reapply Filter

alt h s y

Find

alt h f d f

Replace

alt h f d r

Go To

alt h f d g

Go To Special

alt h f d s

Find Formulas

alt h f d u

Find Notes

alt h f d m

Find Conditional Formatting

alt h f d c

Find Constants

alt h f d n

Find Data Validation

alt h f d v

Select Objects

alt h f d o

Selection Pane

alt h f d p

Add-ins

alt h a s

Insert tab

PivotTable

alt n v

Recommended PivotTables

alt n s p

Table

alt n t

Forms Menu

alt n f f

New Form

alt n f f n

Preview Form

alt n f f p

Edit Form

alt n f f e

Send Form

alt n f f s

From Picture Menu

alt n f p

Picture From File

alt n f p f

Picture From Clipboard

alt n f p c

Picture

alt n p

Place in Cell Menu

alt n p i

Place over Cells Menu

alt n p o

Picture from File

alt n p b

Place in Cell

alt n p f

Photo Browser (In Cell)

alt n p i b

Picture from File (In Cell)

alt n p i f

Stock Images (In Cell)

alt n p i s

Online Pictures (In Cell)

alt n p i o

Photo Browser (Over Cells)

alt n p o b

Picture from File (Over Cells)

alt n p o f

Stock Images (Over Cells)

alt n p o s

Online Pictures (Over Cells)

alt n p o o

Shapes

alt n s h

Icons

alt n n s

3D Models Menu

alt n s 3

3D from Device

alt n s 3 d

Stock 3D Models

alt n s 3 s

SmartArt Menu

alt n m 1

SmartArt List

alt n m 1 l

SmartArt Process

alt n m 1 p

SmartArt Cycle

alt n m 1 c

SmartArt Hierarchy

alt n m 1 h

SmartArt Relationship

alt n m 1 r

SmartArt Matrix

alt n m 1 m

SmartArt Pyramid

alt n m 1 d

SmartArt Picture

alt n m 1 t

Screenshot Menu

alt n s c

Screen Clipping

alt n s c c

Checkbox

alt n c b

Recommended Charts

alt n r

PivotChart

alt n s z

Column Chart

alt n c 1

Line Chart

alt n n 1

Pie Chart

alt n q

Hierarchy Chart

alt n h i

Statistical Chart

alt n s a

Scatter Chart

alt n d

Waterfall Chart

alt n i 1

Combo Chart

alt n s d

Map Chart

alt n m 2

Sparklines Menu

alt n z k

Line Sparkline

alt n z k s l

Column Sparkline

alt n z k s o

Win/Loss Sparkline

alt n z k s w

Slicer

alt n s f

Timeline

alt n s t

Link

alt n i 2

New Comment

alt n c 2

Text Box

alt n x

Header & Footer

alt n h f

WordArt

alt n w

Object

alt n j

Symbols

alt n u

Equations

alt n e

Page Layout tab

Themes

alt p t h

Browse Themes

alt p t h b

Save Theme

alt p t h a

Theme Colors

alt p t c

Theme Fonts

alt p t f

Margins

alt p m

Custom Margins

alt p m a

Orientation

alt p o

Size

alt p s z

Print Area

alt p r

Set Print Area

alt p r s

Clear Print Area

alt p r c

Breaks

alt p b

Insert Page Break

alt p b i

Remove Page Break

alt p b r

Reset All Page Breaks

alt p b a

Background

alt p g

Print Titles

alt p i

Page Setup

alt p s p

Width

alt p w

Height

alt p h

View Gridlines

alt p v g

Print Gridlines

alt p p g

View Headings

alt p v h

Print Headings

alt p p h

Formulas tab

Insert Function

alt m f

AutoSum Menu

alt m u

Sum

alt m u s

Average

alt m u a

Count Numbers

alt m u c

Max

alt m u m

Min

alt m u i

More Functions (AutoSum)

alt m u f

Recently Used Menu

alt m r

Recently Used - Insert Function

alt m r f

Financial Menu

alt m i

Financial - Insert Function

alt m i f

Logical Menu

alt m l

Logical - Insert Function

alt m l f

Text Menu

alt m t

Text - Insert Function

alt m t f

Date & Time Menu

alt m e

Date & Time - Insert Function

alt m e f

Lookup & Reference Menu

alt m o

Lookup & Reference - Insert Function

alt m o f

Math & Trig Menu

alt m g

Math & Trig - Insert Function

alt m g f

More Functions Menu

alt m q

Statistical Submenu

alt m q s

Engineering Submenu

alt m q e

Cube Submenu

alt m q c

Information Submenu

alt m q i

Compatibility Submenu

alt m q o

Web Submenu

alt m q w

Statistical - Insert Function

alt m q s f

Engineering - Insert Function

alt m q e f

Cube - Insert Function

alt m q c f

Information - Insert Function

alt m q i f

Compatibility - Insert Function

alt m q o f

Web - Insert Function

alt m q w f

Name Manager

alt m n

Define Name

alt m m

Use in Formula Menu

alt m s

Paste Names

alt m s p

Create From Selection

alt m c

Trace Precedents

alt m p

Trace Dependents

alt m d

Remove Arrows Menu

alt m a

Remove All Arrows

alt m a a

Remove Precedent Arrows

alt m a p

Remove Dependent Arrows

alt m a d

Show Formulas

alt m h

Error Checking Menu

alt m k

Error Checking

alt m k k

Trace Error

alt m k e

Circular References

alt m k c

Watch Window

alt m w

Calculation Options Menu

alt m x

Automatic Calculation

alt m x a

Automatic Except Data Tables

alt m x e

Manual Calculation

alt m x m

Partial Calculation

alt m x p

Calculate Now

alt m b

Calculate Sheet

alt m j

Data tab

Get Data (Power Query) Menu

alt a p n

Get Data (Power Query)

alt a p n g

Launch Power Query Editor

alt a p n e

From HTML

alt a p n h

From Text (Legacy)

alt a p n t

From SQL Server ODBC

alt a p n l

From Database (Microsoft Query)

alt a p n d

Data Source Settings

alt a p n s

Data from Picture Menu

alt a f 1

Picture From File

alt a f 1 p

Picture From Clipboard

alt a f 1 c

Refresh Menu

alt a r

Refresh All

alt a r a

Refresh

alt a r r

Refresh Status

alt a r s

Cancel Refresh

alt a r c

Connection Properties

alt a r o

Queries & Connections

alt a o

Properties

alt a p 1

Edit Links

alt a k

Filter

alt a t

Clear Filter

alt a c

Reapply Filter

alt a y

Advanced Filter

alt a q

Sort

alt a s s

Sort A to Z

alt a s a

Sort Z to A

alt a s d

Text to Columns

alt a e

Data Validation Menu

alt a v

Data Validation

alt a v v

Circle Invalid Data

alt a v i

Clear Validation Circles

alt a v r

Remove Duplicates

alt a m

Consolidate

alt a d

Flash Fill

alt a f f

What-If Analysis Menu

alt a w

Scenario Manager

alt a w s

Goal Seek

alt a w g

Data Table

alt a w t

Group Menu

alt a g

Group

alt a g g

Auto Outline

alt a g a

Ungroup Menu

alt a u

Ungroup

alt a u u

Clear Outline

alt a u c

Subtotal

alt a b

Show Detail

alt a j

Hide Detail

alt a h

Analyze Data

alt a f e

View tab

Normal View

alt w l

Page Break Preview

alt w i

Page Layout View

alt w p

Custom Views

alt w c

Focus Cell Menu

alt w v c

Focus Cell

alt w v c f

Focus Color

alt w v c c

Focus Highlight

alt w v c h

Keep Sheet View

alt w v k

Exit Sheet View

alt w v e

Sheet View Options

alt w v o

Navigation

alt w v n

Ruler

alt w v r

Data Type Icons

alt w v d

Show Menu

alt w v s

Toggle Gridlines

alt w v g

Toggle Formula Bar

alt w v f

Toggle Headings

alt w v h

Zoom

alt w q

Zoom To 100%

alt w j

Zoom To Selection

alt w g

New Window

alt w n

Arrange All

alt w a

Freeze Panes Menu

alt w f

Freeze Panes

alt w f f

Freeze Top Row

alt w f r

Freeze First Column

alt w f c

Split

alt w s

Hide Window

alt w h

Unhide Window

alt w u

Switch Windows

alt w w

View Side by Side

alt w v v

Synchronous Scrolling

alt w v l

Macros Menu

alt w m

View Macros

alt w m v

Record Macro

alt w m r

Use Relative References

alt w m u

Quick Access Toolbar

Quick Access Position 1

alt 1

Quick Access Position 2

alt 2

Quick Access Position 3

alt 3

Quick Access Position 4

alt 4

Quick Access Position 5

alt 5

Search

alt 6

Quick Access Position 7

alt 7

Quick Access Position 8

alt 8

Quick Access Position 9

alt 9

Quick Access Position 10

alt 0

More PowerPoint shortcuts coming soon! We're actively testing and documenting additional tabs.