Excel 2019 Bible

Chapter 4: Working with Excel Ranges and Tables

4

Option What it does

Last Cell Selects the bottom-right cell in the worksheet that contains data or for-

matting. For this option, the entire worksheet is examined, even if a range

is selected when the dialog box displays.

Visible Cells

Only

Selects only visible cells in the selection. This option is useful when deal-

ing with a filtered list or a table.

Conditional

Formats

Selects cells that have a conditional format applied (by choosing Home ➪

Styles ➪ Conditional Formatting). The All option selects all such cells. The

Same option selects only the cells that have the same conditional format-

ting as the active cell.

Data Validation Selects cells that are set up for data entry validation (by choosing Data ➪

Data Tools ➪ Data Validation). The All option selects all such cells. The

Same option selects only the cells that have the same validation rules as

the active cell.

When you select an option in the Go To Special dialog box, be sure to note which suboptions become available. The
placement of these suboptions can be misleading. For example, when you select Constants, the suboptions under
Formulas become available to help you further refine the results. Likewise, the suboptions under Dependents also
apply to Precedents, and those under Data Validation also apply to Conditional Formats.

Selecting cells by searching

Another way to select cells is to choose Home ➪ Editing ➪ Find & Select ➪ Find (or press

Ctrl+F), which allows you to select cells by their contents. The Find and Replace dialog box

is shown in Figure 4.6. This figure illustrates additional options that are available when you

click the Options button.

FIGURE 4.6

The Find and Replace dialog box, with its options displayed