When you print a spreadsheet in Excel without changing any settings, the data will just kind of be floating on the page. This can be fine for some spreadsheets, but in other situations it can make the data very difficult to comprehend.
One way to do this is to print gridlines with your spreadsheet. The gridlines are the horizontal and vertical lines that separate your cells from one another. This is different from borders, which are added to the spreadsheet as a formatting option. Our guide below will show you how to print the gridlines in Excel.
How to Print Gridlines in Excel
The steps in this article were performed in the Excel for Office 365 version of the program, but will work in most other versions of the application as well.
Step 1: Open the spreadsheet in Excel.
Step 2: Select the Page Layout tab at the top of the window.
Step 3: Check the box to the left of Print under Gridlines in the Sheet Options section of the ribbon.
You can also print gridlines in Excel by clicking the Page Setup button on that Page Layout tab.
Then choosing the Sheet option at the top of the window.
The checking the box to the left of Gridlines and clicking the OK button at the bottom of the window.
Do you dislike the font that is used when you create a new spreadsheet? Find out how to change the default font in Excel and use one of the other fonts that is installed on your computer.
Matthew Burleigh has been a freelance writer since the early 2000s. You can find his writing all over the Web, where his content has collectively been read millions of times.
Matthew received his Master’s degree in Computer Science, then spent over a decade as an IT consultant for small businesses before focusing on writing and website creation.
The topics he covers for MasterYourTech.com include iPhones, Microsoft Office, and Google Apps.
You can read his full bio here.