How to Stop Printing Gridlines in Excel 2010

A worksheet that you print in Microsoft Excel 2010 will not include gridlines by default. However, many people adjust the settings of their worksheets to include printed gridlines because it can make them much easier to read.

But not every spreadsheet needs gridlines and, depending upon your preferences when using Excel 2010, you may wish to remove them for a spreadsheet that you are printing. Fortunately this is a setting that you can adjust by following just a few simple steps.


Print a Spreadsheet Without Gridlines in Excel 2010

The steps in this article will assume that your worksheet is currently set to print with gridlines, and that you wish to print the worksheet without them.

Note that the changes that you apply below will only affect the current worksheet in your workbook. Other worksheets in this workbook will not be affected, as this setting is applied at the worksheet level.


Step 1: Open your spreadsheet in Microsoft Excel 2010.


Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab



Step 3: Uncheck the box to the left of Print under Gridlines in the Sheet Options section of the Office ribbon.

uncheck the print box under gridlines



You can then go to the Print Preview, where you should see that your spreadsheet is set to print without gridlines.

print preview without gridlines



If you still see lines on your spreadsheet after making this change, then you may actually have borders applied to your spreadsheet, as opposed to gridlines. To remove the borders, click the button at the top-left corner of the spreadsheet to select all of your cells,

select all the cells



Then click the Home tab at the top of the window.

click the home tab



Click the arrow to the right of the Borders icon, then click the No Border option.

select the no borders option



Are you looking for some helpful ways to make your spreadsheet look better when you print it? Our guide to Excel printing can show you a few tricks that will make your printed worksheets look better, as well as make them easier to read.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides