Try it! The numerical range is currently named Data. Delete this range name and then rename the range Database.
Suppose you have the labels Revenue, Cost, and Profit in cells A20, A21, and A22, and you would like the cells B20, B21, and B22 (which will contain the values of revenue, cost, and profit) to have these range names. Here’s how to do it quickly.
To create range names from adjacent labels:
Select the range consisting of the labels and the cells to be named (A20:B22). Then click on the Create from Selection button in the Defined Names group of the Formulas ribbon. In the resulting dialog box, make sure the appropriate option (in this case, Left Column) is checked, and click on OK.
Excel tries (usually successfully) to guess where the labels are that you want to use as range names. If it guesses incorrectly, you can always override its guess.
Dostları ilə paylaş: |
