Excel No Border Lines? Fix Missing Gridlines

Errors & fixes · Updated November 22, 2026

If your Excel sheet shows no border lines, the gridlines are simply turned off or hidden by white fill—go to View > Show > Gridlines and check the box, or remove white cell fill via Home > Fill Color > No Fill. This usually restores the faint gray lines that separate cells, which are different from borders you apply manually.

Gridlines vs. Borders: What’s the Difference?

Gridlines are the light gray lines that appear by default on every worksheet, marking cell boundaries. They are a display aid, not part of the printed output unless you enable them in Page Setup. Borders, on the other hand, are formatting you apply to specific cells—they print by default and can be any color, thickness, or style. When people say “no border lines,” they often mean gridlines are missing, but sometimes they mean they applied borders and they aren’t showing. Knowing which one you’re dealing with is the first step to fixing it.

Why Gridlines Disappear in Excel

Gridlines can vanish for several reasons, most of them simple settings:

  • View tab: The “Gridlines” checkbox under View > Show is unchecked.
  • White fill: Cells filled with white (or any solid color) cover the gridlines. This is the most common hidden cause.
  • Zoom level: At very low zoom (below 40%), Excel may hide gridlines to improve performance.
  • Conditional formatting: Rules that apply a fill to cells will also hide gridlines.
  • Page Break Preview: In this view, gridlines are replaced by dashed page break lines.

How to Show Gridlines Again (Step-by-Step)

Here’s how to restore gridlines in Excel for Microsoft 365 on Windows:

  1. Open your worksheet.
  2. Go to the View tab on the ribbon.
  3. In the Show group, check the Gridlines box. If it’s already checked, uncheck and recheck to refresh.
  4. If gridlines still don’t appear, select all cells (Ctrl+A), then go to Home > Fill Color and choose No Fill.
  5. Check if any conditional formatting rules are applying a fill: Home > Conditional Formatting > Manage Rules.

On a Mac, the path is the same: View > Show > Gridlines. In Excel for the web, go to View > Gridlines (it’s a toggle, not a checkbox).

How to Print Gridlines or Borders

If you need gridlines to appear on paper, you must enable them in Page Setup—gridlines are off by default for printing. Go to Page Layout > Sheet Options and check Print under Gridlines. Alternatively, apply actual borders to the cells you want lines around: select the range, go to Home > Borders (the square icon in the Font group), and choose “All Borders.” Borders print automatically. For example, to add borders to A1:E10, select that range, click the Borders dropdown, and pick “All Borders.”

Common Problems and Quick Fixes

  • Gridlines missing only on some cells: That’s almost always a white fill. Select the affected cells and set fill to “No Fill.”
  • Borders not showing: Check if the border color is white or if the border style is set to “None.” Also, ensure the cells aren’t covered by a shape or image.
  • Gridlines disappear when scrolling: This can happen with large datasets; try resetting zoom to 100% or toggling gridlines off and on.
  • Gridlines in a specific sheet only: The setting is per-sheet, so check the View tab on that sheet.
  • Gridlines not printing despite being on: Make sure you’re in Normal view (not Page Break Preview) and that the print area includes the cells.

How to Change Gridline Color and Defaults

You can change gridline color globally: go to File > Options > Advanced, scroll to “Display options for this worksheet,” and pick a color from the “Gridline color” dropdown. This affects all sheets in the workbook unless you change it per sheet. To make gridlines always visible in new workbooks, you don’t need to change a default—gridlines are on by default; if they’re off, it’s because someone turned them off or a template did. You can save a workbook as a template (.xltx) with gridlines on, then use it for new files.

Frequently Asked Questions

Why are my gridlines missing even though the box is checked?

Most likely, cells have a white fill. Select all cells (Ctrl+A), go to Home > Fill Color, and choose “No Fill.” If that doesn’t work, check conditional formatting rules that might be applying a fill.

How do I add lines around cells in Excel?

Use borders. Select the cells, go to Home > Borders (the square icon), and choose “All Borders” or a custom style. You can also draw borders with the “Draw Border” tool in the same menu.

Can I print gridlines without borders?

Yes. Go to Page Layout > Sheet Options, and under Gridlines, check “Print.” This prints the gray gridlines, but they are light—consider using borders for darker lines.

Why do gridlines disappear when I use a fill color?

Because a solid fill covers the gridlines. That’s normal behavior. If you want gridlines to show through, use a lighter fill or no fill, or apply borders on top of the fill.

Is there a keyboard shortcut to toggle gridlines?

No direct shortcut exists, but you can press Alt > W > V > G to toggle gridlines (Windows). On Mac, there’s no built-in shortcut; you can add it to the Quick Access Toolbar.

Alternatives to Gridlines for Visual Separation

If gridlines are too faint or you want more control, consider:

  • Borders: Apply thin gray borders to mimic gridlines but with more control over thickness and color.
  • Table formatting: Convert your data to a table (Insert > Table) to get banded rows and borders automatically.
  • Cell styles: Use built-in styles like “Input” or “Output” that include borders.
  • Conditional formatting: Use a formula to draw borders dynamically, but that’s advanced.

For most users, simply turning gridlines back on or removing white fill is enough. If you’re working with a complex sheet, remember that gridlines are a display preference—they don’t affect data or calculations.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.