VBA code: Highlight all cells with formulas Sub FindFormulaCells() Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. The following VBA code may help you to highlight all the formula cells to make them standout.ġ. Then click OK, all the cells with formulas have been selected at once. In the Go To Special dialog box, select Formulas and check all options under the Formulas, see screenshot:Ĥ.

Click Home > Find & Select > Go To Special, see screenshot:ģ. Select the range that you want to select the formula cells.Ģ. If you want to find and select the formula cells, you can also apply the Go To Special command to deal with this task.ġ. Then you can drag the fill handle to the range of cells that you want to check the corresponding cells if are formulas, see screenshot: Enter this formula: =ISFORMULA(A1)( A1 is the cell that you want to check if it is a formula) into a blank cell to check if the specific cell contains a formula or not, then press Enter key to get the result, FALSE indicates that is not a formula, TRUE stands for containing a formula. Highlight all cells with formulas with VBA codeĪutomatically highlight all formulas within whole workbook with Kutools for Excelīy default, there is a simple function for you to check if a cell contains formula in Excel, please do as follows:ġ. In Excel, do you have any good ways to find or check the cells with formulas at once?Ĭheck if cells contain formulas with Functionįind and select all cells with formulas with Go To Special command If you have a large worksheet which contains some formulas, and now, you want to find or check if the cells contain formulas. How to check if / find cells contains formulas in Excel?

Kutools excel formula help