O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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 to Work with Multiple Cells

Any selection of two or more cells is called a range. You can dramatically increase your productivity by using ranges to enter, edit, and format data. For example, if you highlight a range and click the Currency Style button, all the numeric entries in that range appear with dollar signs and two decimal places. Assigning a name to a range makes it easier to construct (and troubleshoot) formulas, and ranges make up the heart and soul of charts by defining data series and labels for values and categories.

Tip from

A rapid-fire data-entry technique lets you stuff the same data into multiple cells in one smooth ...

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