Excel Borders Not Showing? Causes, Checks, and Fixes

How-to basics · Updated November 21, 2026

If a border is not showing in Excel, select the affected cells and reapply a visible border from Home > Borders; if you mean the faint worksheet grid, turn on View > Gridlines instead. Borders and gridlines are different, so first identify which one is missing, then check fill color, border formatting, conditional formatting, and display or print settings.

Borders and gridlines are not the same

Excel gridlines are the light lines that outline cells by default. They help you read a worksheet but are not cell formatting. Cell borders are formatting that you add deliberately, such as a thick outline around a report total or a line beneath a heading. A border can be changed, colored, and printed as part of the cell formatting; gridlines have fewer appearance options and are not printed by default.

This difference explains a common puzzle: a cell can have no visible gridline and still have no border. It can also have a border even when gridlines are switched off. If lines have disappeared throughout a worksheet, check the gridline setting. If only particular cells or a particular range are affected, inspect their borders and fills.

  • Gridlines missing across a sheet: check the View tab’s Gridlines option and whether cells have a fill color.
  • Only selected cells missing an edge: apply or inspect the cell border formatting.
  • Lines visible on screen but absent on paper or in a PDF: check print settings and Print Preview.

Apply a visible border to cells

In Excel for Microsoft 365 on Windows, select the cells, open Home > Font > Borders, and choose the edge or preset you need. For example, choose Outside Borders to outline a selected block, or All Borders to draw lines around every cell in it. The small Borders button may show the last-used border; use its dropdown arrow to see the choices.

For more control, open the Borders dropdown and choose More Borders. In the Format Cells dialog, select a line style and color, then click the border positions in the preview before choosing OK. The preview matters: selecting a line style alone does not put a line on the cell. Check the top, bottom, left, right, and interior positions you actually want.

You can also open Format Cells with Ctrl+1 on Windows, then use the Border tab. In Excel for Mac, Command+1 opens Format Cells; the Home tab also has a Borders control. Excel for the web provides common border choices on the Home tab, although its formatting dialogs and controls may differ from the desktop app.

If an existing border is hard to see, select the cells and revisit More Borders. A white or very pale line on a white background can look absent, while a thin line may be difficult to distinguish at some zoom levels. Choose a contrasting color and a suitable line weight, then inspect the worksheet at a normal zoom. If you want to remove a border, use Home > Borders > No Border; note that this removes cell borders, not gridlines.

Check fill color and gridline settings

Worksheet gridlines generally do not show through cells that have a fill color, including a white fill. The fill may look identical to the sheet background, so it can seem as though gridlines vanished for no reason. To test this, select an affected cell and use Home > Fill Color > No Fill. If the gridlines return, the fill was hiding them. This does not mean the cell has a border.

To show or hide gridlines for the current worksheet in desktop Excel for Windows, go to View > Show and select or clear Gridlines. You can also use Page Layout > Sheet Options > Gridlines > View. The setting is worksheet-specific, so check the tab where the problem occurs; turning gridlines on for one sheet does not necessarily change every sheet in the workbook. Excel for Mac has a Gridlines control on the View tab, though the ribbon layout can vary by release. In Excel for the web, use the View tab’s gridlines option when available.

On Windows, the gridline color can be changed under File > Options > Advanced, in Display options for this worksheet. Choose the worksheet in the dropdown if needed, then inspect the gridline color setting. This setting affects gridlines, not borders. If you choose a color close to the worksheet background, the lines may be technically enabled but difficult to notice.

Look for conditional formatting or styles

Conditional formatting can apply a border only when a rule is true, such as outlining overdue dates or highlighting values above a threshold. If the border appears for some rows but not others, the rule’s condition may explain the difference. Select an affected cell and go to Home > Conditional Formatting > Manage Rules. In the rules window, check which rules apply to the selection or worksheet, their ranges, and whether their formatting includes a border.

A rule may also cover a larger or different range than intended. For example, a rule written for one column but applied to the whole table can produce unexpected borders. Review the Applies to range and the rule’s formatting preview. If multiple rules overlap, their order and the Stop If True setting can affect which formats are applied. Edit or remove a rule only if you understand what it is meant to do; deleting a rule can alter other visual cues as well.

Cell styles and table formatting can make borders look inconsistent, especially after copying cells from another workbook. Select a cell and inspect the Borders dropdown or Format Cells dialog to see its actual border settings. For a table, the Table Design style may supply banding and emphasized header or total rows; that appearance is not always the same as manually assigned borders. Changing the style can change the table’s appearance, so check whether the line is a style effect before applying a new format.

Check for hidden, faint, or misplaced edges

Sometimes a border is present but is not where you expect. A bottom border belongs to the bottom edge of a cell, while a top border belongs to the cell below it. When rows or columns are hidden, or when a range has merged cells, the displayed outline may not match the mental picture of a regular grid. Unhide the relevant rows or columns temporarily and inspect the edge positions in Format Cells > Border.

Verify that you selected the intended range before applying formatting. If you select a block and choose Outside Borders, Excel outlines the block but does not draw internal separators; choose All Borders when every cell needs its own outline. Conversely, All Borders may add more lines than a report needs. For a single missing edge, select the cells along that edge and apply only the relevant top, bottom, left, or right border.

Copied formatting can also produce an unexpected result. Pasting cells from another sheet or workbook may bring along border color, line style, fill, or conditional formatting. If the issue began after a paste, use Undo immediately if appropriate, or compare the affected cell’s Format Cells settings with a nearby cell that looks right. Avoid using Clear All as a first fix: it removes more than borders, including contents and other formatting.

Separate worksheet display from printing

A line missing from a printout may be a gridline rather than a border. Gridlines do not print by default. To print them in Excel for Windows, go to Page Layout > Sheet Options > Gridlines and select Print. This setting is separate from the View checkbox: a sheet can show gridlines on screen without printing them, or be set to print them while the on-screen display is different.

For a more controlled report, use actual borders around the cells instead of relying on printed gridlines. Borders are part of cell formatting and normally print, subject to the selected print area, scaling, and printer or PDF output. Open File > Print and review the preview before producing the final copy. If the border is missing there, check whether the cells are included in the print area and whether the border color is too faint. A very thin pale line may be hard to see on paper even if it is visible on screen.

Excel for Mac also separates worksheet display from print behavior; check Page Layout and the print preview in the version you use. Excel for the web has fewer page-layout controls than desktop Excel, so if a workbook’s print settings are not available in the browser, open it in the desktop application and inspect the preview there.

Use a quick diagnostic sequence

When the cause is unclear, try these checks in order. They distinguish the most common issues without wiping out unrelated formatting:

  1. Decide whether the missing lines are gridlines across the sheet or borders around specific cells.
  2. If gridlines are missing, confirm View > Gridlines is selected and test whether the cells have a fill color.
  3. If cell edges are missing, select the exact range and inspect Home > Borders > More Borders for line style, color, and edge positions.
  4. Check Home > Conditional Formatting > Manage Rules if the appearance varies by row, value, or date.
  5. Look for merged cells, hidden rows or columns, table styles, or formatting brought in by a paste.
  6. If the problem is in a printout, review Page Layout settings and File > Print preview rather than relying on the worksheet view.

If several cells in the same range are affected, compare one problem cell with a nearby cell that displays correctly. This is often faster than changing the whole sheet. Once you identify the cause, make a targeted change: remove a fill to restore gridlines, change a border color, adjust a rule’s range, or enable printing of gridlines. Save a copy before making broad formatting changes to a workbook that others rely on.

Frequently Asked Questions

Why did my Excel gridlines disappear after I colored cells?

Gridlines are hidden by cell fills, even when the fill is white and looks like the worksheet background. Select the cells and choose Home > Fill Color > No Fill to test. If you need the cells to keep their fill, add actual borders instead.

Why are borders visible in Excel but not when I print?

First distinguish borders from gridlines: gridlines are not printed unless you enable Page Layout > Sheet Options > Gridlines > Print. Actual borders should print, but a pale color, very thin line, excluded print area, or print scaling can make them difficult to see. Check File > Print preview.

How do I show borders around every cell in a range?

Select the range, then choose Home > Borders > All Borders. This adds interior lines as well as the outside outline. Choose Outside Borders if you only want a frame around the whole selection.

Why does only one row or cell lose its border?

Check whether conditional formatting applies a border only when a rule is met, whether the affected cell has different formatting, and whether the selection includes the intended cells. Merged cells or hidden rows can also make an edge appear misplaced. Manage Rules and Format Cells > Border help identify the source.

Can I restore gridlines without removing my cell colors?

Not inside filled cells: gridlines are not drawn over a fill. Keep the fill and apply borders in a contrasting color, or remove the fill if gridlines are sufficient. Borders are the better choice when a worksheet needs consistent visible lines and colored cells.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.