How to identify cells that contain formulas in Excel

Forum to talk about all the latest technologies - ins and outs!!
Post Reply
Admin
Site Admin
Posts: 325
Joined: Tue Sep 25, 2007 12:41 pm

How to identify cells that contain formulas in Excel

Post by Admin »

If you are working with an Excelsheet and would like to know which cells contain formulas, then follow the steps to easily identify them:


Go to Home tab > from under the Editing group click on Find & Select > click on Go To Special.... > Go to Special dialog box opens


Alternatively, press CTRL + G > Go To dialog box opens > click on the Special... button (bottom left corner) > the Go to Special dialog box opens


Image


Now select the ‘Formulas’ radio button > click OK.


This will highlight all the cells in your Excelsheet that contain formulas, as the example below:


Image




One more thing:

As you see, the Formulas radio button contains 4 options - Numbers, Text, Logicals and Errors. Generally we keep them all selected. These are the return types of the formulas, that means,


if you would check only 'Text', then cells that contain Formulas whose return type is 'text' will be highlighted.


if you would check only 'Logicals', then cells that contain Formulas whose return type is 'Logical' (True or False, for example the ISBLANK() function which returns either True or False) will be highlighted.
Frokcal44
Posts: 1
Joined: Fri Aug 23, 2019 12:41 pm

Re: How to identify cells that contain formulas in Excel

Post by Frokcal44 »

This is not easy to identify these cells because I tried that too many times but at last I have to asked a specialist and he that better after identifing the cells. I am getting busy in my business of topresume.com and for this i find some time vwry difficult. So, you shpuld have to meet a specialist for your problem.
Beauvais
Posts: 4
Joined: Tue Sep 01, 2020 8:50 am

I am very enjoyed for this blog

Post by Beauvais »

I am very enjoyed for this blog. Its an informative topic. It help me very much to solve some problems. Its opportunity are so fantastic and working style so speedy FOR MORE DETAILS.
Post Reply