Printing a Formula Display in Excel

Having a printout of the formulas is helpful, especially if you’ve created the worksheet, but you don’t work with it. It’s a great reference for you, and it can help with debugging.

Create the formula display by pressing Ctrl key and the accent mark key (`), which is the key left of the number one key. Formulas are displayed in the cells rather than the values.

Before printing the “formula display” of the worksheet, add the row and column headings and gridlines:

On the Page Layout tab, select the Print check boxes to the Gridlines and Headings buttons.