This week’s shortcut will combine two similar and very useful shortcuts: selecting the entire row and selecting the entire column. Although they are executed with two different key combinations they perform a very similar function.
Step 1: A great part about this shortcut is you can execute it from any cell in the column you want to select.
With the active cell in the picture above I am setting myself up to highlight the column.
Step 2: To highlight the column, execute the “Select Entire Column” shortcut. This shortcut can be found on the space bar. Like all Excel Skin shortcuts, the “Select Entire Column” shortcut is color-coded and corresponds to the modifier key, or keys, that match the color-coded text. The “Select Entire Column” text is yellow. Looking to our modifier keys we can see the "control" key is the only modifier key with the corresponding yellow text. Therefore our shortcut to select the entire column is ⌃Space Bar.
Once the shortcut is executed the entire column will be selected:
From here you can modify the selected column in any way you like.
Selecting the entire row uses the same exact process as selecting the entire column, only with different keystrokes for the shortcut.
Step 1: Select a cell in the row you wish to highlight.
Just as when selecting the entire column, any cell in the row you wish to select may be active.
Step 2: The “Select Entire Row” shortcut is also found on the space bar in blue text. The “Select Entire Row” text corresponds with the color on the “shift” key, therefore our shortcut to select the entire row is ⇧Space Bar.
Now the entire row is selected.
Selecting an entire row or column can be used for an infinite number of reasons. Perhaps you want to highlight a row or column to make it stand out in your spreadsheet, or maybe you are trying to copy the row or column and move it elsewhere. Whatever it is you may be doing, selecting the entire row or column with this shortcut will speed up the process.
Comments will be approved before showing up.