Row and Column Selection – Microsoft Excel Shortcuts
200 Excel Shortcuts for PC and Mac
So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fancier (and more productive) because we’ve curated 200 of the best Excel keyboard 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.
| Shortcut | Windows | Mac |
|---|---|---|
| Select entire row If you are attempting to make mass edits to an entire row, this shortcut allows you to select all the cells and their data within the row you are working on. | Shift Space | Shift Space |
| Select entire column If you are attempting to make mass edits to an entire column this shortcut allows you to select all the cells and their data within the column you are working on. | Ctrl Space | Control Space |
| Select entire data range of the current selection This selects the entire contiguous data range from your current selection. If this is not the entire worksheet, pressing this shortcut a second time will select the entire sheet. If your selection is within an Excel Table, Ctrl + A will select only the data portion of the table. A second time pressing Ctrl + A will include the header row, and a third will select the entire sheet. | Ctrl A | ⌘ A |
| Add adjacent cells to current selection While a cell is selected, press Shift and click on another cell. All adjacent cells in between selections will be selected. This can be on a single row or column as well as a range on different rows and columns. | Shift Click | Shift Click |
| Add non-adjacent cells to current selection This shortcut adds only the cells you click on while pressing Ctrl/Command to the current selection. | Ctrl Click | ⌘ Click |
| Move selection to next column Select and relocate your cell selection to the column to its right. This is a mac only function. | Option Tab | |
| Move selection to previous column Select and relocate your cell selection to the column to its left. This is a mac only function. | Option Shift Tab | |
| Move right between non-connected cells Once you have selected the non-connected cells that you wish to edit, you can jump between them (in this case to the right) with this useful shortcut. | Ctrl Alt → | Control Option ► |
| Move left between non-connected cells Once you have selected the non-connected cells that you wish to edit, you can jump between them (in this case to the right) with this useful shortcut. | Ctrl Alt ← | Control Option ◄ |
| Activate/turn off add-to-selection mode If you would like to add cells to your selection that are not connected without holding down control keys, this shortcut allows you to do so. | Shift F8 | Fn Shift F8 |
| Cancel selection Accidently select a cell or data within a cell? Simply use this shortcut to undo your selection. | Esc | Esc |