If you want to print your Excel spreadsheets with gridlines, this guide is for you. Adding gridlines makes your data easier to read and gives your spreadsheet a clean, organized look. In this post, we’ll walk you through the steps to print gridlines in Excel and share some tips for the best results. Whether you’re new to Excel or a seasoned user, this guide will help you achieve a professional finish for your printed documents.

Understanding Gridlines in Excel

 

Before learning how to print gridlines, it’s important to know what they are. Gridlines are the light lines around cells in Excel that separate rows and columns. They make it easier to read and understand data, whether on your screen or on paper. By default, Excel doesn’t print gridlines, but you can easily turn them on and even adjust how they look.

Lets learn “How to Print Gridlines in Excel.“

 

Method 1:- Print Gridlines in excel with Page Layout Tab

A simple way to do this is by using the Page Layout tab, which you can find on the ribbon as:

  • Go to the Page Layout tab.
  • Find the Sheet Options group.
  • Check the Print box under Gridlines.
14.1 print gridlines
  • To print your sheet, press CTRL + P (or Cmd + P on a Mac), or go to File -> Print. This will open Print Preview mode.
  • Once you click Print, the gridlines will appear on the printed sheet and the preview mode.
  • You’ll see a preview of your page on the right. If it looks good, click the big Print button on the left to start printing.
How to Print Gridlines in Excel - 3 Easy and Quickiest Way
Note: This setting only applies to the active sheet. You’ll need to adjust it for each sheet where you want to include gridlines when printing.
This is one way to add gridlines to your printouts. Now, let’s explore other methods.

Method 2:- Print Gridlines in Excel the Print Preview

Follow these steps to display gridlines in the Print Preview menu:

  • Go to the File tab on the ribbon.
How to Print Gridlines in Excel - 3 Easy and Quickiest Way
This will open Excel’s backstage area.
  1. Click on Print options.
  2. Then click the Page Setup link at the bottom of the main print settings.
  3. This will open the Page Setup menu.
    • Go to the Sheets tab.
    • Check the Gridlines option.
    • Click OK
How to Print Gridlines in Excel - 3 Easy and Quickiest Way

This will take you back to Print Preview mode, where you can see how the page looks with the gridlines added.

14.7 print gridlines

To go back to your worksheet, click the back arrow at the top left. If you want to print, click the Print button at the top. This is a good choice since you’ll likely want to check the Print Preview before printing. Page Setup is easy to access and lets you adjust settings like enabling gridlines before printing.

Method 3:- Print Guidelines in Excel Using Page Setup Launcher Tool

Another easy way to print gridlines in excel is by using the Page Setup dialog box. To open it, click on the tiny arrow in the bottom-right corner of the Page Setup section on the ribbon menu. Here’s how:
  • Go to the Page Layout tab, find the Page Setup section, and click on the small arrow in the bottom-right corner to open the Page Setup dialog box.

  • In the dialog box, go to the Sheet tab and check the Gridlines box.

     
14.6 print guideline
  • To continue working on your worksheet, click OK. The gridlines are now ready for printing. If you want to print right away, click the Print button. To review everything before printing, click the Print Preview button.
14.7 print guidelines

Download Practice File

You can also practice this through our practice files. Click on the below link to download the practice file.
Download Practice File

Conclusion:-

In this tutorial, we showed you three ways to print gridlines in Excel.

We hope these tips help make your printed pages easier to read and look better.

Other Excel tutorials you may like:

Few Simple Excel Tips – Excel Learner Should Know
CONDITIONAL FORMATTING In Excel
Create Pareto Chart In Excel

 

Similar Posts

Excel Hyperlink: how to create, change and remove
| | |

Excel Hyperlink: how to create, change and remove

BySumit Shrimal

This tutorial shows you three easy ways to add hyperlinks in Excel. You will learn how to insert, change, and remove hyperlinks in your worksheets. It also explains how to fix links that don’t work.
Hyperlinks are often used on the internet to move between websites. In Excel, you can create links like that too. You can make a link to another cell, a different sheet, or even another workbook. You can also link to open a new Excel file or start an email message. This guide will show you how to do all of this in Excel 2016, 2013, 2010, and older versions.

Leave a Reply

Your email address will not be published. Required fields are marked *