If an Excel cell outline is not showing, first identify which outline is missing: gridlines, a formatted cell border, or the border around the active selection. In Excel for Microsoft 365 on Windows, turn gridlines on at View > Show > Gridlines; for a real cell border, select the cells and choose Home > Font > Borders. The active selection outline is different and needs separate troubleshooting.
Identify which cell outline is missing
Excel has three visual features that people commonly call a cell outline. They can look similar in a worksheet, but they work differently and have different fixes:
- Gridlines are the faint lines that divide cells across an otherwise unformatted worksheet. They are a viewing aid, not cell formatting.
- Borders are formatting applied to particular cells, such as a solid line around a heading or table. They can have different colors, weights, and styles.
- The selection outline marks the active cell or selected range. In the standard Windows theme, it is usually green. It appears when you select cells and is not a printable cell border.
Look at the worksheet to narrow down the cause. If lines are missing across a large blank area, check gridlines. If only a particular range lacks an edge, check its border formatting and fill. If no obvious outline appears around the cell you click, focus on selection visibility, editing mode, or a display refresh issue.
Turn worksheet gridlines back on
For Excel for Microsoft 365 on Windows, open the View tab and, in the Show group, select Gridlines. This setting applies to the current worksheet, so repeat it on any other sheet where gridlines are absent. You can also find the sheet-specific display setting at File > Options > Advanced. Under Display options for this worksheet, check Show gridlines for the selected sheet.
Excel for Mac and Excel for the web also provide a Gridlines control on the View tab, though the ribbon layout can differ. In the web app, confirm that you are changing the view for the sheet you are looking at, rather than assuming a change on one sheet affects the entire workbook.
Gridlines can be enabled but difficult to see if their color blends into the sheet. In Windows desktop Excel, go to File > Options > Advanced, select the relevant sheet under Display options for this worksheet, and inspect Gridline color. Choose a contrasting color or return to the default. A different gridline color changes the worksheet display; it does not add printed borders to cells.
Why gridlines disappear in only some cells
Gridlines are not drawn over cells that have a fill color applied. This can make a range appear to have lost its outline even while gridlines are turned on for the worksheet. A white fill can cause the same effect as a colored fill: it is still a fill, so the default gridline may be hidden. This often happens after cells are formatted to make a report look clean or after formatting is copied from another range.
To check, select an affected cell and look at the Fill Color control in Home > Font. Choose No Fill if you want the ordinary worksheet gridlines to show through. Be cautious with Clear Formats: it removes other formatting, such as number formats, font choices, and borders, as well as fill. If you need to preserve the rest of the formatting, change only the fill.
For a visible outline that should remain clear regardless of fill, apply a border rather than relying on gridlines. For example, a colored heading with a bottom line needs a formatted border if that line must stay visible. Gridlines help you navigate a sheet; they are not a substitute for deliberate table formatting.
Add or restore an actual cell border
Select the cells, then use Home > Font > Borders and choose the border arrangement you need, such as Outside Borders or All Borders. The Borders button may show a small border icon; use its dropdown arrow to see the available choices. For a custom line, open More Borders from that menu, then select a line style, color, and the edges to apply in the Format Cells dialog.
Be precise about the range. Outside Borders draws an edge around the whole selected range, whereas All Borders also draws lines between its cells. If you select a single cell, these choices affect that cell; selecting a block of cells produces a different layout. If a border seems absent, inspect the line color and weight too: a white or very thin line on a white background may be hard to distinguish.
To remove a border, select the cells and choose No Border from the Borders menu. That is not the same as turning off gridlines. A cell can have no explicit border and still show the worksheet gridline, provided gridlines are enabled and the cell has no fill.
When the active selection outline is missing
The selection outline is not controlled by the worksheet Gridlines checkbox. First click a cell once and check whether Excel is still editing its contents. If the insertion point is inside the cell or formula bar, press Enter to accept the edit or Esc to cancel it, then select the cell again. While editing a value or formula, Excel is focused on the text rather than on making a new selection.
Next, click a different cell and return to the original one. If a range is selected, click a single cell so you can tell which cell is active. A selected range may show shading as well as an outline, and existing cell fill can make the shading less obvious. The active-cell border should still be distinct in a normal display, but a very high zoom level, low contrast, or display scaling can make it harder to notice.
Also check whether Excel is responding to a click. If the sheet is protected, protection settings may limit which cells can be selected. A protected sheet does not simply turn off the selection outline, but it can prevent selection of certain cells and make it seem as though the click did not work. Try a permitted cell or ask the workbook owner whether selection is restricted.
Check workbook view and display issues
Some apparent outline problems are really a view or rendering issue. Switch to another worksheet and back, change the zoom slightly, or minimize and restore the Excel window. Save the workbook, close it, and reopen it if the display still appears stale. These steps can refresh what Excel draws without changing cell formatting.
If the issue affects multiple workbooks, check whether it is limited to one Excel session or computer. Install available Microsoft 365 updates through File > Account > Update Options > Update Now in Windows desktop Excel; organization-managed installations may have a different update process. You can also start Excel in Safe Mode by holding Ctrl while launching the app and confirming the prompt, then see whether the outline appears. If it does, an add-in or customization may be involved. Disable add-ins one at a time using File > Options > Add-ins to identify a possible cause.
Workbook content can also affect what you see without removing the selection itself. For example, a chart, shape, or dialog may be covering part of the sheet, or a frozen pane may make it less obvious which area is active. Click an unobstructed cell and verify the active sheet before changing formatting. Avoid deleting objects or clearing formatting just to fix a selection outline; those actions can alter workbook content without addressing the display problem.
Do you need the outline to print?
The active selection outline is only a screen indicator and does not print. Worksheet gridlines also do not print by default. If you want a worksheet’s gridlines on paper, open the Page Layout tab and, under Sheet Options, select Print in the Gridlines section. Check Print Preview because page setup, print area, and scaling determine what actually appears on the printed pages.
For a polished report, formatted borders are often more predictable than printed gridlines. Borders let you emphasize selected edges and tables instead of printing a faint grid across every cell. To make an edge visible both on screen and on paper, apply a border with a contrasting color and suitable line weight. If a cell has a fill, do not expect the worksheet gridline to show through it; add a border where the line is needed.
Frequently Asked Questions
Why are gridlines missing in Excel even though they are turned on?
Check whether the affected cells have a fill color, including white fill, because fills hide gridlines. Also verify the gridline color and the Show gridlines setting for that specific worksheet.
How do I make Excel cell lines visible again?
If you mean ordinary worksheet lines, select View > Show > Gridlines. If you need lines around a particular range, select it and use Home > Font > Borders instead.
Why does my selected cell not have a green outline?
Confirm Excel is not editing a cell, then click a different cell and back. If the problem continues, refresh the window, reopen the workbook, and check whether it happens in another workbook or Excel session.
Do Excel gridlines print?
Not by default. Turn on Print under Page Layout > Sheet Options > Gridlines if you want them on paper, or add formatted borders for more controlled results.
Are gridlines and borders the same thing?
No. Gridlines are worksheet display guides, while borders are formatting applied to selected cells. Borders can be customized and are suitable for emphasizing cells; gridlines are controlled as a sheet view and are not automatically printed.
Will clearing formatting restore missing gridlines?
It may remove a fill that is hiding gridlines, but it also removes other formatting. If you want to keep number formats, fonts, and borders, change the affected cells to No Fill instead.
Related
- Append Queries in Power Query: How to Combine Tables
- Power Query Editor: What It Is, How It Works, and Why
- Excel Data Validation Icon: What It Looks Like and Does
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel #N/A Error: What It Means and How to Fix It QuicklyIn Excel, the #N/A error means that a formula cannot find a value it needs, most often because…
- Excel Dropdown List Error? Causes and FixesAn Excel dropdown list error usually comes from a missing or incorrect Data Validation source, a disabled in-cell…
- Excel Not Getting Data? Fix Queries, Imports, and LinksIf Excel is not getting data, first open the Data tab and select Refresh All; then check that…
- Date Format in Excel: How to Fix It (Step by Step)To fix a date that displays incorrectly in Excel for Microsoft 365 on Windows, select the date cells,…
- VLOOKUP Not Working With Leading Zeros? Here’s WhyVLOOKUP often fails with leading zeros because Excel may store one lookup key as text, such as “00123,”…
- Excel Consolidate Not Working? Fix Common CausesIf Excel Consolidate is not working, check that you selected a blank destination cell, added every source range…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.