How to Print Gridlines in Excel: A Step by Step Guide

Hey there, fellow spreadsheet enthusiasts! Have you ever tried printing your Excel sheet only to realize that the gridlines don't show up? Don't worry, you're not alone!

Excel is a powerful tool for organizing and analyzing data, but sometimes it can be a bit tricky to figure out all of the settings. In this article, I'll show you exactly how to print gridlines in Excel, step by step.

Step 1: Select the Cells You Want to Print

First things first, let's make sure you have the right cells selected. Highlight the cells you want to include in your printed sheet. You can click and drag your mouse to select multiple cells, or you can click on individual cells while holding down the "Ctrl" button on your keyboard.

Step 2: Open the Page Setup Menu

Next up, you'll want to open the page setup menu. You can do this by clicking on the "Page Layout" tab at the top of your Excel screen, and then selecting "Page Setup" in the bottom-right corner of the "Page Setup" group.

Step 3: Click on the "Sheet" Tab

Once the "Page Setup" menu is open, click on the "Sheet" tab. This is where we'll be able to adjust the settings for printing gridlines.

Step 4: Check the "Print" Checkbox Under "Gridlines"

On the "Sheet" tab of the "Page Setup" menu, you'll see a section labeled "Print." In this section, you'll see a checkbox labeled "Gridlines." Make sure this box is checked to ensure that your gridlines will show up when you print your sheet.

Step 5: Preview Your Printed Sheet

Before you print your sheet, it's always a good idea to preview it so you can ensure that everything looks the way you want it to. To do this, go back to the "Page Layout" tab and click on the "Print Preview" button.

In print preview, you'll be able to see exactly what your printed sheet will look like, gridlines and all. If you're happy with the way it looks, go ahead and hit the "Print" button. If not, you can always go back to the "Page Setup" menu and make any necessary adjustments.

Bonus Tip: Change the Color of Your Gridlines

If you're feeling a bit adventurous, you can even change the color of your gridlines. To do this, go back to the "Sheet" tab in the "Page Setup" menu and look for the "Print Quality" section. You'll see a drop-down menu labeled "Gridline Color." Here, you can select any color you want for your gridlines.

Just remember, the more colorful your sheet is, the more ink it will take to print. So, use this tip sparingly if you're trying to save on printer ink!


And there you have it, folks! A simple and straightforward guide to printing gridlines in Excel. With these steps, you'll never have to wonder why your gridlines aren't showing up again. Happy spreadsheeting!

If there are any other Excel tips or tricks you'd like me to cover, let me know in the comments below!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.