How to Print Gridlines in Excel: 4 Steps
If you’re new to Excel, you may not know all the features it has to offer. One of them is printing the worksheet as it looks on the screen, with or without gridlines. How to print gridlines in Excel? It’s easy! Just follow these steps.
- Open your Excel workbook and go to the worksheet you want to print.
- Go to the “Page Layout” tab and locate the “Sheet Options” group.
- Under “Gridlines,” check the box next to “Print.”
- Click “File” > “Print” or press the Ctrl+P keys on your keyboard. You can now print your worksheet with gridlines.
This will ensure that the gridlines around your data will be printed. You can preview what it will look like in the “File” tab (press Ctrl+F2 to quickly open it). However, if you’re still having trouble printing gridlines in Excel, there are a few other things you can try.
Gridlines Won’t Print? Check Your Page Setup
Now you know how to print gridlines in Excel. If you’re having issues, the first thing you should check is the “Page Setup” dialog box. You can open it manually or press Alt+P, S, P. Then, go to the “Sheet” tab and check whether the box next to “Draft quality” is checked. If it is, uncheck it and try printing your worksheet again.
Additionally, make sure you check the “Print area” to see if it’s set correctly. You can find this option in the “Page Layout” tab, under “Page Setup.” If it isn’t set correctly, your gridlines may not print. If you want empty cells and their gridlines to be printed, you’ll also need to set the print area to include them.
Finally, if you’re still having trouble printing gridlines in your Excel worksheet, try downloading the latest printer driver from the manufacturer’s website. This should solve any compatibility issues you may be having. Sometimes, older versions of Excel have trouble printing gridlines with certain printers.
Apply Borders Around the Cells as a Workaround
What if you’re following our instructions on how to print gridlines in Excel to the letter and they still won’t appear? In that case, you can try applying borders around the cells as a workaround.
To do this, select the cells you want to print and go to the “Home” tab. In the “Font” group, click the small arrow next to the “Borders” button and select the type of border you want to use. You can also go to “More Borders” and click the “Inside” button under “Presets” to apply an inside border. This is handy if you want to print the same border on cells separated by a page break.
Enjoy Your Freshly Printed Worksheets With Grid Lines
Now that you know how to print gridlines in Excel, go forth and enjoy your freshly printed worksheets! Just remember to check the “Page Setup” dialog box first if you’re having trouble. And if all else fails, try applying borders around the cells you want to print. With these tips, you’ll be printing gridlines like a pro in no time.
We hope this article has helped you learn how to print gridlines in Excel. If you have any other tips or tricks, feel free to share them in the comments below. Let’s learn from each other and make our lives a little easier, one Excel tip at a time!