Join us for National Proofreading Day

Join us on Facebook or Twitter to learn proofreading tips, to trade your horror stories, and to share how you saved the day by finding an error.

Tuesday, March 8, 2011

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.

No comments:

Post a Comment