Printing an Excel sheet looks simple until you click Print and watch the page come out with no lines around the cells. Suddenly the clean grid on the screen looks like a wall of floating numbers on paper, and you start hunting through menus trying to figure out what went wrong. The fix is short, but it is also one of the most searched Excel questions because the setting hides in two different places depending on what you actually want printed.

There are two flavors of lines in Excel: the soft gray gridlines that show every cell, and the bolder borders you draw on selected ranges. By default the gray gridlines do not print at all, which is why so many people see ghosted output the first time. Borders, on the other hand, always print if you have applied them. Knowing which kind of line you want is the first step to a clean print job, and almost every exam question on Excel printing turns on that exact distinction.

This guide walks through the practical fix in under a minute, then unpacks the deeper printing settings that show up on certification exams and real office workflows. You will learn the menu paths, the keyboard shortcuts, the difference between gridlines and borders, and the most common mistakes that send a report back to the printer for a second try. By the end you can answer any test scenario about Excel printing with confidence.

Whether you are studying for an Excel certification, the MOS exam, or simply need yesterday’s spreadsheet to look professional on paper, the same handful of rules apply across Excel 2016, 2019, 2021, and Microsoft 365. The interface shifts every few versions, but the print-line logic has stayed steady since Excel 2007 introduced the Ribbon. Lock these patterns into memory once and you will never lose marks or printer paper on this topic again.

The fastest fix lives on the Page Layout tab of the Ribbon. Open the workbook, click the Page Layout tab at the top of the screen, and look for the Sheet Options group. You will see two small columns labeled View and Print, each with a Gridlines checkbox. Tick the Print checkbox under Gridlines, then send the sheet to the printer. Lines now appear on paper around every cell that contains data within the printed range.

If you cannot see the Sheet Options group, your Ribbon may be collapsed. Press Ctrl+F1 to expand it, or right-click the Ribbon and choose Show Tabs and Commands. The Sheet Options group also includes Headings, which prints the column letters A B C and row numbers 1 2 3 down the left side. That setting is helpful when you want a printed reference grid for a colleague who will read the file in a meeting.

The setting is per-worksheet, not per-workbook, so each tab needs its own checkbox if you want gridlines across the whole file. To apply the option to several sheets at once, hold Ctrl and click the sheet tabs to group them, then tick the Print box. Excel applies the change to every grouped sheet. Just remember to ungroup the sheets when you are done, since edits made to a grouped sheet apply to all of them.

There is a second menu path that produces the same result and shows up on Microsoft Office Specialist exam questions: the Page Setup dialog. To open it, click Page Layout, then click the small arrow icon at the bottom right corner of the Page Setup group. The dialog opens with five tabs. Choose the Sheet tab, find the Print section in the middle, and tick the Gridlines checkbox. Click OK and the workbook is ready to print with lines.

The Page Setup dialog gives you more granular control than the Ribbon does. From the same Sheet tab you can also tell Excel to print row and column headings, set a print area, repeat rows at the top of every page for long reports, and choose draft quality or black and white output. These options are useful when you want a quick report without burning color toner, or when you need to fit a long list across multiple pages with clear headers on each.

For accountants and analysts who print frequently, learning the Page Setup dialog pays off fast. You can record a macro that opens this dialog and sets gridlines, headings, and print area in one action, then run that macro on every sheet you want formatted the same way. The Page Setup options also flow through to PDF exports, so a sheet that prints with gridlines also exports to PDF with gridlines using the same settings.

Print preview is the safest place to check that lines will actually appear before you waste paper. Press Ctrl+P or click File then Print to open the preview pane. The preview shows exactly what the printer will produce, including or excluding gridlines based on your current settings. If you see no lines in preview, the lines will not print. If you see lines in preview, they will print. The preview is the source of truth, so always glance at it before clicking the big Print button.

From the preview screen you can also adjust settings without going back to the worksheet. Click the Page Setup link at the bottom of the settings column and the full dialog opens, complete with the Sheet tab gridlines checkbox. After ticking the box and clicking OK, the preview redraws to show lines on every cell. This workflow is great when you are already mid-print and discover lines are missing because you can fix it in two clicks rather than returning to the Ribbon.

Print preview also reveals other problems that the worksheet view hides. You can spot rows that get cut off, columns that spill onto a second page, headers that fail to repeat, and orientation issues. Solve all of those before you click Print, especially on a long report. Many of the same Microsoft exam questions blend gridline settings with margin or scaling problems, so practicing inside print preview pays double on test day.

Sometimes you want lines on paper but not on screen, or the other way around. Excel handles both cases through the View column of the Sheet Options group. The View checkbox controls what appears in the worksheet window while you work, while the Print checkbox controls what lands on paper. You can untick View to hide gridlines on screen for a cleaner editing experience, then leave Print ticked so the printed output still shows them. The two settings are independent.

This independence is handy for presentation work. Many analysts hide screen gridlines while building dashboards because the empty grid distracts from the chart layout. Keeping printed gridlines on means the same workbook still produces a clean reference table when stakeholders ask for paper copies. Combine that with borders around the dashboard chart area, and you get the best of both worlds: a polished screen view plus a structured print output.

If you want gridlines hidden everywhere, untick both the View and Print boxes under Sheet Options. Now the worksheet looks like a blank canvas and prints as one too. Pair the change with custom borders around any tables you do want to highlight on paper. Designers and report builders often use this trick to mimic a Word document layout inside Excel while keeping the calculation power of formulas underneath.

Color choices affect how gridlines look on paper. By default, Excel prints gridlines in a light gray that is faint on some printers and almost invisible on others. The default works fine for most office printers, but draft-mode or older inkjets can lose the lines entirely. If your printed output shows ghosted lines, switch to manual borders in solid black for a cleaner look. Borders give you total control over weight, color, and pattern.

Excel also has a Draft Quality option inside the Page Setup dialog. Ticking it suppresses gridlines and most cell formatting so the printer outputs only the raw data faster and with less ink. This option is the opposite of what you want for a polished report, but it is exactly right for a quick proof read or a workshop handout where speed matters more than appearance. Knowing both settings exist saves time and toner on the right print run.

If you need printed lines in a specific color, manual borders are the only path. The Border dropdown on the Home tab lets you set color, line weight, and even diagonal lines for special table layouts. For automated workflows, you can apply borders via cell styles, which store a complete formatting package including borders, fonts, and number formats. Apply the style to a range and the borders update automatically, which is far faster than ticking checkboxes for every sheet.

For long reports that span multiple pages, gridlines alone are not enough; you also need to repeat the header row and column on every page so readers know what they are looking at. The Page Setup dialog handles this through the Print Titles section on the Sheet tab. Click the Rows to Repeat at Top box and select the header row from the worksheet. Excel then prints that row on every page along with the gridlines. The same goes for the leftmost column if you need it repeated.

Print Titles works hand in hand with the gridline setting. Together they produce a report where every page has a clear header, clean lines around every cell, and consistent formatting from start to finish. This is the standard layout for financial statements, audit work papers, inventory lists, and any tabular report distributed in printed form. Knowing how to combine the two settings is a frequent question on the Excel Specialist and Expert exams.

One subtlety: Print Titles uses absolute references to rows and columns, written as $1:$1 for the first row or $A:$A for the first column. If you delete or move the header row, the reference may break and the titles fail to print on later pages. Always check the Print Titles settings after major sheet restructuring, and rerun print preview to confirm the headers reappear on page two and beyond. Skipping this check is a common cause of confusing audit findings or report rework.

The same dialog includes a Print Area setting that limits which cells go to paper. Setting a print area is useful when a worksheet contains scratch calculations or staging tables that should not appear in the final report. Combine print area, gridlines, and print titles to ship a professional output every time without manual cleanup. Many exam scenarios bundle these three settings into a single multi-part question, so practicing them together is the best preparation strategy.

Microsoft Office Specialist exam questions on this topic often blend two or three settings into a scenario. A typical question describes an analyst who needs lines on every cell of a multi-page report and asks which combination of actions delivers the result. The expected answer is enabling Gridlines in Sheet Options plus configuring Print Titles to repeat the header row, all from the Page Layout tab. Single-step answers usually miss part of the requirement, so read every option carefully before choosing.

Another common scenario asks how to make a report look identical on paper to a screen mockup that shows borders around a few tables but no gridlines elsewhere. The correct approach is to keep the Print Gridlines box unticked, then apply manual borders to the specific tables using the Borders dropdown on the Home tab. Mixing gridlines and borders here would clutter the output, so understanding both routes is what separates a credit-worthy answer from a partial-credit one.

Exam graders also test the difference between gridlines on screen and gridlines on paper. Remember: View Gridlines controls the screen, Print Gridlines controls paper, and the two settings are independent. Real-world workflows take advantage of this independence to produce different visual outputs for different audiences. Once you have these distinctions locked in, similar questions on the MOS, ICDL, or vendor-specific certifications become quick wins on test day.

If a scenario asks about printing the column letters and row numbers, the answer is the Print Headings checkbox, which lives next to Print Gridlines in the same Sheet Options group. Headings are separate from gridlines but follow the same pattern; the View column controls screen, the Print column controls paper. Some exams pair this question with an audit scenario where the auditor needs cell references printed for review. Tick the Print Headings box and the entire grid arrives on paper with cell coordinates visible.

Printing Excel with lines is one of those tasks that feels harder than it really is on the first encounter. Once you know the two-flavor distinction between gridlines and borders, every question about lines on paper becomes a quick recall problem rather than a hunt through menus. The bulk of office workflows only need the Page Layout tab and the Sheet Options group, while exam questions reach a little deeper into the Page Setup dialog and the borders system on the Home tab.

Practice the workflow on a sample workbook. Open a blank sheet, fill a small range with numbers, and try every route described above: the Ribbon checkbox, the Page Setup dialog, the print preview shortcut, and manual borders. Compare the printed or PDF output of each approach to see how gridlines and borders interact. Hands-on repetition locks the concepts into memory better than reading them, especially under exam timing pressure where every second counts.

When you sit down for an Excel certification exam or face a real audit print request, the difference between scrambling and finishing fast comes down to fluency with these settings. Build the habit of glancing at print preview before clicking Print, even on familiar reports. The preview catches missing gridlines, off-page columns, and broken headers before paper is committed. That single habit raises your output quality and your study confidence at the same time.

Beyond the basics, Excel offers more advanced print controls that build on the gridline foundation. Page breaks let you control where new pages start. Scaling lets you fit a wide report to one page wide by many tall, which solves a huge class of print problems for cross-tab data. Margins and orientation rotate to landscape when needed. Each of these is its own topic, but they all start from the Page Layout tab and the Page Setup dialog, the same place you found the gridline checkbox.

For team workflows, consider building a small set of cell styles that ship with borders, fonts, and number formats baked in. Apply the style to a range and the report looks polished without anyone needing to remember the gridline checkbox. This pattern scales well for finance teams, audit firms, and operations groups that produce dozens of similar reports each week. The styles travel with the workbook, so a colleague who opens the file sees the same formatting choices as the original author.

If you support a team or train new analysts, share a short reference card with the four print routes, the gridlines-versus-borders rule, and the print preview habit. Most users only need to learn the topic once with a clear example before it sticks for good. The investment pays off in fewer reprints, fewer support tickets, and cleaner output across the team. And on exam day, those same memorable rules turn what looked like a tricky print question into one of the easiest points on the test.