Today I want to write about another great shortcut that will hurry your Excel work along. Often you will want to do something to an entire row or column, such as making the “Totals” row bold, or inserting columns into your spreadsheet. Excel has an easy to remember shortcut that lets you accomplish this in a split-second.
To select an entire row, press SHIFT + SPACEBAR.
To select multiple rows, press SHIFT + SPACEBAR, then hit SHIFT + ↑ or SHIFT + ↓ to select additional rows.
To select an entire column, press CTRL + SPACEBAR.
To select multiple columns, press CTRL + SPACEBAR, then hit SHIFT + → or SHIFT + ← to select additional columns.