Border Not Showing in Excel? Causes and Fixes

How-to basics · Updated November 21, 2026

If a border will not show up in Excel, select the affected cells and apply a visible line through Home > Borders; choose a line color other than the cell’s fill color if needed. If it still seems missing, check whether you are looking for a border or a gridline, and inspect formatting, hidden rows or columns, conditional formatting, and print settings.

First, identify what is missing

Excel displays two things that can look like cell borders: borders you add as formatting, and gridlines that mark cell boundaries on screen. They are controlled separately, so turning gridlines on will not restore a border you applied, and adding borders is not necessary just to see the worksheet’s normal grid.

Start by clicking one affected cell, then look at the Home tab’s Borders button in the Font group. Its icon previews the currently selected border setting. Open the arrow beside it and choose a specific edge or a complete outline. If the outline appears, the issue was likely that no border had been applied, or that the selected border option was not the one you expected.

For a quick diagnosis, ask whether the lines are missing only on screen, only in a particular range, or only on a printout. Lines missing everywhere may point to gridline display settings. Lines missing in selected cells often indicate formatting or conditional formatting. Lines missing only on paper or in a PDF call for a check of the print setup.

Borders and gridlines are different

Gridlines are the faint worksheet guides Excel displays around cells by default. They are a viewing aid, not cell formatting, and they are not printed by default. A border is a formatting choice attached to a cell edge; it can have a chosen color and line style, and it normally prints with the cell contents.

On Windows in Excel for Microsoft 365, show or hide worksheet gridlines using View > Show > Gridlines. The Page Layout tab also has a Sheet Options section with a Gridlines setting for View. The latter is useful when checking the print-related setting beside it: the Print checkbox controls whether gridlines are included on printouts. These controls do not remove or add cell borders.

If the gridlines are on but hard to see, a cell fill can make them disappear in that area. Gridlines are not shown through cells with a fill color, including a white fill. A white-filled cell with no border can therefore look like a blank patch. Add an actual border if you need a line that remains visible over colored fills or needs to print.

Apply a clear border to cells

To put a border around a range in Excel for Microsoft 365 on Windows:

  1. Select the cell or range. Drag across cells, or click the first cell and Shift-click the last cell.
  2. Go to Home and open the arrow beside Borders in the Font group.
  3. Choose an option such as Outside Borders for the range outline, All Borders for each cell edge, or Bottom Border for a line under the selection.
  4. If the line remains difficult to see, reopen the menu, choose Line Color, select a contrasting color, then choose the border placement again. Use Line Style first if you want a heavier or different style.

Outside Borders draws around the outside of the selected range; it does not put separators between every cell. All Borders draws internal lines as well as the outside edge. This distinction explains a common surprise: selecting a whole block and choosing Outside Borders creates a box, not a complete spreadsheet grid.

For more control, select the cells and press Ctrl+1 to open Format Cells, then use the Border tab. Choose a line style and color before clicking the preview edges you want, or select a preset such as Outline or Inside. The preview helps you see which edges are active before you accept the settings. In Excel for Mac, Command+1 opens Format Cells; ribbon labels and placement can differ slightly, but the Borders controls work similarly.

Check border color, style, and cell formatting

A border can be present but nearly invisible. For example, a white border on a white fill blends into the background, and a very thin pale line can be hard to distinguish at a low zoom level. In Format Cells > Border, inspect both the selected color and the line style. Choose a contrasting color and a solid line for a clear test. Once it appears, you can choose a subtler style if that suits the worksheet.

Also check whether the cells have a fill. Home > Fill Color shows the current fill choice, and the Borders menu controls the edges independently. Removing a fill can restore the appearance of gridlines, but it will not create a formatted border. Conversely, a border may remain visible when gridlines are hidden, because it is a separate format.

Be cautious with Home > Clear > Clear Formats. It removes formatting from the selected cells, including borders, number formats, fills, and font styling. If you use it to fix a broader formatting problem, you may also erase useful formatting. Undo immediately with Ctrl+Z if you clear the wrong range; on Mac, use Command+Z.

Look for hidden rows, columns, or merged cells

A border needs a visible cell edge to display. If a row or column is hidden, or its height or width has been reduced to zero, borders on its cells may be concealed along with the cells themselves. Select the row or column headers on either side of the hidden area, right-click, and choose Unhide. You can also use Home > Format to access row-height and column-width controls.

Merged cells can make border placement confusing because several original cells behave as one larger display area. Select the merged area and inspect the border preview in Format Cells rather than assuming each underlying cell edge will be visible. If you need a border between the original cells, unmerge the range using Home > Merge & Center > Unmerge Cells, then apply the desired borders. Unmerging can change how the contents are arranged, so check the data before doing it.

When a border seems to vanish at one edge of a selected range, click a neighboring cell and inspect the boundary again. The edge may belong to the adjacent cell, whose border formatting controls how that shared boundary appears. Selecting both cells and applying the intended border can clarify which edge you are formatting.

Check conditional formatting and table styles

Conditional formatting can change a cell’s appearance when a rule is true, including its border formatting. If a border is present only at certain times, or changes when a value changes, select the cell and open Home > Conditional Formatting > Manage Rules. In the rules manager, review which rules apply to the selected range and whether their conditions are currently met. Edit or remove a rule only if you understand what it is meant to do; a rule may be deliberately highlighting exceptions.

When conditional formatting applies a border, that conditional format can take precedence over a manually applied border for the same cell attribute while the condition is active. A practical test is to temporarily change the cell value so the condition is false, or inspect the rule’s format in the manager. Do not assume the manual border failed until you have checked for an active rule.

Excel tables also have built-in styles that affect their appearance. If a range is a table, its banding and visual edges may come from the table style rather than individual cell borders. Click inside the table and review the Table Design tab’s style options. A table style may make edges appear subtle, but it is not the same as a border that you set through the Home tab.

Why borders may not show when printing

If borders appear in the worksheet but not on paper or in a PDF, first check Print Preview using File > Print. Confirm that the correct worksheet or selection is being printed and that the scale, margins, and page breaks include the cells in question. A border beyond the selected print area or outside the page can be absent from the output even though it remains in the workbook.

For actual borders, make sure they have a visible color and are not extremely thin. For gridlines, use Page Layout > Sheet Options > Gridlines > Print on Windows. The gridline print setting is separate from the View checkbox, so seeing gridlines on screen does not prove they will print. If you need a reliable outline in a report, use cell borders rather than relying on printed gridlines.

On Mac, Excel has equivalent page setup and print options, though the ribbon layout and dialog placement can vary by release. Check the sheet’s gridline print option and review the print preview before producing multiple copies. Excel for the web also offers worksheet formatting and print preview, but some page setup controls may be more limited than in the desktop app; if a print option is unavailable, open the workbook in desktop Excel.

Display glitches and practical checks

Sometimes a thin border is difficult to see at a particular zoom level or on a high-resolution display. Change the zoom temporarily, or use Print Preview to check whether the line is actually present. If the border appears at another zoom or in preview, the formatting may be fine and the problem may be how the worksheet is being rendered on screen.

It is also worth checking that the worksheet is not protected. Protection can restrict formatting changes depending on the permissions set by the workbook’s owner. On Windows, review Review > Protect Sheet. If the sheet is protected, you may need the password or permission from its owner to change cell formatting. Do not remove protection or overwrite the workbook if it contains controls you are expected to preserve.

A safe troubleshooting sequence is to test a single empty cell in an unused area: apply a dark, solid Outside Border, then inspect it at a normal zoom and in Print Preview. If that works, the problem is specific to the original range or its rules. If it does not, check the selected worksheet, display settings, protection, and application version before changing large amounts of formatting.

Frequently Asked Questions

Why do Excel gridlines disappear when I add a fill color?
Gridlines are not displayed through filled cells, even when the fill looks white. Apply cell borders if you need visible lines over a fill or need the lines to print.

Why is my Excel border visible on screen but not printing?
Check Print Preview, the print area, and the border’s color and line style. If you are relying on gridlines rather than borders, enable Page Layout > Sheet Options > Gridlines > Print in Windows Excel.

How do I put lines between every cell in a selected range?
Select the range, then choose Home > Borders > All Borders. Outside Borders only outlines the range and does not add internal separators.

Can conditional formatting remove a border I added manually?
An active conditional formatting rule can control the border appearance for the cells it affects. Review Home > Conditional Formatting > Manage Rules and inspect the rule’s format and range.

Why does a border disappear when I hide a row or column?
The border is attached to cells in the hidden area, so the edge may be hidden with them. Unhide the row or column, or adjust its height or width, to make its cells and borders visible again.

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.