Shortcut to select entire rows or columns

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>