Monday April 18, 2011 at 2:40pm
When you are dealing with a spreadsheet that you didn’t create yourself, it can be useful to locate the cells that hold formulas, particularly if you are checking for errors. Normally, you only see the formula contained in a cell when you select that cell: it appears in the Formula Bar.
On Excel 2007 and 2010, to show all the formulas, you can select the Formulas tab and click onto the Show Formulas button, which is in the Formula Auditing group. On Excel 2003, select Tools from the menu bar, followed by Formula Auditing, then Formula Auditing Mode. There is a shortcut on all versions: Hold down the CONTROL button and click onto the ` (grave accent) button, which is just below the Esc button.
If you simply wish to highlight all the cells that contain formulas, press the [F5] button (Go to), click onto the Special button and then select Formulas. This will select all the cells containing formulas, on your worksheet.