Microsoft Office Tutorials and References
In Depth Information
Naming Many Ranges – at the Same Time
Figure A–9. Pasting a named range – sort of
Press Enter and you’ll see 34567 – the contents of cell A6. But the formula bar view for that cell
will display =Income. What that means – at least what that means here – is that pasting the name of the
range Income in B6 posts the data in the corresponding Income cell only - which is A6 in this case. If I
copy the result in B6 down the B column, I’ll return each corresponding value down the A
columneven though each one of those cells will actually state =Income. You’re reporting each individual value
for each cell comprising the Income range – even though each of these cells is referenced by =Income –
which of course stands for cells A6:A20 – the whole range. I know what you’re thinking – this one is
pretty quirky, too.
Thus clicking OK in Paste Names requires - before you click OK - that you click in cells which must
line up with, or correspond to, the cells in the range name being pasted. If you carry out the Paste
Na me comma n d se que n ce i n ce l l B4 , for e xa mpl e – a ce l l whi ch doe s n ot cor r e spon d to a n y In come
range cell in the A column – you’ll see the #VALUE! error message in that cell after you press Enter.
Naming Many Ranges – at the Same Time
The next option in the Defined Names button group – Create From Selection – dates back to Excel’s
antiquity. Click on the Bowling Scores sheet tab on the Range Names workbook and select cells F10:I15
– a range which contains a collection of bowling scores as well as name and game-number labels (and
make sure you’ve selected the labels). Click Create From Selection, and you’ll see (Figure A–10):
Search JabSto ::

Custom Search