Excel: Select columns or rows in their entirety

Office 365 / SharePoint Blog

When you need to select a whole column, click on the column letter, and it will highlight the column. You can then manipulate the content or the formatting of that cell.

Excel: column selected

To select a whole row, click on the row number and it will highlight the row so you can make adjustments to fonts, etc.

Selecting Rows and Columns using Spacebar Shortcut

I also recently learned about a keyboard shortcut involving the Spacebar.

Ctrl + Spacebar selects the entire column

Shift + Spacebar selects the entire row

Using these shortcuts will save us from having to highlight and drag our way through a long worksheet.

Advertisements

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