O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Working with Range Names

THE LARGER AND MORE COMPLEX your spreadsheets become, the harder it is to remember where the most important data is in the file. If you find yourself searching for the same data again and again, consider assigning a range name to the cells containing that data. By assigning a descriptive name to a single cell or range of cells, you will be able to find that data more quickly.

Naming a Range of Cells

Even though range names are meant to be customized to your requirements, you will still need to follow these simple rules.

  • Range names cannot contain spaces. Use an underscore to take the place of a space. For example, instead of Spring Sales, the range name would be Spring_Sales.

  • Range names must begin with a letter, not ...

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