Microsoft Office Tutorials and References
In Depth Information
Working With Range Names
as Income too, and so you’d need to identify the particular sheet in any formula reference to
distinguish between the two Income ranges However, if you do confine the scope of this formula to
Sheet1, you can still write
in Sheet 1 itself. Write exactly the same expression in Sheet2 and it’ll refer to that range in Sheet2.
The Comment field lets you enter a description of the range you’re naming, thus explaining to
other viewers of the workbook exactly what you had in mind using the name.
You’ll also note that the Define Name command features a drop-down arrow. Click it and you’ll
see a rather quirky option, Apply Names. Apply Names lets you replace a standard range reference in
a formula with its name, if you’ve devised that name after writing the formula. For example, if you’ve
in a cell and then n a me d A 6 :A 2 0 In come , y ou ca n cl i ck i n a n y bl a n k ce l l , cl i ck De fi n e Na me A ppl y
Names, and click Income, which will be listed (Figure A–4):
Figure A–4. The Apply Names dialog box
The above formula will now read
An d so i f y ou’ v e n ame d fi v e di ffe r e n t r an g e s after you’ve already written formulas containing their
a ctua l ce l l r e fe r e n ce s, y ou ca n cl i ck a n y bl a n k ce l l , se l e ct A ppl y Na me s, cl i ck on a l l fi v e r a n g e n a me s
in the Apply Names dialog box, and those names will replace the cell references in all the formulas.
Yeah – that blank cell thing is quirky indeed.