Whenever you are auditing an Excel worksheet and need to know where all the formulas are located, a great way is to highlight the formula cells in a distinctive color.  This is how it is done:

1.Select all the cells in your Excel worksheet by clicking on the top left hand corner of your worksheet.

2.Press the CTRL+G shortcut which will open up the Go To dialogue box and select the Special button.

3.Select the Formula radio button and press OK.

4.This will highlight all the formulas in your Excel worksheet and you can use the Fill Color to color in the formula cells.

You can practice this cool trick by downloading this workbook:


Highlight all Formula Cells




If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Excel Table Headers Show in Columns Before Excel Tables were introduced in Excel 2007, there were Excel Lists which had limited functionality. For example, when you had a list of data with hundreds of rows and you had to scroll all the way down to the bottom of your list, the Headers row was not visible and you ...
INDEX Function with Data Validation To make the INDEX function in Excel interactive we can add a Data Validation drop down list. By referencing the second argument in the INDEX function - the Row Number - to a data validation list, will allow a user to choose the nth position of a list and return their respectiv...
Excel’s Subtotal Feature Excel´s Subtotal feature is a great way to automatically insert a Sum/Count/Average/Max/Min subtotal to your data set with a press of a button. This feature is located under the Excel Data tools menu: Data > Subtotal.  To insert this feature you need to follow these quick s...
Create a Dynamic Data Range with the OFFSET functi... What does it do? It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cells Formula breakdown: =OFFSET(reference, rows, columns, , ) What it means: =OFFSET(start in this cell, go up/down a number o...