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:
- Microsoft ExcelQuick Start: How to Make a Basic Formula in ExcelAndrew Childress
- Microsoft ExcelHow to Start Using COUNTIF, SUMIF, and AVERAGEIF in ExcelAndrew Childress
- Microsoft ExcelHow to Insert, Delete & Hide New Sheets in Excel in 60 SecondsAndrew Childress
Remember: Every Microsoft Excel tool you learn, and workflow you master, the more powerful spreadsheets you'll make.
Subscribe below and we’ll send you a weekly email summary of all new Business tutorials. Never miss out on learning about the next big thing.Update me weekly
Envato Tuts+ tutorials are translated into other languages by our community members—you can be involved too!Translate this post