Microsoft Excel is a popular spreadsheet program, and it allows the entry of data or formulas into each cell. A formula in a cell may refer to a previously calculated cell, which allows great flexibility in developing spreadsheets.
When debugging a spreadsheet, you may wish to view these formulas rather than the data in each cell. While you can always view the formula in the editing window of an active cell, Excel provides the ability to view and print all cells at once.
Open the spreadsheet you are interested in, and follow these steps:
Click on the round Windows icon at the top left corner of the Excel window.
A new window will pop up. Click the "Excel Options" button, which is located along the bottom and center of this window.
The "Excel Options" window will display. Select the "Advanced" option from the column along the left side of the new window.
Scroll down to the "Display Options for This Worksheet" header. It is located a little more than halfway to the bottom.
Click on the box labeled "Show formulas in cells instead of their calculated values."
- Click the "OK" button.
Alternatively, press the "ALT", "M" and "H" keys. This will toggle the display between data and formulas.
You can temporarily view the formula contents of a cell by pressing the "ALT" and single quote key.
Format the cells as needed to display properly. You may need to widen the columns and change the fonts to display long formulas. If you do not wish to change the formatting of the worksheet, create a duplicate worksheet and reformat it for printing.
Issue a print command. The formula will print as if they were normal cell data.
- "Excel 2007 for Dummies;: Greg Harvey; 2007
- Photo Credit Jupiterimages/Brand X Pictures/Getty Images