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
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