200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Row and Column Selection – Microsoft Excel Shortcuts

Row and Column Selection

Mass edits can save you incredible amounts of time within Excel. Often you will want to control entire rows or columns in order use the data to create charts/graphs, or simply to move and edit many cells at once. Shortcuts within this section will help you control large quantities of data with ease.

Select entire row
Shift Space
Shift Space
Select entire column
Ctrl Space
Control Space
Select entire data range of the current selection
Ctrl A
⌘ A
Add adjacent cells to current selection
Shift Click
Shift Click
Add non-adjacent cells to current selection
Ctrl Click
⌘ Click
Move selection to next column
N/A
Option Tab
Move selection to previous column
Option Shift Tab
Move right between non-connected cells
Ctrl Alt →
Control Option ►
Move left between non-connected cells
Ctrl Alt ←
Control Option ◄
Activate/turn off add-to-selection mode
Shift F8
Fn Shift F8
Cancel selection
Esc
Esc