Rows and Columns Shortcuts (Selection)

This section is separated into 5 parts. 1. General 2. Active Cell 3. Extend Selection 4. Select Special Cell 5. Cell Border

Command	Windows Shortcuts	Mac Shortcuts
Select entire row	Shift + Space	Shift+Space
Select entire column	Ctrl + Space	Ctrl + Space
Select entire worksheet	Ctrl + A	Cmd + A
Add adjacent cells to selection	Shift + Click	Shift + Click
Add non-adjacent cells to selection	Ctrl + Click	Cmd + Click
Same selection in next column	Opt + Tab
Same selection in the previous column	Opt + Shift + Tab
Move right between non-adjacent selections	Ctrl + Alt + →	Ctrl + Alt + →
Move left between non-adjacent selections	Ctrl + Alt + ←	Ctrl + Alt + ←
Toggle add or remove to selection mode	Shift + F8	Fn + Shift + F8
Cancel selection	Esc	Esc

 

Active Cell  

Command	Windows Shortcuts	Mac Shortcuts
Select a single (active) cell when the range is selected	Shift + Backspace	Shift + Delete
Show the active cell on the worksheet	Ctrl + Backspace	Cmd + Delete
Activate each corner cell in selected range in clockwise direction	Ctrl + .	Ctrl + .
Activate next cell in the selected range (based on direction set in Excel Options)	Enter	Return
Activate the previous cell in selection (based on direction set in Excel Options)	Shift + Enter	Shift + Return
Activate next cell to right/below in the selected range	Tab	Tab
Activate the previous cell to left/above in a selected range	Shift + Tab	Shift + Tab

 

Extend Selection  

Command	Windows Shortcuts	Mac Shortcuts
Extend selection by one cell right	Shift + →	Shift + →
Extend selection by one cell left	Shift + ←	Shift + ←
Extend selection by one cell up	Shift + ↑	Shift + ↑
Extend selection by one cell down	Shift + ↓	Shift + ↓
Extend the selection to the last cell right	Ctrl + Shift + →	Ctrl + Shift + →
Extend the selection to the last cell left	Ctrl + Shift + ←	Ctrl + Shift + ←
Extend the selection to the last cell up	Ctrl + Shift + ↑	Ctrl + Shift + ↑
Extend the selection to the last cell down	Ctrl + Shift + ↓	Ctrl + Shift + ↓
Extend selection up one screen	Shift + PgUp	Fn + Shift + ↑
Extend selection down one screen	Shift + PgDn	Fn + Shift + ↓
Extend selection right one screen	Alt + Shift + PgDn	Fn + Shift + Alt + ↓
Extend selection left one screen	Alt + Shift + PgUp	Fn + Shift + Alt + ↑
Extend selection to start of the row	Shift + Home	Fn + Shift + ←
Extend selection to the first cell in a worksheet	Ctrl + Shift + Home	Fn + Ctrl + Shift + ←
Extend selection to the last cell in a worksheet	Ctrl + Shift + End	Fn + Ctrl + Shift + →
Toggle extend selection mode	F8	Fn + F8
Select Spill Range	Ctrl + A

 

Select Special Cells  

Command	Windows Shortcuts	Mac Shortcuts
Display ‘Go To’ dialog box	Ctrl + G	Ctrl + G
Open the Go To Special window	Alt, H, F, D, S
Select cells with comments (Note)	Ctrl + Shift + O	Fn + Ctrl + Shift + O
Select current region around the active cell	Ctrl + Shift + 8	Shift + Ctrl + Space
Select current region	Ctrl + A	Cmd + A
Select current array	Ctrl + /	Ctrl + /
Select row differences	Ctrl + \	Ctrl + \
Select column differences	Ctrl + Shift + |	Ctrl + Shift + |
Select direct precedents	Ctrl + [	Ctrl + [
Select all precedents	Ctrl + Shift + {	Ctrl + Shift + {
Select direct dependents	Ctrl + ]	Ctrl + ]
Select all dependents	Ctrl + Shift + }	Ctrl + Shift + }
Select visible cells only (when range is selected)	Alt + ;	Cmd + Shift + Z

 

Cell Borders 

Command	Windows Shortcuts	Mac Shortcuts
Open Border dropdown menu on Home Tab	Alt, H, B
Add all borders to cells in the selected range	Alt, H, B, A
Add or remove Right Border	Alt, H, B, R	Cmd + Alt + →
Add or remove Left Border	Alt, H, B, L	Cmd + Alt + ←
Add or remove Top Border	Alt, H, B, P	Cmd + Alt + ↑
Add or remove Bottom Border	Alt, H, B, O	Cmd + Alt + ↓
Remove all borders (apply no borders)	Ctrl + Shift + _	Cmd + Alt + _