How to Print Gridlines in Excel 2013


Last updated: January 6, 2017

Learning how to print gridlines in Excel 2013 is a necessity for anyone that often needs to print large spreadsheets. Information in cells can be difficult to read without them, and can lead to mistakes.

Data on your screen in Microsoft Excel 2013 is organized efficiently into cells that are separated by gridlines. But when you go to print that spreadsheet, the default setting will not include these gridlines. This results in a sheet with a bunch of data that may seem to run together, or it might be difficult to tell which cell belongs in which row or column.

The simplest way to make this document easier to read is by configuring the spreadsheet so that the gridlines are printed. Luckily this is a simple adjustment to make, and the people reading your printed spreadsheets will have an easier time reading them.

 

How to Add Gridlines in Excel 2013

This is typically one of the first settings I adjust when I am working on a new spreadsheet that I know I will need to print. That way I don’t accidentally print a large spreadsheet without the lines, which can be a waste of paper and time.

 

Step 1: Open your spreadsheet in Excel 2013.

 

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

click the page layout tab

 

 

Step 3: Check the box to the left of Print under Gridlines in the Sheet Options section of the ribbon at the top of the window.

how to print gridlines in excel 2013

 

 

Now if you press Ctrl + P on your keyboard to open the Print menu, you will see that the gridlines are showing on the spreadsheet in the Print Preview section at the right side of the window.

 

Summary – How to print with gridlines in Excel

  1. Click the Page Layout tab.
  2. Check the box to the left of Print under Gridlines.

 

There is another place where you can elect to print gridlines as well.

 

Alternate method for printing gridlines in Excel

The steps below are longer than the previous method, but will open a Page Setup window where you can center your spreadsheet horizontally or vertically, print the top row on every page, or create and edit a header.

Step 1: Click the Page Layout tab.

click the page layout tab

 

 

Step 2: Click the Page Setup dialog launcher at the bottom-right corner of the Page Setup section in the ribbon.

open the Page Setup menu

 

 

Step 3: Click the Sheet tab at the top of the Page Setup window.

click the Sheet tab

 

 

Step 4: Check the box to the left of Gridlines in the Print section of the window. You can click the OK button at the bottom of the window when you are done.

how to print gridlines in Excel 2013

 

 

If you have enabled the gridlines to print on your spreadsheet, but you don’t see them, then there may be a fill color applied to those cells. Learn how to remove cell fill color in Excel 2013, then see if your gridlines are printing.

If you are printing a multi-page spreadsheet, it is very helpful when you print your column headings on every page, too. Read this article to learn how.

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