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

Now that you know how to stop printing gridlines in Excel 2010, you can create spreadsheets that don’t include those vertical and horizontal lines when you create physical copies of them.

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