How Can I Print My Formulas in Excel?

Save

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.

Display Formulas

  • Open the spreadsheet you are interested in, and follow these steps:

    1. Click on the round Windows icon at the top left corner of the Excel window.

    2. A new window will pop up. Click the "Excel Options" button, which is located along the bottom and center of this window.

    3. The "Excel Options" window will display. Select the "Advanced" option from the column along the left side of the new window.

    4. Scroll down to the "Display Options for This Worksheet" header. It is located a little more than halfway to the bottom.

    5. Click on the box labeled "Show formulas in cells instead of their calculated values."

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

Printing Formulas

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

References

  • "Excel 2007 for Dummies;: Greg Harvey; 2007
  • Photo Credit Jupiterimages/Brand X Pictures/Getty Images
Promoted By Zergnet

Comments

You May Also Like

  • How to Print From Excel

    Microsoft Office's program Excel comes bundled in Office Suite or as a stand-alone software product. It's a powerful spreadsheet program used mainly...

  • How to Show Formulas in Excel

    By showing formulas in Excel, you can quickly check for inaccuracies and make the changes needed. It can also help you find...

  • How to Use Text in Excel Formulas

    Users of Microsoft Excel can use formulas to perform calculations automatically. It is a useful feature that eliminates the need for users...

  • How to Use Macros in Excel Formulas

    Macros are Visual Basic scripts that allow you to store a common software task or formula. Macros make working with Microsoft Excel...

  • How to Use Excel 2010

    Excel 2010 is a type of spreadsheet software that is part of the Microsoft Office suite. Excel allows you to organize information,...

  • Using the Formula & Display Bar in Microsoft Excel

    How to use the formula and display bar in Microsoft Excel; learn more about spreadsheet software in this free instructional video.

  • How to Show Formulas in Excel

    Excel users can show formulas by clicking on a cell, which makes the formula appear in a text window. Learn how to...

  • How to Make a Formula in Excel

    In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!