Why Is Excel Still Printing Lines When I Have Already Turned Off Gridlines?


Excel spreadsheets can be difficult to read when you print them without any kind of lines to separate data in cells. On paper this can cause the data in the cells to appear to blend together, making it difficult to determine the physical separation of each cell.

But sometimes you will be printing a spreadsheet and the separation of the cells by lines is not necessary and, in fact, can be a problem. You have probably already learned how to hide the gridlines, but the lines may still be printing. This is typically due to borders that have been applied to the sheet, which are controlled separately from the gridlines. Our steps below will show you how to remove all of the lines from your Excel spreadsheet when you have already turned off the gridlines.

 

How to Remove Cell Borders in Excel 2013

The steps below were performed in Excel 2013, but are the same for Excel 2007, 2010, and 2016. You can also remove cell borders in Excel 2003, but the steps are a little different because there isn’t a ribbon.

Step 1: Open your spreadsheet in Excel 2013.

 

Step 2: Click the button at the top-left of the spreadsheet, above the row A heading and to the left of the column 1 heading.

select all of the cells in the spreadsheet

 

 

Step 3: Click the Home tab at the top of the window.

click the home tab

 

 

Step 4: Click the Border button in the Font section of the ribbon, then click the No Border option.

how to stop excel from printing lines when you have turned off gridlines

 

 

How to Unfreeze Panes in Excel 2013

if you have turned off gridlines and removed all of the cell borders, then you might be seeing lines on your printed spreadsheet because you have frozen some panes.

 

Step 1: Click the View tab at the top of the window.

click the view tab

 

 

Step 2: Click the Freeze Panes button, then click the Unfreeze Panes option.

how to unfreeze panes in excel 2013

 

 

After you have removed the lines from your spreadsheet, there might still be some other formatting changes that you need to make for your spreadsheet to print properly. Read this guide to see how you can make your spreadsheet fit on one page without manually changing the widths of your columns, or the heights of your rows.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.