Microsoft Excel: Debug From A Printed Spreadsheet

Problem: You need to proofread cells in your spreadsheet. It would be easier to do this from a printed piece of paper but, at the same time, you need to see the row numbers and column letters in the printout.

Strategy: You can print row numbers and column letters. From the File menu, select File – Page Setup – Sheet – (Print) Row and Column Headings, as shown in Fig. 1281.

Result: As shown in Fig. 1282, the printed copy of the spreadsheet will show letters A, B, C, and D across the top and row numbers down the side.

Summary: Debugging printed spreadsheets is easier if you temporarily turn on the printing of row and column headings.

Commands Discussed: File – Page Setup – Sheet – Row and Column Headings

See all Microsoft Excel tips

Images

Microsoft Excel: Debug From A Printed Spreadsheet

Share to Facebook