• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 19. Excel Essentials > Using Ranges to Work with Multiple Cells

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 (page 535) and labels for values and categories.

Tip

A rapid-fire data-entry technique lets you stuff the same data into multiple cells in one smooth operation. This trick comes in especially handy when you're entering a formula or a default value, such as zero, into a noncontiguous range. First, select the range into which you want to enter the identical data. Next, type the formula or data into the active cell, but hold down Ctrl when you press Enter.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint