Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do you highlight a series of columns or rows using only the keyboard?

user-image
Question added by Deleted user
Date Posted: 2016/10/27
Majid Ali Butt
by Majid Ali Butt , Accountant Supervisor , AL-MURTAZA FLOUR & GENERAL MILLS

Ctrl + Space bar for entire column selection whereas

Shift + Space bar for entire row selection

Ahmad Abdel karim
by Ahmad Abdel karim , group financial director , Sarwa Capital

To select columns: Ctrl + Space

To select Rows:Shift + Space

 

Deleted user
by Deleted user

You could also use the following:

 

Ctrl + Shift then arrow keys depending on the direction of the data you intend to highlight.

 

Using this, you can reduce selection to the data you really intend to use and avoid highlighting the whole column or row.

 

Give it a try. :)

More Questions Like This