A device of computer is Mouse by which you can easily select, drag (Press Left Click of a Mouse and Hold it and then move it over a Data Table) cells of a Data Table. But for faster and work like a professional, you can also use Keyboard Shortcut. In this tutorial I've tried to share 8 different cursor movements for Selecting Cells and Ranges of a Data Table in Excel 2016. If you practice these, then it's good go for next level.
Faysal Easy Excel Video Tutorial of Selecting Cells and Ranges in Excel
One: Select Single Cell:
To select any of a single cell of a data table, just Left Click (Right Handed Mouse User) on that cell. Now this cell has selected. You can apply any formatting to test it.
Two: Select More cells in a Range:
Most of the Excel users will use Mouse Left Click + Drag to Select more than single cells in a range of a data table. But if you are not keen on using the mouse, you can use the keyboard to select the cells you want. Press and Hold the Shift key and then Press Arrow Keys to select a range.
Three: Select Specific few cells:
Press and hold Ctrl key and then Left Click specific random cells to select them.
Four: Select Entire Row:
To select entire row, Left Click on Row Number or Select any cell of that row and press Shift and Space Bar at once.
Five: Select Entire Column:
To select entire Column, Left Click on Column Name or Select any cell of that Column and press Ctrl and Space Bar at once.
Six: Select Entire Data Table:
Click anywhere of a data table and press CTRL + A (Select All).
Seven: Select Header Row Only:
Click on first cell and then press and hold Shift + Ctrl + Right Arrow Key at once.
Eight: Select First Column Only:
Click on first cell and then press and hold Shift + Ctrl + Down Arrow Key at once.
There are some others Keyboard Shortcuts are available. But these are the basic for beginners. In the future I'll try to share more. Stay tuned.
Comments