Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours

Using Ranges

If you know the cell address of the data you need to locate, you'll have no trouble moving to the spot. But unless you have a photographic memory, you probably won't remember the cell locations of all your important data. Even if you can spout cell locations, the cell addresses of your data change as you add and delete cells, rows, and columns.

Ranges provide a better way to organize and describe your data. A range is a rectangular block of cells that can be named with a descriptive name. Instead of trying to remember where the Utilities budget is located, you can specify the range name that holds the information to have Excel whisk to the first cell of the range. You can also use ranges for formatting and printing, and you can use ...