This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Debug Using a Printed Spreadsheet
Problem: I need to proofread cells in my spreadsheet. It would be easier to do this from a printed piece of paper, but I need to see the row numbers and column letters in the printout.
Strategy: You can print row numbers and column letters. On the Page Layout ribbon tab, you choose Print under both Gridlines and Headers.
Figure 1238 Choose to print gridlines and headers.
Results: The printed copy of the spreadsheet will show column letters across the top and row numbers down the side.
Figure 1239 You can identify cell addresses in the printout.
<-Previous Topic Next Topic->
For more resources for Microsoft Excel: