Select the data in a column with the keyboard in Excel

Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Excel 97 and other Software topics.

How can I select all of the data in a column with the keyboard?

Select the data in a column with the keyboard in Excel

To select all the data in an Excel column (this won't work if you have completely empty cells), just do the following:

Click in the first cell you want to select and then hold down the control and shift keys and press the down arrow.

   

Comments

Nobody has commented on this tip yet. Be the first.



Name:


URL: (optional)


Comment:


Not finding the advice and tips you need on this Software Tip Site? Request a Tip Now!


Guru Spotlight
Lynne Christen