Range Names
Range names are extremely useful for making your formulas more understandable. After all, which formula makes more sense: =B20-B21 or =Revenue-Cost? Efficient use of range names takes some experience, but here are a few useful tips.
To create a range name:
Select a range that you want to name. Then type the desired range name in the upper left “name box” on the screen. (This box is just above the column A heading. It usually shows the cell address, such as E13, where the cursor is.)
You can also select the Formulas menu and use the Define Name option in the Defined Names group to name a range, but typing the range name in the name box is quicker and more intuitive. By the way, range names are not case sensitive, so that Revenue, revenue, and REVENUE can be used interchangeably.
Dostları ilə paylaş: |
