Microsoft Excel 2016 for Mac Keyboard Shortcuts

Rows and Columns

Select Current Row

Shift-Space

Select Current Column

Control-Space

Insert Row Above

(Shift-Space,) Control-Shift-= [was Control-I in Excel 2011]

Insert Column Left

(Control-Space,) Control-Shift-= [was Control-I in Excel 2011]

Delete Row

(Shift-Space,) Control-Hyphen

Delete Column

(Control-Space,) Control-Hyphen

Hide Column

Control-)

Unhide Column

Control-Shift-)

Hide Row

Control-(

Unhide Row

Control-Shift-(

AutoFit Multiple Columns

Select columns and double-click divider

Resize to Equal Columns

Select columns and drag one divider

Move/Reorder Columns

Select the columns to move. Move the cursor to the lower left corner of the column header so that it changes to a hand. The header corner must the slightly above the center of the cursor (not the corner where the tip of the arrow would be). Hold the Shift key and drag and drop the column.

Multiple Cells

Fill Right

Control-R

Fill Down

Control-D

Clear Cells

Forward Delete (fn-Delete)

Create Table

Command-T

Group Cells

Command-Shift-K

Ungroup Cells

Command-Shift-J

Cell Formats

Format Cells Dialog

Command-1

Format Number General

Control-~

Format Number With Thousands

Control-Shift-1

Format Time

Control-Shift-2

Format Date

Control-Shift-3

Format Currency

Control-Shift-4 ($)

Format Percentage

Control-Shift-5 (%)

Cell Borders

Toggle One Border

Command-Option–Arrow Key

Add All Borders

Command-Option-0

Remove All Borders

Command-Option-Hyphen

Cell Editing

Enter Edit Mode

Control-U

Move Insertion Point to Beginning

Home (fn–Left Arrow)

Move Insertion Point to End

End (fn–Right Arrow)

New Line in Same Cell

Control-Option-Return

Toggle Formulas/Values Shown

Control-`

Define Name

Control-L

Enter Current Date

Control-;

Toggle Formula Reference Style

Command-T or F4 (with the reference selected)

Type Number as Text Format

Prefix with '

Sheets

Next Sheet

Control-Page Down

Previous Sheet

Control-Page Up

Scroll to Selected Cell

Control-Delete

Source: Microsoft Excel Keyboard Shortcuts. Contrast with Numbers Keyboard Shortcuts.

Previously: Microsoft Excel 2011 for Mac Keyboard Shortcuts.

Keyboard Shortcuts Mac Mac App Microsoft Excel

3 Comments RSS · Twitter

---

---

---

Leave a Comment

Name

E-mail (will not be published)

Web site

Δ