Grid Operation Shortcuts
If you are working with Excel, using the grid is essential. The following list contains the most useful Excel shortcuts regarding grid navigation. Select cells and ranges as soon as possible. Excel basic shortcuts like hiding and unhiding rows & columns boost your productivity.
| Command | Windows Shortcuts | Mac Shortcuts |
|---|---|---|
|
Display Insert Dialog box |
Ctrl + Shift + + |
Ctrl + Shift + + |
|
Insert rows |
Ctrl + Shift + + |
Ctrl + Shift + + |
|
Insert columns |
Ctrl + Shift + + |
Ctrl + Shift + + |
|
Display Delete dialog box |
Ctrl + – |
Cmd + – |
|
Delete rows |
Ctrl + – |
Cmd + – |
|
Delete columns |
Ctrl + – |
Cmd + – |
|
Delete cells |
Ctrl + – |
Cmd + – |
|
Delete contents of selected cells |
Delete |
Fn + Delete |
|
Hide columns |
Ctrl + 0 |
Ctrl + 0 |
|
Hide rows |
Ctrl + 9 |
Ctrl + 9 |
|
Unhide rows |
Ctrl + Shift + 9 |
Ctrl + Shift + 9 |
|
Unhide columns |
Ctrl + Shift + 0 |
Ctrl + Shift + 0 |
|
Group rows or columns |
Alt + Shift + → |
Cmd + Shift + K |
|
Ungroup rows or columns |
Alt + Shift + ← |
Cmd + Shift + J |
|
Open Group Dialog Box (with cell or range selected) |
Alt + Shift + → |
Cmd + Shift + K |
|
Open Ungroup Dialog Box (with cell or range selected) |
Alt + Shift + ← |
Cmd + Shift + J |
|
Hide or show outline symbols |
Ctrl + 8 |
Ctrl + 8 |