O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required