Knowing how to show gridlines in Excel is one of those small skills that quietly makes every spreadsheet easier to read, edit, and share. Gridlines are the faint gray lines that separate cells visually, helping your eyes track rows and columns without getting lost. When they suddenly disappear, even a simple budget can feel confusing. Whether you accidentally turned them off, opened a file with custom settings, or pasted in a white-filled block, this guide walks you through every reliable method to bring those lines back fast.

The good news is that gridlines live in a single, predictable checkbox most of the time. On Windows, you head to the View tab and toggle the Gridlines option; on Mac, the location is nearly identical. But there are several less obvious reasons gridlines vanish, including cell fill colors, white borders, page layout view quirks, and zoom levels that hide thin lines. Understanding each cause means you fix the problem once instead of guessing repeatedly every time a workbook looks blank and flat.

This matters because gridlines are not the same as borders. Gridlines are a display and printing preference that affects the entire worksheet, while borders are deliberate formatting applied to specific cells. Many people confuse the two, then waste time clicking border menus when the real fix is one View tab checkbox. We will keep that distinction crystal clear throughout, because mixing them up is the single most common reason a fix that should take five seconds turns into a frustrating ten-minute hunt.

Beyond simply turning gridlines on, you can customize them in surprisingly useful ways. Excel lets you change gridline color, hide them on individual sheets while keeping them on others, and control whether they appear when you print. For dashboards and polished reports, hiding gridlines creates a clean, professional canvas. For data entry and auditing, showing them keeps everything aligned. Learning both directions gives you full control over how your spreadsheet looks on screen and on paper.

We will also cover the printing side, which trips up many users. By default, Excel shows gridlines on screen but does not print them. If you need printed cell lines for a paper checklist or signed form, you flip a separate Print setting under Page Layout. This is intentional separation, and once you know it exists, printing clean grids becomes effortless. We will show the exact path so your printed pages match what you actually want every single time.

Finally, this guide includes troubleshooting for the trickier cases: gridlines missing in only part of a sheet, lines that appear too light to see, settings that reset when files are shared, and differences between Excel desktop, Excel for the web, and mobile apps. By the end, you will be able to confidently show, hide, recolor, and print gridlines in any version of Excel, and you will understand the why behind each setting so the knowledge sticks long after you close this page.

Before fixing missing gridlines, it helps to understand why they vanish in the first place, because the cause determines the cure. The most frequent reason is simply that someone unchecked the Gridlines box on the View tab. This is easy to do by accident, and it travels with the file, so a workbook shared by a colleague may arrive with gridlines already hidden. Checking that box first solves the majority of cases in seconds before you investigate anything more complicated underneath.

The second common cause is a white or colored cell fill. When you apply a fill color, Excel paints over the gridlines in those cells because fill sits on top of the grid layer. A white fill looks identical to the default background, so the cells appear gridless even though the View setting is on. To confirm this, select the suspicious cells, open the fill color menu, and choose No Fill. The gridlines underneath will reappear immediately if fill was the culprit.

A third cause is white borders applied to cells. Borders are deliberate lines, and a white border drawn over a white background effectively erases the visible gridline in that spot. This often happens when copying formatted data from another source or template. Unlike gridlines, borders are per-cell formatting, so you remove them through the Borders dropdown on the Home tab by selecting No Border. People learning skills like how to merge cells in Excel sometimes inherit border artifacts this way.

Zoom level and screen scaling can also hide thin gridlines. At very low zoom percentages, the single-pixel gray lines may not render clearly on high-resolution displays, making the sheet look blank even though everything is configured correctly. Bumping the zoom back to one hundred percent usually restores visibility instantly. Similarly, some display drivers and remote desktop sessions render faint lines poorly, so the issue is visual rather than a true setting change inside the workbook itself.

Page Break Preview and certain custom views can suppress gridlines too. If you switched to Page Break Preview to arrange printing, the display behaves differently and may downplay gridlines compared to Normal view. Returning to Normal view from the View tab restores the standard appearance. Custom views saved by other users can also carry hidden-gridline settings, so applying a different view sometimes flips the behavior unexpectedly when you open a shared or templated workbook.

Finally, gridlines are a per-worksheet property, not a global one. You can have one sheet with gridlines showing and the next sheet completely blank, all inside the same file. This surprises people who assume one toggle controls everything. When auditing a workbook, check each tab individually. Understanding these six causes means that instead of randomly clicking buttons, you can diagnose the exact reason your gridlines are missing and apply the correct, lasting fix the first time.

Printing gridlines correctly is where many otherwise confident users get stuck, because Excel deliberately separates the on-screen toggle from the print toggle. By default, what you see on your monitor will not appear on paper. To print gridlines, open the Page Layout tab, find the Sheet Options group, and under the Gridlines heading check the Print box. Now your worksheet's faint lines will render on every printed page, turning a digital grid into a usable paper form, checklist, or signed document.

It is worth pausing on why Microsoft built it this way. Most professional reports look cleaner without a full grid, so printing gridlines is off by default to favor polished output. When you genuinely need lines, such as for a tally sheet, attendance log, or manual data-entry form, the Print Gridlines option gives you exactly that without forcing borders onto every cell. This design keeps casual printing tidy while still supporting the practical paper use cases where visible cell boundaries genuinely help.

Before sending the job to your printer, always use Print Preview, reachable through File then Print or with Ctrl+P. The preview shows precisely how gridlines will appear, including how they interact with page breaks across multiple sheets of paper. If lines look missing in preview even after enabling Print Gridlines, the usual culprits are an active print area that excludes those cells or a white fill covering them, the same fill issue that hides lines on screen.

You can also combine printed gridlines with other Sheet Options for a more complete page. The same Page Layout group lets you print row and column headings, which adds the familiar 1, 2, 3 row numbers and A, B, C column letters to your output. This is invaluable when discussing a spreadsheet over the phone or in a meeting, because everyone can reference the exact cell coordinates printed right there on the shared physical page.

Margins, orientation, and scaling all influence how clearly printed gridlines read. Tight margins and a fit-to-one-page scaling setting can compress lines so closely that they blur on certain printers. If your printed grid looks fuzzy, try landscape orientation, widen the margins slightly, or print at actual size rather than shrinking everything onto a single sheet. A little spacing lets each line render crisply, which matters most on forms people will write on by hand.

Finally, remember that printed gridlines respect the same per-sheet scope as the screen setting. Enabling Print Gridlines on one worksheet does not enable it across the workbook, so a multi-tab file needs the option set on each sheet you intend to print with lines. If you regularly print the same layout, save the workbook with these options configured, or build a template, so you never have to reconfigure the print grid from scratch again.

When the standard fixes do not work, methodical troubleshooting saves time. Start by isolating scope: is the problem on one sheet or all of them, in one cell range or the whole grid? If gridlines are missing in just a block of cells, the cause is almost always fill color or white borders applied to that range, not the worksheet-wide View setting. Select the affected cells, set fill to No Fill, then clear borders, and the underlying gridlines should snap back into view immediately.

If gridlines are missing across an entire sheet while other sheets look fine, the View tab Gridlines checkbox for that specific tab is unchecked. This per-sheet behavior catches people who assume the setting is global. Click into the problem sheet, open View, and re-check Gridlines. If the box is already checked yet nothing shows, suspect a sheet-wide fill, a custom view, or a gridline color that has been set to white, which makes the lines invisible against the default background.

Changing gridline color is a powerful but overlooked option. Go to File, Options, Advanced, then scroll to Display options for this worksheet. There you will find a Gridline color picker. If a previous user set the color to white or a very pale shade, the lines exist but cannot be seen. Choosing a darker gray or any visible hue restores them instantly. This same menu also has a master Show gridlines checkbox that mirrors the View tab toggle.

Version differences matter too. Excel for the web keeps the Gridlines toggle on the View tab but offers fewer color options than the desktop app. The mobile apps for iPad and phones hide the setting inside formatting menus and may not support print gridlines at all. If a teammate using a different platform reports missing lines, the workbook setting is likely fine and the limitation is platform-specific, so confirm which app they are actually using.

Shared and templated files introduce another layer. When you open a workbook created by someone else, it arrives with their display settings baked in, including hidden gridlines. The same is true of company templates and downloaded files. This is not corruption, just inherited preferences. Toggle the View setting to your liking and save, and the file will keep your choice. If you build skills like how to freeze a row in Excel, you will notice those view settings travel with the file in exactly the same way.

For stubborn cases, a few resets help. Try closing and reopening the file to clear temporary rendering glitches, especially over remote desktop or in older hardware. Update Excel to the latest build, since display bugs are occasionally patched. As a last resort, copy your data into a fresh blank workbook, which carries default gridline settings, then reapply only the formatting you actually want. This rules out a deeply customized or partially corrupted sheet as the source of your missing gridlines.

To make gridline control second nature, build a few practical habits into your everyday Excel workflow. First, memorize the path: View tab, Show group, Gridlines checkbox. Saying it out loud a couple of times cements it, and within a week you will toggle gridlines without thinking. Pair that with the print path, Page Layout, Sheet Options, Print under Gridlines, and you cover both screen and paper. These two short routes handle the vast majority of real-world gridline tasks you will ever face.

Second, learn to read a blank-looking sheet diagnostically. The instant gridlines seem missing, ask three quick questions: is the View box checked, is there a fill color, and are there white borders? Running through that mental checklist takes seconds and almost always reveals the cause. This habit replaces frustrated clicking with confident diagnosis, and it transfers to teammates too, since you can guide someone over a call by simply asking them those same three targeted questions in order.

Third, decide your default look per project type. For data entry, auditing, and analysis, keep gridlines on so alignment stays obvious. For client-facing dashboards, summaries, and printed reports, hide gridlines and use deliberate borders only where they add meaning. Setting this convention up front saves rework later, because you are not toggling lines repeatedly mid-project. Consistency also makes your spreadsheets instantly recognizable and professional, which matters when files circulate through a team or organization.

Fourth, use templates to lock in your preferences. If you frequently create the same kind of workbook, configure gridlines, print options, headings, and colors once, then save it as a template. Every new file inherits those choices automatically, eliminating repetitive setup. This is especially valuable for recurring reports, invoices, and forms where the print grid must look identical each time. A good template turns a five-minute configuration into a zero-click standard you never have to think about again.

Fifth, test your print output early rather than at deadline. Run a quick Print Preview as soon as you enable print gridlines, not five minutes before a meeting. Previewing early catches print-area issues, page-break surprises, and faint-line problems while you still have time to fix margins, orientation, or scaling. Building this small checkpoint into your process prevents the classic last-minute scramble where a printed form arrives with no lines and no time left to correct it.

Finally, keep practicing the broader display toolkit alongside gridlines. The same View tab controls headings, the formula bar, and the ruler, and mastering them together makes you noticeably faster in Excel. Spend a few minutes toggling each one to see its effect, then try changing gridline color and printing a sample sheet. Hands-on repetition turns these settings from things you look up into reflexes, and that fluency compounds across every spreadsheet task you tackle from here forward.