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:

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

Highlight all Formula Cells


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

Highlight all Formula Cells


STEP 3: Select the Formula radio button and press OK.

Highlight all Formula Cells


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

Highlight all Formula Cells

And now all your cells containing formulas are now highlighted!

Highlight all Formula Cells

You can practice this cool trick by downloading this workbook:


How to Highlight All Formula Cells in Excel

Highlight all Formula Cells


How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel



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

Dynamic Data Validation List What´s a dynamic data validation drop down list in Excel, you say? Well, as you add new data into your Excel Table, your drop down list automatically gets updated. That is a cool feature and it means that you do not need to update your data validation source reference each ...
Add Hyphens To Serial Numbers Using Excel Flash Fi...   Flash Fill in Excel is a new feature that was introduced in Excel 2013. Flash Fill allows you to combine, extract, move & transform data that belongs in one column, into a new column. One of the cool uses of Flash Fill is formatting numbers.  In our example be...
Calculate Elapsed Time in Excel   What does it do? Converts a formula to text and lets you specify the display formatting by using special format strings Formula breakdown: =TEXT(value1 - value2, format text) What it means: =TEXT(formula, a text string enclosed in quotation marks) ...
VLOOKUP Example: Vlookup with a Drop Down List What does it do? Searches for a value in the first column of a table array and returns a value in the same row from another column (to the right) in the table array. Formula breakdown: =VLOOKUP(lookup_value, table_array, col_index_num, ) What it means: =VLOOKUP(thi...