How to Select Cells with a Formula

If you have a spreadsheet and need to find the cells that contain formulas, please follow the steps below for details:

Step 1: Click anywhere in the worksheet;

Step 2: Click the "Home" tab from the Ribbon;

Step 3: Click the "Find&Select" command in the "Editing" section;

Step 4: Click the "Go To Special" command from the drop-down list;

Step 5: In the new window, select "Formula" and check the formula types you want to search;

Step 6: In this example, we select all the cells with a formula (all types).

Leave a Reply