Print Gridlines in Excel

Add to Favorites
Author:

I'll teach you how to show gridlines for Excel when you print your files.

This is a neat little feature that will allow you to have a printed version of your Excel file that looks more like what you will see on your computer without having to manually create borders.

Here is our sample worksheet:

When we go to print preview it will look like this:

You can see on the right side of the image that there are no gridlines or borders of any sort.

Steps to Print Gridlines in Excel

  1. Go to the Page Layout tab and check the option Print inside the Sheet Options box on the right of the Ribbon menu:
  2. Hit Ctrl + P to print the document as usual, but this time the gridlines will appear.

Final result as viewed in the print preview:

And here is a screenshot of the full page:

This is a simple thing to do and, depending on your data set, it can help with the readability of the document.

Note that the gridlines only appear where you have data; Excel won't print an entire page in grid format by default if there is not data to show with it.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Remove Gridlines in Excel 2007 and Later
Tutorial: In Excel 2007 and later you can quickly remove the gridlines that appear within the Excel ...
Display the Print Window in Excel
Macro: This free Excel macro displays the print window or dialog box in Excel. This is the s...
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Print Different Headers for Odd and Even Pages in Excel
Tutorial: How to print pages in Excel with different headers for odd and even pages. Steps Go to the...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course