Home / MS-Excel / Excel 2003

Excel 2003 Using Range Names

When working with spreadsheets, naming cell ranges you need to find quickly or print routinely is a really important way to save time. So too, naming cells that are referenced in your master formulas is a really efficient way to document their functioning. Finally, assigning range names to constants that you refer to in formulas (such as a fixed discount rate or rate of growth) is a really resourceful way to have access to a stable value without having to stick it in some cell in the worksheet.

In this tutorial, you find out how to use all three of these procedures to save time in a worksheet that you access and edit on a somewhat regular basis.