How to print formulas in excel

To print formulas in Excel, you must first display the formulas in the worksheet rather than the calculated results. Excel provides a straightforward method to toggle between showing values and showing formulas.

Steps to Display Formulas in Excel

1. Select the worksheet that contains the formulas you want to print.

2. Press Ctrl + ** (the grave accent key, usually located above the Tab key) on Windows. On a Mac, press **Command +.

3. All formulas in the worksheet will appear in their respective cells instead of the calculated results.

Steps to Print the Worksheet with Formulas

1. With the formulas visible, go to the File menu.

2. Click Print.

3. In the print preview, confirm that the formulas are displayed in the cells.

4. Adjust page layout settings such as orientation, scaling, and margins to ensure all formulas fit on the printed page.

5. Click Print to produce a hard copy of the worksheet with formulas.

Alternative Method: Using Excel Options

1. Go to File > Options > Advanced.

2. Scroll to the Display options for this worksheet section.

3. Check the box Show formulas in cells instead of their calculated results.

4. Click OK.

5. Proceed to print the worksheet as described above.

Tips for Printing Formulas Clearly

• Use landscape orientation if formulas are long to prevent them from being cut off.

• Increase row height or column width to ensure the full formula is visible in the printed page.

• Highlight formulas using cell borders or shading to make them stand out in printouts.

This method ensures that all formulas, not just their results, are visible on the printed sheet.