Select Formula cells only

Is there a way to select all cells that have a formula?

By Neale Blackwood

Yes. Hold the Ctrl key and press the “a” key to select the whole sheet. Then press F5 (GOTO), click the Special button, then click the Formulas radio button and select the types of formula you want by using the check boxes. Then click OK.

This method of selection is useful for formatting an protecting Formula Cells. Check out the other options in the Special section as they can speed up some selections.


Sometimes you need to Press Ctrl + a twice.  The first time, Excel selects the current region. The second time, it selects the whole sheet.

Clicking the grey area where the row numbers and column letters intersect also selects the whole sheet.