If no cells are selected before the Find and Replace dialog box is opened, an error message prompts for the search range.

Name: If no cells are selected before the Find and Replace dialog box is opened, an error message prompts for the search range.
Brand: Quizplus
Rating: 4.9 (38 reviews)

Question

Quizplus · Accepted Answer

When no cells are selected before opening the Find and Replace dialog box, Excel defaults to searching the entire worksheet, not prompting an error message for the search range.

If No Cells Are Selected Before the Find and Replace