When you’re printing an Excel spreadsheet, how do you make the row numbers and heading letters print, too?
This article tells you how to do this, working in the Page Layout Tab, in Excel 2007, 2010 and 2013 (screen shots are taken from Excel 2010).
In your spreadsheet, go to the Page Layout tab and look to the right to find the Sheet Options area:
In this area, you can tick Print to make the headings (or, indeed, the gridlines) appear when you print out the spreadsheet. Note that if you want to, you can also untick the View boxes so you can’t see the headings. I’m not entirely sure why you wouldn’t want to see those, but the option is there.
You will see that there’s a little arrow in the bottom right corner of the Sheet Options area:
Click on this arrow and the Page Setup dialogue box opens – here you can change a few more options, too, or set your headings to print if you want to, as well as going into the other tabs to change the orientation or margins, etc.:
And that’s it – now you can print the row numbers and heading letters in Excel 2007, 2010 or 2013!
If this has been helpful, please comment below or share the article using the buttons. Thank you!