Excel Gridlines: The Complete Guide to Showing, Hiding, Printing, and Customizing Worksheet Lines in 2026

Excel gridlines are the faint horizontal and vertical lines that separate every cell on a worksheet, and while they seem like a small visual detail, they shape how readable, professional, and printable your spreadsheets are. Whether you are building a financial model, a vlookup excel reference table, an invoice template, or a quick data dump for a meeting, understanding how to control gridlines is one of the fastest ways to upgrade your Excel output. Most users never touch the gridline settings and miss out on huge productivity gains.

By default, gridlines appear on screen in a light gray color, but they do not print unless you explicitly enable them in the Page Layout settings. This single quirk causes more printing frustration than almost any other Excel behavior. People assume that what they see is what they get, only to discover their printed report has rows and columns floating in white space. Learning the difference between screen gridlines and print gridlines is foundational knowledge for anyone serious about spreadsheets.

Gridlines are not the same as borders, which is a distinction that trips up beginners constantly. Gridlines are a worksheet-wide display setting controlled from the View tab, while borders are formatting applied to individual cells from the Home tab or the Format Cells dialog. Borders always print and stay with the cells when copied. Gridlines, in contrast, are essentially a visual aid that vanishes the moment you apply a fill color to a cell, which is why dashboards often look like gridlines have mysteriously disappeared.

This complete guide walks through every gridline scenario you will encounter in modern Excel: showing and hiding them, changing their color, fixing the missing-gridline problem, printing them on physical pages, controlling them in specific cell ranges, and using VBA to automate gridline behavior across multiple sheets. We will also cover how gridlines interact with conditional formatting, themes, page breaks, and the new dark mode in Microsoft 365. By the end you will treat gridlines as a deliberate design choice rather than an accident.

If you are studying for certifications or job interviews, gridline questions appear regularly on Microsoft Office Specialist (MOS) exams and on most entry-level Excel skills tests used by recruiters. Hiring managers often ask candidates to remove gridlines for a dashboard, then re-enable them for a data entry sheet, all in under thirty seconds. Knowing where each setting lives, plus the keyboard shortcuts, signals that you have moved past beginner status into intermediate territory.

We will also tackle the common questions that send people scrambling to Google: why gridlines disappear after pasting from another workbook, why they look thicker on some monitors, how to make them darker without applying borders to every cell, and what to do when only certain rows show lines. Each scenario has a clean fix, and once you know the underlying logic, you can solve gridline mysteries on any version of Excel from 2016 through Microsoft 365 and Excel for the web.

Treat this article as your single reference for everything gridline-related. Bookmark it, work through the examples in your own workbook, and pair the lessons with the free practice quizzes linked throughout. Gridlines may look minor, but mastering them is a small lever that produces a surprisingly large jump in spreadsheet polish.

Changing the color of Excel gridlines is one of those features that almost no one knows exists, yet it can completely transform the look of a worksheet. The setting lives buried in File, Options, Advanced, under the section labeled Display options for this worksheet. Scroll down until you see Gridline color, click the small color swatch, and pick any color from the palette. The change applies only to the active worksheet, which makes it perfect for color-coding tabs in a multi-sheet workbook.

Many financial analysts use a soft blue or muted teal for gridlines on model tabs and pure white (which effectively hides them) on presentation tabs. Designers building inner excellence book style reading layouts or training materials sometimes choose a warm beige to reduce eye strain. Whatever you pick, the key principle is contrast: gridlines should be visible enough to guide the eye without competing with the actual data. A color that is too dark turns a clean sheet into a busy grid that reads like a prison floor plan.

If you only want to change gridlines in a specific range rather than the entire worksheet, the trick is to apply borders instead. Select the range, open the Format Cells dialog with Ctrl+1, click the Border tab, choose your color and line style, then apply inside and outside borders. To make the effect look like a custom gridline rather than a heavy table, pick the thinnest dotted line at a light gray hex value such as #BFBFBF. The result is indistinguishable from a real gridline but only covers your chosen range.

Excel for the web behaves slightly differently. As of 2026, the web version does not yet support custom gridline colors, although the show and hide toggle works identically to the desktop app. If color customization matters, you must edit the file in the desktop version, save it, and the color setting will persist when reopened in the browser. This is a common gotcha when collaborating with team members who only have web access through SharePoint or OneDrive.

The dark mode rollout in Microsoft 365 added another wrinkle. When dark mode is active, Excel inverts the default gridline color to a soft white-gray that contrasts with the dark canvas. If you previously set a custom gridline color, dark mode overrides it for readability. To force your custom color back, switch to the Use system setting or Office light theme under File, Account, Office Theme. This is one of the most frequent complaints in Microsoft 365 forums after each dark mode update.

A subtle but useful point: gridline color changes never affect printing. Even if you set gridlines to bright red on screen, they still print in the default light gray when print gridlines is enabled. To print colored lines you must use borders instead. This is why professional templates almost always use borders for any visual structure that needs to survive the trip from screen to paper, with screen gridlines turned off to avoid double lines.

Finally, remember that the gridline color setting is stored inside the workbook file itself, not in your Excel preferences. If you share the file, the recipient will see your chosen color. If you reset Excel or move to a new computer, the colors travel with the file. This is excellent for branded templates but worth knowing if you wonder why a downloaded workbook looks different from yours.

Power users eventually outgrow the View tab checkbox and move to VBA for gridline control. The relevant property is ActiveWindow.DisplayGridlines, which accepts True or False. A one-line macro such as ActiveWindow.DisplayGridlines = False hides gridlines on the active sheet instantly. To loop through every sheet in a workbook, iterate over the Sheets collection, activate each sheet, set the property, and you can clear gridlines from a fifty-tab workbook in under a second. This is invaluable when preparing client deliverables that must look polished across every tab.

The DisplayGridlines property is tied to the window, not the worksheet object itself, which is a subtle but important distinction. If you open the same workbook in two windows side by side, each window can show gridlines differently. This becomes useful when you want to view one sheet with gridlines for editing and another without for presentation, all without saving and reopening the file. Use View, New Window to create a second view of the same workbook.

Another advanced trick involves the Worksheet_Activate event. By placing code in the sheet module that toggles gridlines whenever the user clicks onto that tab, you can create workbooks where dashboard tabs auto-hide gridlines and data entry tabs auto-show them. Users never have to think about it. Combined with Worksheet_Deactivate, you can fully automate the gridline experience and deliver a far more polished workbook than peers who rely on manual toggling.

For users who prefer Power Query or Office Scripts in Excel for the web, gridline control is more limited. Office Scripts can manipulate worksheet properties via the ExcelScript.Worksheet object, though the gridline display property is exposed only in newer API versions. If you script gridline toggling, test on each user's build because the API surface evolves quickly. Power Query does not control gridlines at all since it operates on data, not display, which is worth knowing before you go hunting for a feature that does not exist.

Conditional formatting interacts with gridlines in a predictable way: any rule that applies a fill color will hide gridlines in the formatted cells, exactly like manual fill color. If you want to preserve gridlines while highlighting cells, use a font color rule or an icon set rule rather than a fill rule. Alternatively, use a very pale fill at low opacity, though Excel does not directly support opacity, so the workaround is to mix a custom RGB color that approximates the look you want.

Themes also affect gridline appearance more than most users realize. Switching from the default Office theme to a custom theme changes the gridline color subtly because the theme's background color shifts the contrast. If you build branded templates for clients, design and lock the theme first, then choose gridline colors that work with it. This avoids the awkward moment when a client opens your template and discovers gridlines have become invisible against their corporate background.

Finally, advanced printing scenarios benefit from the Print Titles feature combined with gridlines. Set rows to repeat at the top via Page Layout, Print Titles, and enable Print Gridlines. Excel will render gridlines on every printed page including the repeated header rows, producing a consistent multi-page report. This is the standard approach for printed financial statements, lab reports, and any document that needs to look uniform regardless of page count.

Best practices for gridlines on professional dashboards begin with one principle: less is more. Modern dashboard design favors clean white or pale gray backgrounds with minimal gridlines, relying on careful spacing, typography, and color blocks to organize information instead. Turn gridlines off across the entire dashboard tab, then use cell fills and explicit borders only where structure genuinely helps the reader. This is the approach used by elite finance teams, BI consultants, and the design teams behind premium templates from sites like the institute of creative excellence and other training providers.

For data entry sheets, the opposite rule applies: keep gridlines on, and add subtle alternating row colors using a banding pattern through Format as Table. The combination of gridlines plus banded rows reduces data entry errors by helping the eye track horizontally across wide tables. Studies of spreadsheet usability consistently show that data entry accuracy improves when gridlines are visible, so resist the urge to make data entry tabs look minimalist.

When sharing workbooks with clients or executives, always preview the file with gridlines toggled both on and off before sending. A workbook that looks crisp on your monitor may look cluttered or sparse on a client's high-resolution display. Many consultants keep two versions of each deliverable: an internal working copy with gridlines and a client copy without. The few extra seconds it takes to save a clean version pay back in perceived professionalism.

Pair gridline strategy with how to freeze a row in excel for any dataset over twenty rows. Freezing the header row keeps column labels visible while users scroll, and the visible gridlines reinforce the boundary between header and data. This combination is the single most common pattern in well-built operational spreadsheets, from inventory trackers at excellence resorts to financial models at investment banks. It is simple, free, and immediately improves usability.

For printed reports, consider applying borders rather than relying on print gridlines. Borders give you precise control over line weight, color, and which sides of each cell show lines. The result is a report that looks intentionally designed rather than mechanically gridded. Use the All Borders option from the Home tab to apply a clean grid to a table, then turn off Print Gridlines so you do not get double lines on the printout.

Document your gridline choices in any template you build for repeated use. Add a hidden sheet called README that explains which tabs have gridlines off, which use custom gridline colors, and why. Future maintainers, including future you, will appreciate the note. Templates that survive years of use almost always include this kind of documentation, while undocumented templates degrade quickly as people forget the design intent and start applying inconsistent fixes.

Finally, treat gridlines as part of a broader visual hierarchy. The most effective spreadsheets use four to five levels of visual emphasis: bold section headers, subtle table borders, soft gridlines, banded rows, and accent fills for key cells. Gridlines are the quietest layer in this hierarchy and should never compete with the others. Get the hierarchy right and your workbooks will look professional even before you add a single chart or KPI.

To put everything together, set yourself a small practice goal this week. Open a fresh workbook, create three sheets, and configure each one with a different gridline strategy: full default gridlines on sheet one, hidden gridlines plus explicit borders on sheet two, and a custom blue gridline color on sheet three. Save the file, close it, reopen it, and verify the settings persisted. This simple exercise builds muscle memory faster than reading any tutorial.

Next, practice the keyboard shortcuts until they are automatic. Alt+W+VG toggles gridlines on most US keyboards. Alt+P+G+View on the Page Layout tab handles the print gridlines toggle. Ctrl+1 opens Format Cells for border work. The fastest Excel users rarely touch the mouse for these settings, and the time savings add up across a workday. Aim to perform each toggle in under two seconds.

If you build templates regularly, create a personal starter workbook with your preferred gridline defaults already configured. Save it as a template file (.xltx) in your Excel templates folder. Every new workbook you base on it will inherit the settings, eliminating the need to repeat the configuration. This is one of the highest leverage habits an Excel power user can develop, and it costs only a few minutes to set up once.

For interview preparation, expect at least one gridline-adjacent question on any Excel skills test. Common formats include asking the candidate to display gridlines on a printed page, change gridline color, or explain the difference between gridlines and borders. Practice articulating the answers out loud, since explaining clearly is harder than knowing the answer. The free practice quizzes linked in this guide cover these scenarios with multiple-choice and short-answer formats.

When troubleshooting a client's workbook, always check gridlines first before assuming a deeper problem. A surprising number of help-desk tickets about missing data or weird formatting turn out to be gridline issues caused by accidental white fills. Train yourself to glance at the View tab and the Home tab fill color whenever a sheet looks off. This single diagnostic habit saves hours of unnecessary debugging across a career.

Combine gridline mastery with the broader formatting skills covered in our Excel articles on functions, finance modeling, and reporting. Gridlines are one piece of a larger visual toolkit that includes number formatting, conditional formatting, charts, and layout. Each piece compounds with the others, and a worksheet that nails all of them looks dramatically more professional than one that only optimizes a single dimension. Build the habit of considering all layers whenever you finish a worksheet.

Finally, remember that gridlines are a tool, not a rule. There is no universal right answer for whether to show them or hide them. The right answer depends on the audience, the purpose, the medium (screen versus paper), and the broader visual design of the workbook. Develop judgment through practice, ask for feedback from colleagues, and study workbooks built by people whose work you admire. Over time, your gridline choices will become an invisible signature of quality.