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.
Upon click, Page Setup dialog will appear, which lets you to configure print settings.
Color & Remove Gridlines
For changing gridlines color, go to File menu and click Options.
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.
You will see the color of Gridlines will change, as shown in the screen shot below.
Here you can see the Excel worksheet without gridlines.
You can also check out previously reviewed guides on Icon Sets in Excel 2010 & Using SUMIF function in Excel 2010
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.
If anyone looses their gridlines and cannot get them back try adjusting your monitor, that worked for me
Try changing the background color, It may be set to white. Try setting the background color to “No Color”
Have a brand new Toshiba Satellite with an I7 processor running Office 2010 – I can’t enable the colors in Exceel – any Idea?
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
www.edenchanges.com
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!