Excel saves your previous formatting criteria, so to avoid confusion, you need to clear them. Click the down arrow next to the Find What field, and select "Clear Find Format." Then, click "Clear ...
Visual chaos: The alternative to the slow, stop-start process is clicking "Show All Notes" or "Show Comments" in the Review ...
Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.