Chapter 4: Working with Excel Ranges and Tables
4
click the sheet tab of each additional worksheet that you want to select. If all of the work-
sheets in a workbook aren’t laid out the same, you can skip the sheets that you don’t want
to format. When you make the selection, the sheet tabs of the selected sheets display in
bold with underlined text, and Excel displays Group in the title bar.To select all sheets in a workbook, right-click any sheet tab and choose Select All Sheets from the shortcut menu.
When sheets are grouped, you are making changes to sheets you can’t see. Before you group sheets, be sure you
understand what changes you intend to make and how that will affect all the sheets in the group. When you’re done,
don’t forget to ungroup the sheets. You can overwrite data on the other sheets if you start typing on the active sheet
while in Group mode.
Selecting special types of cells
As you use Excel, you may need to locate specific types of cells in your worksheets. For
example, wouldn’t it be handy to be able to locate every cell that contains a formula—or
perhaps all of the formula cells that depend on the active cell? Excel provides an easy way
to locate these and many other special types of cells: select a range and choose Home ➪
Editing ➪ Find & Select ➪ Go To Special to display the Go To Special dialog box, as shown
in Figure 4.5.FIGURE 4.5
Use the Go To Special dialog box to select specific types of cells.