Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to identify cells that contain formulas in Excel

 
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum
View previous topic :: View next topic  
Author Message
Admin
Site Admin


Joined: 25 Sep 2007
Posts: 259

PostPosted: Tue Mar 14, 2017 7:59 pm    Post subject: How to identify cells that contain formulas in Excel Reply with quote

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





Now select the Formulas radio button > click OK.


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







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.





*Recommended:


Read wonderful articles (English & German) on Science & Tech, Environment, Health and many other topics only on BlogArena.


For comments of suggestions, please contact us: info@shamskm.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic     Forum Index -> Technology & How-To Forum All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group