Selecting Column(s) or Row(s) Using Keyboard Shortcuts





While preparing reports and dashboard in MS Excel, its time-consuming to select the entire column using the mouse. These tips will help you save time and help you do your work faster using the keyboard shortcut keys.

 

Selecting the entire 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.

 

jh22

 

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

 

image3



Leave a Reply

Your email address will not be published. Required fields are marked *


3 × eight =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>