Tip 258 – Quickly highlight all formulas in a sheet

If you are sent an Excel sheet and you wish to know which numbers have been typed in and which numbers are calculated by a formula, press the CTRL and G keys together to open the “Go To” dialogue box, click the Special button, select Formulas and then click OK. All cells containing a formula will be selected ready for you to apply a fill or font colour to differentiate them from the rest of the cells.