Change color, print, hide gridlines in Excel 2013 & Excel 2010

Excel 2013, 2010 users have the option to change the color of gridlines, print or hide gridlines.

Change gridlines color in Excel

User can change the gridlines colour using Excel Advanced options. This can be done by the following steps

Step 1: Click File menu and then Options link.

Step 2: In Excel Options window, navigate to Advanced Options

Step 3: In Advanced Options, scroll down Display options for this worksheet

Excel Gridlines Colour

Step 4: And to change the colour of excel 2010 gridlines, specify the colour using the Gridline Color drop down values.

Step 5: Click OK button to save and confirm the changes.

Hide gridlines in Excel

Gridlines in Microsoft Excel 2013 and Excel 2010 are lines between the rows and columns in a worksheet to make editing and reading faster. But in case if you have lot of text in Excel worksheet and you want to remove the Gridlines then you can use the feature available as part of View menu to hide these Gridlines.

Excel Gridlines

To hide Gridlines in Excel 2010 and Excel 2013,

From home menu, click the View menu option

In View menu, navigate to Show section and un tick the check box with label as Gridlines.

Hide Excel Gridlines

By this way one can hide the gridlines in Excel 2013 and Excel 2010.

Print with Gridlines in Excel

Let us say you have the following set of data that needs to be printed.


If you navigate to Print menu then by default the Print Preview will display these data with out the gridlines.


If you want to print the worksheet with gridlines in Excel 2010, then Click Page layout menu then navigate to Sheet Options. Now mark the check box with label as Print under Gridlines.


In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 1 Comment

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.