• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Print Gridlines in Excel

April 8, 2021 by Andrew Childress
Gridlines in print Excel

The borders around each cell in a spreadsheet are called gridlines. But they won’t appear automatically when you print the file. Let’s learn how to print gridlines in Microsoft Excel.

How to Print Gridlines in Excel

In Excel, it’s possible to show or hide gridlines as you edit your file. But this decision doesn’t directly impact the appearance of your printed spreadsheets. If you want to print gridlines so they’re visible on paper, you’ll have to make an additional adjustment.

Let’s say you have a file that you want to print, and you need gridlines on paper. This is a good option, because it makes your data easier to read. It gives rows and columns a table format that looks great.

Above the ribbon, click on the File dropdown in Excel. You’ll see a long list of options, including several involving printing. The options you need are under Page Setup. 

Print gridlines Excel

Click there, and the Page Setup menu will appear. Across the top, you’ll see four additional menu options: Page, Margins, Header/Footer, and Sheet. The option you need is under Sheet, so go ahead and click that option.

How to print gridlines Excel

Now, you’ll see new lists of options. The important one here lies under the Print Options section. It’s the Gridlines checkbox, which defaults to unchecked. If you do want to print gridlines, click on the box to select it. Finally, press OK.

Print Excel gridlines

You can verify your choice by navigating to the main Print menu (also on the File dropdown) and looking in the print preview window. As you can see in this example, the small page preview has gridlines included. This really helps make printed data more readable and easy to analyze.

Gridlines in print Excel

As you can see, it’s easy to print gridlines in Microsoft Excel. It just takes a few simple clicks, and in no time you’ll be printing concise, clear, and readable spreadsheets to share.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Now function Excel Now Function in Excel
Next Post: Footer in Excel Footer Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top