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.
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.
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.
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.
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:
- Quick Start: How to Make a Basic Formula in ExcelAndrew Childress07 Mar 2017
- How to Start Using COUNTIF, SUMIF, and AVERAGEIF in ExcelAndrew Childress31 Jan 2017
- How to Insert, Delete & Hide New Sheets in Excel in 60 SecondsAndrew Childress25 Apr 2017
Remember: Every Microsoft Excel tool you learn, and workflow you master, the more powerful spreadsheets you'll make.