How to Hide Gridlines in Excel 2013

Gridlines in Excel 2013 offer an effective way to visually separate your data into distinct cells. These gridlines can appear on the screen when you are editing your spreadsheet, and they can appear on the page when you print.

But you may encounter situations where you do not want the gridlines to be shown or printed in Excel 2013, which can leave you looking for the setting that controls them. Our guide below will show you how to find the menu option that will toggle off the viewing and printing of gridlines in Excel.

 

How to Remove Gridlines in an Excel 2013 Spreadsheet

There are two different places where you can elect to show or hide the gridlines in an Excel worksheet. Gridlines can be displayed on the screen when you are editing your spreadsheet on your computer, and they can be printed when you print your spreadsheet on paper. We will show you how to hide gridlines from both of these locations in the steps below, as they are located close to one another.

Step 1: Open your workbook in Excel 2013.

 

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

how gridlines from an excel worksheet

 

 

Step 3: Locate the Gridlines section in the Sheet Options section of the ribbon. Click the box to the left of View and the box to the left of Print to remove the check marks. Gridlines are hidden both on the screen and on the printed page with the settings below.

how to hide gridlines on screen and when printing in excel 2013

 

 

Now the spreadsheet on your screen should be devoid of lines, and a printed copy of the spreadsheet will not include the lines either.

 

While the ability to show or hide gridlines is one of the most common changes to make when printing in Excel, another issue occurs when you have additional pages that print one or two errant columns. While you may have previously tried to resize your columns manually, Excel 2013 has options that allow you to fit the spreadsheet to one page. This can save a lot of time and headache, while also making it easier for your readers to view your data.

solveyourtech.com newsletter
vintage t rex t-shirt

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