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





In Microsoft Excel 2010/2013 selecting the entire rows or columns using mouse is rather a bit time taking, so here below are some tips which will save your time selecting the entire rows or entire columns

  • Selecting entire rows:-
    • Go to any of the cell of the row, which is require to be selected
    • Press and hold shift
    • Press space key
    • Release shift key and space key and entire row will be selected

 

1

 

 

 

  • Selecting entire columns
    • Go to any of the cell of the column, which is require to be selected
    • Press and hold ctrl
    • Press Space key
    • Release ctrl key and space key and entire column will be selected.

 

2

 

 



Leave a Reply

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


+ 5 = thirteen

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>