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

Chapter 2. Spreadsheet Basics > Selecting Ranges on Grouped Worksheets

Selecting Ranges on Grouped Worksheets

In addition to being able to select contiguous or noncontiguous ranges on a single worksheet, you might occasionally want to select the same ranges on multiple worksheets within a workbook. Why might you want to select cells/ranges from several sheets at once? The following list offers some suggestions:

  • To speed up and simplify formatting changes— Want to make all titles on all sheets look the same? Select them all at once and then apply the formatting.

  • To expedite editing a series of cells— You know that a selected range of cells can be edited, cell by cell, with the Enter or Tab keys. What if you want to make changes to cell content on several sheets? Go through the workbook and select all the ranges, so as you edit and press Enter or Tab, you’re taken automatically to the next cell in the series to be edited. Keep in mind, however, that grouped worksheets have the same selections on every sheet; you can’t select one set of ranges on one worksheet and a different set on another worksheet.

  • To make a quick deletion— Assume that your worksheets include multiple references to a sales rep you no longer employ or a product you no longer sell. Select the cells and ranges that refer to this person or product, and then press Delete. All cell content in those cells—in all worksheets included in the group—will be removed.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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