Saturday, 4 April 2015

Shortcut key to Select Entire Column & Rows in MS Excel

Shortcut key to Select Entire Column & Rows in MS Excel              Using mouse always takes more time than using keyboard shortcut keys, especially in Microsoft Excel… If you don’t know basic keyboard shortcut keys of MS excel, than it will irritate you to work in excel.. There are many tips and keyboard shortcut keys in MS excel, today I am going to show one of them.  So today’s topic is how to select entire column and rows by using keyboard shortcut keys in Microsoft Excel…This will shortcut key will work all the version of MS excel like 2003, 2007, 2010 and 2013..  Just follow these steps.

1.     Keep your cursor from start point to select entire columns or rows.
2.     Hold “Ctrl+Shift” and press “Down arrow” to select entire column
Shortcut key to Select Entire Column & Rows in MS Excel

3.    The same key will work for selecting rows hold “Ctrl+Shift” and press “left arrow” to select entire row.
4.    Use Down/UP/Right/Left arrow keys to select entire columns and rows


Watch video tutorial…. Please like, share and subscribe

No comments:

Popular Posts