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

Advertisement
  • Pingback: Insert Comments In Excel 2010

  • eiger3970

    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!

  • Stephen Hart

    Thank you! The blasted page lines showed up when I pressed the wrong button and I couldn’t work out how to get rid of them!

    Regards

    Stephen
    http://www.edenchanges.com

  • ROBERT ICE

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

  • Jordanfolk

    Try changing the background color, It may be set to white.  Try setting the background color to “No Color”

  • http://twitter.com/ErUpNorth ErUpNorth

    If anyone looses their gridlines and cannot get them back try adjusting your monitor, that worked for me

  • DaveB

    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.