Microsoft Excel 2011 for Mac Keyboard Shortcuts

Rows and Columns

Select Current Row

Shift-Space

Select Current Column

Control-Space

Insert Row Above

(Shift-Space,) Control-I

Insert Column Left

(Control-Space,) Control-I

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-(

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-;

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.

Update (2015-03-31): To AutoFit multiple column widths at once, select the columns (or click the Select All button at the top left) and then double-click a divider between any two column headers.

To move/reorder a column, select the column, move the cursor to the column edge (below the header) until it changes to the hand, then hold down the Shift key when you drag and drop the column. (If you don’t hold down Shift, Excel will replace the destination column instead of inserting the source column at that position.)

Keyboard Shortcuts Mac Mac App Microsoft Excel

2 Comments RSS · Twitter

---

---

Leave a Comment

Name

E-mail (will not be published)

Web site

Δ