Tuesday, September 15, 2015

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.

3 Comments RSS · Twitter

Thanks for this article, useful but I'm missing one piece;

How can I select rows starting from "42" to the end of the sheet (so I can hide them) followed by select column "R" to the end where I can then hide them..

[…] una persona muy inteligente publicó estos cambios en otro blog (en inglés). Dejo este link acá por si alguna persona llega […]

Crosswalk for 2011-2016 shortcuts I have found most useful

Delete rows or columns: Ctrl K becomes Ctrl -
Blank Cell contents: Ctrl B becomes Fn Delete

Too bad Microsoft doesn't provide an alphabetical or sortable (maybe in a spreadsheet?!) crosswalk of all the shortcuts!

Thanks for your contribution.

Leave a Comment