How Can I Print My Formulas in Excel?


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.

Related Searches


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


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.

Related Searches

Check It Out

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

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