Friday, November 16, 2012

Highlight Cells in Excel that Contain a Formula


A new version of this post has been published on my new blog: 


http://easy-excel.com/?p=133




Is there an easy way to locate the cells in Excel that contain a formula? Yes, there is!

Open the Go to-window (Ctrl+G) and click on Special. Choose the radio button Formulas:














Click OK, and all the cells that contain a formula are highlighted!



No comments:

Post a Comment