Special Edition Using Microsoft® Office XP

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