Excel Cell Borders Not Showing? How to Fix Them in Excel

Errors & fixes · Updated November 18, 2026

If Excel cell borders are not showing, first select the affected cells and apply a visible border from Home > Font > Borders; then check that the border color is not white or otherwise blending into the cell. If the lines you expect are only worksheet gridlines, turn them on under View > Show > Gridlines instead—gridlines and borders are separate features.

First, tell borders apart from gridlines

Excel displays faint gridlines across cells by default, but these are only a worksheet viewing aid. They are not cell formatting, cannot be assigned a custom color or weight, and do not print by default. A border is formatting attached to a cell edge. You can choose its color, line style, and position, and it normally prints with the worksheet.

This distinction explains a common surprise: a worksheet can look like it has lines even though no cells have borders. If you apply a fill color to cells, Excel’s gridlines disappear beneath the filled area. That does not mean the fill erased a border; it may simply reveal that the cells never had borders in the first place. To add actual lines, select the cells and choose a border option such as All Borders or Outside Borders from the Borders menu.

To show or hide gridlines on a worksheet in Excel for Microsoft 365 on Windows, go to View > Show and select or clear Gridlines. Gridline visibility is a worksheet display setting, so changing it does not add borders to cells. For printed output, use Page Layout > Sheet Options > Gridlines and select Print if you want gridlines on paper or in a PDF. On a Mac, the View tab also has a Gridlines option; the exact ribbon layout can differ slightly. Excel for the web offers a View tab with a gridlines control, though available print settings may differ from desktop Excel.

Apply a border that is easy to see

For a straightforward repair in the Windows desktop app, select the relevant cells, open Home > Font > Borders, and choose All Borders. This applies a border to each selected cell edge. Choose Outside Borders if you only want a frame around the selection. To format one edge, open the same menu and select the appropriate edge option, such as Bottom Border. The menu icon may display the last-used border, so open its dropdown arrow to see the full set of choices.

If a border is present but faint, set its color and line style explicitly. In the Borders dropdown, choose Line Color and select a color that contrasts with the cell fill. Choose Line Style for a solid or other available weight, then apply the desired edge from the menu. Alternatively, select the cells and open the Format Cells dialog with Ctrl+1 on Windows. In the Border tab, choose a line style and color, then click the preview edges you want and select OK. On a Mac, Command+1 opens Format Cells; ribbon labels and dialog layout may vary by release.

For example, a pale-gray bottom border on a white table can be hard to notice at a small zoom level. A darker gray or black solid line is more visible. If the cells have a dark fill, choose a light border color instead. The best setting depends on the background and intended use: a subtle table divider may be appropriate on screen, while a report that will be printed often needs a stronger line.

Check border color, fill, and neighboring cells

A border can be technically present and still seem missing because its color matches the cell fill or the worksheet background. Select a cell that should have a line and inspect its formatting in Format Cells > Border. If the preview shows an edge, test a contrasting color rather than repeatedly applying the same border command. Automatic or theme colors can also look different when a workbook is opened with a different theme or displayed on another device.

Cell edges are shared boundaries, which can make a single missing line confusing. A boundary between A1 and B1 can be affected by the right edge of A1 and the left edge of B1. If a line does not appear where two cells meet, select both cells and apply the border to the intended range, or inspect the edge settings of each cell. For a rectangular table, applying All Borders to the whole range is often more reliable than formatting individual cells one at a time.

Also look at the fill setting. A white fill can conceal gridlines, while a colored fill makes the absence of borders more obvious. If you want ordinary gridlines to show again, select the cells and use Home > Font > Fill Color > No Fill. Do this only if removing the fill is appropriate; it changes cell formatting and may remove a deliberate background color. If the design calls for colored cells, keep the fill and apply explicit borders instead.

Inspect conditional formatting and table styles

Conditional formatting can change a cell’s appearance when a rule is true. A rule may supply a border, and rule order or overlapping rules can affect which formatting is visible. To investigate, select an affected cell and go to Home > Conditional Formatting > Manage Rules. Set the display to show rules for the current selection or worksheet, then inspect rules that apply to the cell. Edit or remove a rule only if its condition or format is not intended. A direct border may appear to have no effect if conditional formatting is supplying a different border in the relevant situation.

Excel tables also use table styles that can make rows and columns look separated through shading or banding rather than explicit borders. If lines disappear only inside a formatted table, select a table cell and check the Table Design tab and its style options. Try a different style or add explicit cell borders if the table needs stronger dividers. A style change affects the table’s appearance as a whole, so consider whether it will alter header, total, or banded-row formatting before applying it.

To distinguish a style issue from a border issue, select one affected cell and open Format Cells > Border. The dialog preview helps show whether an edge is assigned directly to that cell. Conditional formatting and table styles can still affect the final appearance, so check those sources too if the preview looks correct but the worksheet does not.

Look for hidden rows, columns, and display effects

A border may be on a cell that is not currently visible. Hidden rows or columns can make the edge of a range seem incomplete, and very short row heights or narrow columns can make a line difficult to distinguish. Check the row numbers and column letters for gaps that indicate hidden areas. To reveal a hidden row or column, select the headers on both sides of the gap, right-click, and choose Unhide. You can also use Home > Format > Hide & Unhide and select the relevant option.

Zoom can affect how thin lines look on screen. If borders appear uneven or vanish at one zoom level, change the zoom using the control at the bottom-right of the Excel window, or use View > Zoom to choose a percentage. This changes the display scale, not the border formatting. Compare the sheet at a different zoom and, if the result matters for sharing, check Print Preview as well. A line that is hard to see on a monitor may still print correctly, and a visible screen line may be only a gridline that will not print.

If the worksheet is protected, Excel may prevent formatting changes. Look for Review > Unprotect Sheet. If that option is available, the sheet is protected; you may need the password or permission from the workbook owner before changing borders. Sheet protection can be configured to allow some actions and block others, so a border command that appears unavailable or does not apply may be a permissions issue rather than a display problem.

Check printing and PDF output separately

When borders show on the worksheet but disappear in a printout, verify that you used actual borders rather than relying on gridlines. Cell borders normally print; gridlines require the Print setting under Page Layout > Sheet Options > Gridlines. In Print Preview, inspect the page at a readable scale and check that the relevant cells are included in the print area. A set print area, page break, or scaling choice can exclude or shrink part of the sheet and make a border difficult to see.

If the lines are thin, test a darker color or heavier line style and preview again. Also check the selected printer or PDF output settings if the preview looks right but the final output does not. Printer drivers and print quality can affect fine details. On Mac, use the page layout or print settings available in that version of Excel and review the print preview before printing; some controls are arranged differently from Windows.

For a quick diagnosis, ask whether the issue occurs on screen, in Print Preview, or only on paper. Missing lines on screen point toward gridline visibility, cell formatting, zoom, or conditional formatting. Lines missing only from print output point toward gridline print settings, the print area, or output settings. Separating these cases avoids changing cell formatting when the problem is actually a print option.

Use a careful repair instead of clearing everything

If only a few cells are affected, selecting them and applying the intended border is usually the least disruptive fix. Avoid using Home > Editing > Clear > Clear Formats as a first step. Clear Formats removes more than borders: it can also remove fills, font formatting, number formats, and other appearance settings. If the cells contain dates, percentages, or carefully designed headings, that broad reset may create extra work.

For a larger range, first inspect a representative cell and identify whether the cause is a missing border, a matching color, conditional formatting, or a table style. Then apply a consistent border to the complete range. If the workbook is important, save a copy before making wide formatting changes. When a border should be consistent across many sheets, apply the same settings deliberately rather than copying cells blindly, because ordinary copying can also bring formulas, values, or other formats.

A useful practical sequence is:

  1. Confirm whether the missing lines are borders or gridlines.
  2. Check View gridline visibility and, for printing, the gridline Print option.
  3. Inspect a cell’s border preview, color, and line style in Format Cells.
  4. Review conditional formatting, table styles, hidden rows or columns, and sheet protection.
  5. Apply a visible border to the correct range and verify it in Print Preview if needed.

Frequently Asked Questions

Why do Excel gridlines disappear when I add a cell color? Gridlines are not borders, and Excel generally does not display them beneath cells with a fill color. Add explicit borders if you need lines around filled cells, or choose No Fill if the background color is unnecessary.

How do I make Excel borders show when printing? Apply actual cell borders from Home > Font > Borders. If you want worksheet gridlines instead, go to Page Layout > Sheet Options > Gridlines and select Print, then check Print Preview.

Why does a border look different from the one I selected? The color may blend into the fill, a neighboring cell may have different edge formatting, or conditional formatting or a table style may affect the appearance. Inspect Format Cells > Border and review applicable rules under Home > Conditional Formatting > Manage Rules.

Can I show gridlines on only one worksheet? Yes. Gridline visibility is controlled per worksheet. Activate the sheet and use View > Show > Gridlines. If you need printed gridlines, set the Print option for that sheet under Page Layout > Sheet Options.

Why can’t I change a cell’s border? The sheet may be protected, or the selected cells may be affected by formatting rules or a table style. Check Review for an Unprotect Sheet option and inspect conditional formatting. If protection requires a password, contact the workbook owner rather than trying to bypass it.

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.