Microsoft Excel 2016 for Mac Keyboard Shortcuts
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.
Comments
Post a Comment