Selecting Column(s) or Row(s) Using Keyboard Shortcuts in Microsoft Excel | Excel Keyboard Shortcuts

Selecting Column(s) or Row(s) Using Keyboard Shortcuts in Microsoft Excel

While preparing reports and dashboard in MS Excel keyboard shortcuts, its time-consuming to select the entire column using the mouse. These excel shortcuts is useful to save time and help you do your work faster using the keyboard shortcut keys. How to select row with the Excel shortcut?

Excel keyboard shortcuts select Column:-

Select any cell which you want to select
Press and hold the CTRL key on your keyboard
Press the space key
Release the CTRL key and space key and the entire row will be selected
If you, want to select more than 1 column, don’t release the shift key, use the arrow key to select more than 1 column

jh1
Similarly while selecting rows using the keyboard, we can follow these steps -

Select any cell which you want to select
Press and hold the shift key on your keyboard
Press the space key
Release the shift key and space key and the entire row will be selected
If you wish to select more than 1 row, don’t release the shift key; use the arrow key to select more than 1 row.

Also you can select couple of Columns and Rows using shift and arrow key, which are the shortcut keys in Microsoft Excel.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Previous

Next

Users are saying about us...

Dhananjaya
November 27, 2014 at 9:19 am

Indeed very useful for those work on excel.

Thanks a Lot

Reply ↓
Kurniadi
January 9, 2015 at 9:17 am

Thank you, very helpful

Reply ↓
Naresh
February 4, 2015 at 5:32 pm

Very very useful.. thanks a lot

Reply ↓
AATHI LINGESWARAN
July 11, 2015 at 10:23 am

VERY USEFUL

Reply ↓
Rocky
July 15, 2015 at 8:29 am

Indeed very Useful & Helpful post.

Thanks a ton for sharing this with us

Reply ↓
Martin
July 15, 2015 at 8:31 am

Nice work team…It is really good for those who work frequently on excel. loved it.

Reply ↓
iqbal Tk
January 27, 2016 at 5:50 am

Thank you…….

Reply ↓
Nell
February 5, 2016 at 5:23 am

Thanks a lot , it helped organize me a lot of messy columns.

Reply ↓
janardhan
August 2, 2016 at 6:10 am

thank u for your kind information

Reply ↓
John
August 24, 2016 at 10:59 am

Also, you can hold Ctrl and one of the arrow keys to move across an entire range (as long as the row or column are consistent. The marker will stop on an empty cell).
Naturally, if you add Shift to this it will select the range you move across.

Ctrl + Shift + Arrow

Reply ↓

Leave a Reply Cancel reply

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.