I had already talked about it in the previous lesson, but what is a cell range and what can we do with this?
A cell range are all, with the emphasis on “all”, side by side or non-adjacent cells, which are selected.
This collection of cells is considered as a whole and is called a cell range, “range” in short.
What can we do with a range?
When we name a range we can use this name in a formula, a list, or whatever.
I already told you how to select cells in a worksheet.
When you select multiple cells, we speak of a “range”.
For the sake of clarity I will go over it again.
To select adjacent cells, click the first cell, and drag the mouse pointer to the last cell. Or you click the first cell, hold down the Shift key and click the last cell. It does not matter how you do it.
To select non-adjacent cells, select the first cell or cells, hold down the Ctrl key on your keyboard, and select the second cell or set of cells. You can select as many cells as you want.
In the image below you have an example of selected adjacent cells on the left.
And on the right you have an example of selected non-adjacent cells.
We therefore call both the Range in our Excel worksheet.
Give the Range a name
To give the Scope a name, we first select the Scope, type an appropriate name in the name box, and click the Enter key on our keyboard.
How we use this in a formula I tell you later, just remember how to give a Range a name.
Enter data in a Range
When we first select a range and only then enter our data, Excel will respect our scope.
For example, we have entered the turnover for cell B2, and click the Enter key, the next cell that is selected is cell B3, this continues until we reach the bottom cell in our Scope.
In this case, therefore, cell B6, you click the Enter key, then cell C2 is selected in our Scope.
And so on to the last cell in our Reach, cell E6. If you click on the Enter key, the first cell in our Scope is selected, cell B2.
If you want to provide all cells in the Scope with the same value, hold down the Ctrl key on your keyboard while pressing the Enter key.