RSS

How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?

23 Mar

When you’re printing an Excel spreadsheet, how do you make the gridlines print, too?

This article tells you how to print the gridlines automatically, working in the Page Layout Tab, in Excel 2007, 2010 and 2013 (screen shots are taken from Excel 2010).

With your spreadsheet open, 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 gridlines appear when you print out the spreadsheet.

There are two things to note here:

  1.  You can also untick the View boxes so you can’t see the gridlines at all. I’m not sure why you might want to do this, but there it is.
  2. If you have used the borders option already to draw borders around some cells, if you print without ticking Print Gridlines, the borders you have added will print anyway; if you tick Print Gridlines, all of the gridlines and borders will print.

Adding customised borders to cells

A quick reminder on adding borders:

Click on the cell(s) you want to add borders to. Click on the Borders drop-down in the Home Tab, Font area:

apply borders excel

then choose where you want your borders to go:

border options excel

More sheet options

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 gridlines

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 row numbers and column letters in my Excel spreadsheet?

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 23, 2016 in Excel

 

Tags: , , ,

6 responses to “How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?

  1. Sarah

    March 23, 2016 at 5:18 pm

    Ooo, thanks for this! I shall be bookmarking this page (er, and all the other excel pages 😉 )

    Like

     
    • Liz Dexter

      March 23, 2016 at 5:19 pm

      So glad when people take a moment to let me know things have been helpful. Do drop me a line if there are other Excel things you’d like to see me write about!

      Like

       
  2. James King

    June 15, 2016 at 1:27 am

    Help! I cannot get Excel 2016 to print gridlines on a spreadsheet created on a Windows 7 laptop with Office 2003. My new laptop has Office 2016 and this has me pulling my hair out. I happened before and I kept messing with and finally fixed it, I thought, but now they’re gone again.

    Like

     
    • Liz Dexter

      June 15, 2016 at 8:56 am

      I’m afraid I’m not fully au fait with Office 2016 at the moment, especially compatability issues. I wonder if you set up a spreadsheet to print gridlines then paste your original one into that spreadsheet, if that’s not too difficult, that might work?

      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 )

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: