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.

pagesetup Excel 2010: Change, Remove, Print Gridlines

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

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

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