< 1. In the Find and Replace dialog box, click Options to expand the list of formatting options. 2. i Delete the search text from the Find what and Replace with boxes, leaving those two boxes empty. By not specifying a text string to find and replace, the dialog box will search through all cells regardless of their content