1. Home
  2. MS Office

Excel 2010: Change, Remove, Print Gridlines

Excel provides option of changing the worksheet gridlines. You can change the color of gridlines, make them apparent on hard-copy, and even remove gridlines. Follow the simple procedure to change different settings of gridlines in Excel 2010,

Print Gridlines:

If you want to see gridlines on hard-copy, before printing the worksheet, navigate to Page Layout, under Gridlines and enable Print option. For advance printing options, click the button being present at the bottom-right of the Sheet Options group.

print gridlines 1

Upon click, Page Setup dialog will appear, which lets you to configure print settings.

page setup

Color & Remove Gridlines

For changing gridlines color, go to File menu and click Options.

options 1

Excel Options dialog will appear, select Advanced from left pane, and from the right pane scroll-down to find Display Options for this worksheet: group, choose desired Gridline color. In case you want to make Gridlines disappear, disable Show gridlines option.

options 3232

You will see the color of Gridlines will change, as shown in the screen shot below.

color change

Here you can see the Excel worksheet without gridlines.

no grid

You can also check out previously reviewed guides on Icon Sets in Excel 2010 & Using SUMIF function in Excel 2010

7 Comments

  1. My problem is that I copied cells in from another worksheet and it wiped out just those gridlines. Now as I work in the new sheet it progressively wipes out my grid lines as I copy, move, control down, etc.

  2. Have a brand new Toshiba Satellite with an I7 processor running Office 2010 – I can’t enable the colors in Exceel – any Idea?

  3. You’re the freakin’ legend! Changing the colour shows the damn gridlines. Microsoft’s wisdom put the gridlines to black, and this shows nothing on the worksheet??? Go figure??????
    We ought to be paid >$100k p.a. for our real world end user skills!

Leave a Reply

Your email address will not be published. Required fields are marked *

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