Selecting entire rows and columns in Excel via keyboard shortcuts

I was unaware of these two keyboard shortcuts that make selecting entire rows and columns in Excel a piece of cake.

Here I have a basic table in my spreadsheet:

excel-row-column-20170303-1

I clicked into cell A3 and pressed SHIFT + SPACE. Row 3 was highlighted to the end of the table row:

excel-row-column-20170303-2

I again clicked into cell A3 and pressed CTRL + SPACE (^ + SPACE on a Mac). Column A was highlighted to the end of the table column:

excel-row-column-20170303-3

This certainly beats my former technique of dragging the cursor around.

1 Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s