In Excel: go to Page Layout and tick Print under Gridlines, then use Print Preview to confirm the sheet prints with cell lines.
On this page7
Open the Page Layout tab.
In Sheet Options, under Gridlines, tick Print.
Open Print Preview.
Use Borders instead when only selected areas should show lines.
What this does
Gridlines are the light cell boundaries visible on screen. They do not print by default. Page Layout ▸ Gridlines ▸ Print tells Excel to include them on paper or PDF; borders are different because they are explicit formatting that always prints when applied. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “print excel sheet with lines”. Start on a copy or a tiny sample, keep the affected sheet visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workspace setting that makes a big sheet comfortable to navigate, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
A checklist prints as plain text with no cell boundaries. Tick Page Layout ▸ Gridlines ▸ Print, open Print Preview, and the row and column grid appears around each cell without adding manual borders. Printed gridlines make working sheets, checklists and review copies readable without manually formatting every cell. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “print excel sheet with lines” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
Common mistakes
- Turning on View gridlines and expecting them to print.
- Using gridlines when a report needs heavier custom borders.
- Forgetting that gridlines may be faint on some printers.
- Printing without previewing page scaling.
Frequently asked questions
Why do Excel gridlines not print?
The Print gridlines option is off by default.
Are gridlines the same as borders?
No. Borders are formatting; gridlines are sheet display lines.
Can I print only some lines?
Use cell borders for selected areas.
Other ways people ask this
On the way here you may have searched this as “how to print an excel sheet with the lines”, “how do you print an excel sheet with lines”, “how to print the excel sheet with lines” and “print excel sheet with lines” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to print an excel sheet with the lines”, “how do you print an excel sheet with lines”, “how to print the excel sheet with lines” all point at the one operation explained on this page, which is why they all lead here.