Excel 2010 Bible

Part I: Getting Started with Excel

74

4. Choose Home ➪ Font ➪ Bold and then choose Home ➪ Font ➪ Fill Color to
   apply a colored background. Excel applies the formatting to the selected range across
   the selected sheets.


5. Click one of the other sheet tabs. This step selects the sheet and also cancels Group
   mode; [Group] is no longer displayed in the title bar.

When a workbook is in Group mode, any changes that you make to cells in one worksheet also

apply to all the other grouped worksheets. You can use this to your advantage when you want to

set up a group of identical worksheets because any labels, data, formatting, or formulas you enter

are automatically added to the same cells in all the grouped worksheets.

Note
When Excel is in Group mode, some commands are disabled and can’t be used. In the preceding example, you
can’t convert all these ranges to tables by choosing Insert ➪ Tables ➪ Table. n

In general, selecting a multisheet range is a simple two-step process: Select the range in one sheet

and then select the worksheets to include in the range. To select a group of contiguous worksheets,

you can press Shift and click the sheet tab of the last worksheet that you want to include in the

selection. To select individual worksheets, press Ctrl and click the sheet tab of each worksheet that

you want to select. If all the worksheets 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 appear with a white background, and Excel displays [Group] in the title bar.

Tip
To select all sheets in a workbook, right-click any sheet tab and choose Select All Sheets from the shortcut
menu. n

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 the

cells whose value depends on the current cell? Excel provides an easy way to locate these and

many other special types of cells. Simply choose Home ➪ Editing ➪ Find & Select ➪ Go to

Special to display the Go to Special dialog box, shown in Figure 4.5.

After you make your choice in the dialog box, Excel selects the qualifying subset of cells in the cur-

rent selection. Often, this subset of cells is a multiple selection. If no cells qualify, Excel lets you

know with the message No cells were found.

Tip
If you bring up the Go to Special dialog box with only one cell selected, Excel bases its selection on the entire
used area of the worksheet. Otherwise, the selection is based on the selected range. n