RSS

How do I print row numbers and heading letters in Excel 2007, 2010 and 2013?

17 Mar

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:

print headings

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:

sheet options

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.:

sheet options print headings

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!

Related posts on this blog

How do I print the Excel header row on every page of my spreadsheet printout?

How do I print the Word header row on every page of my table printout?

 
3 Comments

Posted by on March 17, 2016 in Excel

 

Tags: , , ,

3 responses to “How do I print row numbers and heading letters in Excel 2007, 2010 and 2013?

I love hearing from my readers - do please leave a comment!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: