• Skip to main content

Master Your Tech

Mobile phones, software, consumer electronic how-to guides

  • iPhone
  • Excel
  • Powerpoint
  • Word
  • Google Drive
You are here: Home / Excel / How to Print With Gridlines in Excel for Office 365

How to Print With Gridlines in Excel for Office 365

posted on March 26, 2019

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.

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.

how to print gridlines in excel

You can also print gridlines in Excel by clicking the Page Setup button on that Page Layout tab.

open the excel page setup menu

Then choosing the Sheet option at the top of the window.

click the sheet tab

The checking the box to the left of Gridlines and clicking the OK button at the bottom of the window.

print gridlines on spreadsheet in excel

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
Matthew Burleigh

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.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Filed Under: Excel

Search

  • Contact Us
  • Privacy Policy
  • Terms and Conditions

Copyright © 2023 MasterYourTech.com