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:
- Open your worksheet.
- Go to the View tab on the ribbon.
- In the Show group, check the Gridlines box. If it’s already checked, uncheck and recheck to refresh.
- If gridlines still don’t appear, select all cells (Ctrl+A), then go to Home > Fill Color and choose No Fill.
- 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
- Excel Choose Date from Calendar Cell: How to Add a Date Picker
- Excel Center Jobs: What They Are & How to Get One
- Excel Center Kokomo Indiana: What It Is & How to Enroll
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Conditional Formatting Excel Error Values: How to FlagTo highlight Excel error values, select the cells, go to Home > Conditional Formatting > New Rule >…
- Excel Program Not Responding? How to Fix ItIf Excel says “Not Responding,” first give it a minute if a calculation, refresh, or large file operation…
- How to Fix Zoom in Excel and Restore a Readable ViewTo fix zoom in Excel for Microsoft 365 on Windows, open the View tab and choose Zoom to…
- Excel Not Working Correctly? Causes and Reliable FixesIf Excel is not working correctly, first save a copy of the workbook, note exactly what is failing,…
- Excel Unique Name Error: Why It Appears and How to Fix ItIf Excel says a name is already taken or must be unique, the name you are trying to…
- Why Block Sender Does Not Work in Outlook and How to Fix ItBlock Sender in Outlook usually does not stop a message from being sent or make it disappear; it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.