Gridlines are the light-colored borders surrounding every Excel cell.
Basically, these lines create edges that help you read the data.
Imagine an excel sheet without borderline.
The data will be overwritten and hard to read.
Thats clearly not what you want.
By default, Excel doesnt show the gridline when you print the worksheet.
But with a few tricks, you might unlock the gridline on your Excel sheet while printing.
In this article, Ill show you three different manuals to print from Excel with gridlines.
So, bare with me till the end.
Quickest Ways
Lets take a look at an excel sheet when printed without cell borders.
As you could notice, the data is quite challenging to read.
Now, imagine a worksheet with thousands of rows printed without the grid line.
Youll barely apart the rows and columns.
Here are the methods to print from Excel with gridlines:
1. check that you dont tick on the Headings option.
Thats it; that will help you print an excel sheet with lines on the page.
This technique will indeed work for Excel 2013 and above.
Try the following method if this doesnt work.
Read more on how toExcel Round Up Numbers
2.
So, you could consider this method a fail-safe way to include gridlines in your worksheet.
If the dataset is comparatively smaller, try the first method (which is the quickest).
And when you need some additional changes, including print gridlines, use the page setup method.
Heres a complete guide on how toCopy Values Without Formulas on Excel
3.
Use Print Preview mode to Print Gridlines in Excel.
This is the end-moment solution you need.
Just so you remember, PressCtrl + Pto get to the print preview mode.
Here are the steps to use print preview to add gridlines in excel:
Thats it.
it’s possible for you to go ahead and print the Excel sheet that was missing gridlines.
When you manually add a cell border in a spreadsheet, it shows up after printing.
Using Microsoft Excel in macOS and trying to do the same?
No worries, read the following section.
And this time, youll notice cell borders on printed documents.
When the draft quality feature of Excel causes you low-quality printing copy, youll notice this issue.
you might turn off draft quality to avoid this issue.
After following these steps, youll resolve Excel grid lines not showing on Excel printed copies.
If you have any further queries, check out the following section.
Go to the page layout tab on Excel > tap on sheet options > Check Print underneath gridline.
How do I get the gridlines to print in Excel?
Select data range > Move to View tab > Show group > Tick on the Gridlines check box.
I know youll be able to see the gridlines after following these methods.
A team of Excel experts will be delighted to assist you.
