1. Business
  2. Microsoft Excel

How to Print With Gridlines in Excel in 60 Seconds

This post is part of a series called How to Use Excel - Quick Video Tutorials (in 60 Seconds).
How to Add Slicers to Pivot Tables in Excel in 60 Seconds

Excel spreadsheets are combinations of rows and columns and where they meet are called cells. This creates a big grid in Excel. When you print a spreadsheet you won't see this grid by default, but I'll show you how to change that setting in this quick video tutorial. 

How to Print With Gridlines in Excel (Quickly)

Note: Watch this short tutorial screencast or follow these quick steps that compliment this video:

1. Highlight What You Want to Print in Excel

In Excel, the first thing that I always do before I print is to highlight what I wanna include in the pages that I print.I'll just click and drag my mouse cursor over my selection. 

Select the Excel cells you want to print
Select the Excel cells you want to print.

2. Start Applying Your Preferred Excel Print Settings

Now, I'll go to the File > Print Menu. From the Settings dropdown, I'll go ahead and switch the dropdown to Print Selection, so that only the highlighted area prints. I might also make another adjustment here like changing this to Landscape Orientation.

Excel Print Screen settings
Basic Excel Print settings.

3. Apply Gridlines to Your Excel Print Settings

Now I'll go ahead and click on the Page Setup option. Let's click on the Sheet tab which contains several more settings. I'll tick the Gridlines box and then press OK

Check Gridlines to include them when printing from Excel
Check Gridlines to include them when printing from Excel.

4. Now Excel Will Print With Gridlines

Now you'll see the gridlines appear here in the Print Preview on the right side. And they'll be included when you send this to a printer or a PDF file for example.

Excel print preview with gridlines showing
Excel print preview with gridlines showing.

Finishing Up!

Printing gridlines often makes your print outs much easier to read and follow when reviewing your Excel data. And luckily, it's an easy setting to turn on. 

More Great Excel Tutorials on Envato Tuts+ 

Find comprehensive Excel tutorials on Envato Tuts+ to help you learn how to work with your data better in your spreadhsheets. We also have a quick-start in 60 seconds Excel video series to learn more Excel tools fast. Here are a few Excel tutorials to jump into to now: 

Remember: Every Microsoft Excel tool you learn, and workflow you master, the more powerful spreadsheets you'll make.

Looking for something to help kick start your next project?
Envato Market has a range of items for sale to help get you started.