Let’s take a look.
To see what is currently selected, check the name box.
The name box will display a reference to the current selection.
To select one cell in Excel, just click anywhere in the worksheet.
Notice that the address shown in the name box is continuously updated.
If you watch the name box, you’ll see the number of rows and columns currently selected.
This will change dynamically as you expand or reduce the selection.
The active cell is always highlighted.
What if you want to select cells that aren’t next to one another?
For that, we need to use a modifier key to tell Excel to add to our selection.
Make the first selection normally.
Then, while holding down the control key, make your next selection.
you might add as many selections as you like.
Why would you want to make multiple selections?
The most common reason is to change the formatting in more than one cell at a time.
We’ll look at how to do this in a future lesson.