200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

View – Microsoft Excel Shortcuts

View

Excel offers a diverse set of ways you can view your spreadsheets. From hiding select cells to entire rows and columns, there are a number of shortcut options you can take advantage of to get the most optimal view to complete your work.

Display insert dialogue box
Ctrl Shift +
Control Shift I
Display delete dialogue box
Ctrl -
Control -
Insert rows
Ctrl Shift +
Control Shift I
Insert columns
Ctrl -
Control Shift -
Deletes rows and shifts remaining rows up
Ctrl -
Control -
Deletes columns and shifts remaining rows up
Ctrl -
Control -
Delete cells
Ctrl -
Ctrl -
Delete cell contents
Delete
Fn Delete
Hide the row of the current selection
Ctrl 0
Control 0
Hide the column of the current selection.
Ctrl 9
Control 9
Unhide row
Ctrl Shift 0
Control Shift 0
Unhide column
Ctrl Shift 9
Control Shift 9
Group rows or columns
Alt Shift →
⌘ Shift K
Ungroup rows or columns
Alt Shift ←
⌘ Shift J
Toggle outline symbols
Ctrl 8
Control 8