Try it! Name the rectangular range containing the numbers Data.
When you type the range name in the name box, make sure you then press Enter to make the name “stick.” It’s easy to type the name and then click on some other cell without pressing Enter. (I’ve done it hundreds of time.) If you do so, you’ll find that the range name was not created.
To delete a range name:
Select the Name Manager in the Defined Names group of the Formulas ribbon. This shows a list of all range names in your workbook. Click on the one you want to delete, and then click on the Delete button.
Suppose a range has name Costs and you want to rename it UnitCosts. If you highlight the range, the name box will show Costs. If you then overwrite this with UnitCosts in the name box, the range will have two names, Costs and UnitCosts. There is nothing inherently wrong with this, but if you want only a single name, UnitCosts, you will have to delete the Costs name, as described here.
Dostları ilə paylaş: |
