Manually Find Formula Cells in MS Excel

December 10, 2012 Excel  No comments

Manually Find Formula Cells in MS Excel

You’re working within a MS Excel and you need to find the cells that’s numbers have been created by using formulas. In this brief tutorial, learn how to quickly find the cells within a spreadsheet that have formulas. If you have any questions, feel free to email us at questions@pbttinfo.com.
* * * * *

1. Start by click the ‘Find & Select’ icon under the ‘Home’ ribbon

 

 

 

 

 

 

 

 

2. Click the ‘Formulas’ option from the drop down menu. This will highlight all the cells that contain formulas

 

 

 

 

 

 

 

 

If you have any question or suggestion, feel free to comment or email us at questions@pbttinfo.com

See you soon for the next trick!

Jess – Desktop Training Academy

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>