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:

DOWNLOAD WORKBOOK

Highlight all Formula Cells

HELPFUL RESOURCE:

mrexcelXL

 

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Show The Percent of Parent Total With Excel Pivot ...  Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF PARENT TOTAL calculation.In the example below I show you how to get the Percent of a Product Total i.e The % Sales of each Product ...
Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list.A dynamic drop down list expands as the Excel Table expands when new data gets added to it.This is great when you want to have users select from a predefined ...
Find & Replace The Find & Replace feature or CTRL+H shortcut allows you to amend your data in seconds.  Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.  A simple CTRL+H will save you heaps of time!  See how below.DOWNLOAD WORKBO...
INDEX-MATCH Maximum Sales The INDEX-MATCH formula cannot only look up values to the left and right of your data but its versatility means that it can also lookup the largest values within an array.Say that you had a list of Sales Reps in one array and their corresponding Sales Values in another array....