Sunday, August 31, 2014

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.)

2 Comments RSS · Twitter

[…] Previously: Microsoft Excel 2011 for Mac Keyboard Shortcuts. […]

[…] Shift-key drag-and-drop method from Excel 2011 doesn’t work anymore. The “best” way I’ve found is to Select, Cut, Select, […]

Leave a Comment