Abstract
Transcript
Excel has many useful shortcuts for selecting cells.
This includes shortcuts for selecting rows, columns, groups of cells, and even the entire worksheet.
Let’s take a look.
When you’re selecting individual cells, you could use the arrow keys to move the selection around.
To select an entire column, press control + spacebar.
To select an entire row, press shift + spacebar.
When you are inside a group of cells, control + A will choose the entire group.
If you key in control-A again, you’ll grab the entire worksheet.
Excel will extend the selection to the first empty cell.
This works for columns as well.