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?

 
6 Comments

Posted by on March 17, 2016 in Excel

 

Tags: , , ,

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

  1. Brian Ross

    February 28, 2018 at 5:33 pm

    I stumbled onto your help for printing Excel sheet numbers and column letters. What a relief to find such a clear, well displayed presention. I will be making this site my first choice in future. Thank you. BR.

    Like

     
    • Liz Dexter

      February 28, 2018 at 5:37 pm

      You’re most welcome, and thank you for your comment. Do let me know if there’s a topic I haven’t covered that you’d like to see explained in the future!

      Like

       

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

 
%d bloggers like this: