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. If only some of the data in your Excel file is printing, then a print area could be to blame.
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.
Step 3: Click the Home tab at the top of the window.
Step 4: Click the Border button in the Font section of the ribbon, then click the No Border option.
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.
Step 2: Click the Freeze Panes button, then click the Unfreeze Panes option.
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.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.