As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

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

If you've ever printed an Excel spreadsheet only to find that the gridlines are missing, you know how frustrating it can be. Gridlines help make your data more readable and presentable, so it's important to know how to print them. This guide will show you how to print gridlines in Excel in just a few easy steps.

Step 1: Open Your Excel Spreadsheet

The first step is to open your Excel spreadsheet. If you don't have one already created, you can create a new one.

Step 2: Select the Page Layout Tab

Once your spreadsheet is open, locate the Page Layout tab at the top of the screen and click on it. This will open up various options for formatting your page.

Step 3: Click on the Print Titles Button

In the Page Layout tab, you'll see several buttons. One of these is the Print Titles button, allowing you to control what is printed on each page of your spreadsheet. Click on this button to open the Print Titles dialog box.

Step 4: Check the Box next to "Gridlines"

In the Print Titles dialog box, you'll see different options. One of them is the option to print gridlines. Check the box next to this option. You'll see a preview of your spreadsheet updating to show that gridlines will now be printed.

Step 5: Click OK

Once you've selected the Gridlines option, click OK to close the Print Titles dialog box. Your gridlines should now be visible in the preview of your spreadsheet.

Step 6: Print Your Spreadsheet

The final step is to print your spreadsheet. Click on the File tab and select Print. This will open the Print dialog box. From here, you can select your printer and choose other options, such as the number of copies you want to print.

Step 7: Enjoy Your Printout!

That's it! You've now learned how to print gridlines in Excel. This can be a useful skill when you want to make your data more readable or presentable. Give it a try the next time you need to print an Excel spreadsheet.