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 b....