How To Show The Formula Bar And Gridlines In Excel (2026)

If the formula bar or the cell gridlines have vanished from your Excel worksheet, a display setting was switched off and you can turn it back on.

Gridlines are a worksheet setting and the formula bar is an Excel display option, so each has its own fix.

The steps below follow Microsoft’s support pages and cover the less obvious causes, such as cell fill colors and full screen view.

Quick answer: what to turn on

Find your symptom in the table.

What is missingFixWhere
Gridlines on every cellCheck GridlinesView tab, Show group
Gridlines in some cells onlySet the fill to No FillHome > Font > Fill Color
Formula barSelect Show formula barFile > Options > Advanced
Ribbon, formula bar and status bar togetherLeave full screen viewCtrl+Shift+F1
Gridline color is too faintChange Gridline colorFile > Options > Advanced

Show gridlines from the View tab

This is the quickest fix when the whole sheet looks blank.

  1. Select the worksheet whose gridlines are hidden.
  2. Go to the View tab.
  3. In the Show group, select the Gridlines check box.

Microsoft says you can select several worksheets at once with the sheet tabs, and the title bar then shows Group.

Gridlines apply to the whole worksheet, and you cannot apply them to specific cells or ranges.

Show gridlines in Excel Options

The same setting is in Excel Options, along with the gridline color.

  1. Select File, then Options.
  2. Choose Advanced.
  3. Find Display options for this worksheet and pick the worksheet in the list box.
  4. Make sure Show gridlines is checked.
  5. Select OK.

Because this is a per-worksheet option, each sheet in a workbook can differ.

Gridlines missing in some cells only

If gridlines show in most of the sheet but not in certain cells, a fill color is the usual cause.

Microsoft says cells with a fill color do not show or print gridlines.

  1. Select the cells.
  2. Go to Home and open the Fill Color drop-down in the Font group.
  3. Choose No Fill.

Microsoft adds that changing the fill to white does not work, because the gridlines stay hidden.

To keep a fill and still separate cells, use borders instead.

Change the gridline color

Gridlines can be there but too light to see.

In File > Options > Advanced, under Display options for this worksheet, use the Gridline color box.

Microsoft says the Automatic setting uses the text color defined in Windows Control Panel.

Select Automatic to return to the default.

The setting applies only to the worksheets you selected.

Show the formula bar

The formula bar is controlled by an option in the Excel Options Display settings.

  1. Select File, then Options.
  2. Choose Advanced.
  3. In the Display area, select Show formula bar.
  4. Select OK.

Microsoft describes this option as showing or hiding the formula bar at the top of the worksheet.

Check for full screen view

If the ribbon, formula bar and status bar are all gone at once, full screen view may be on.

Microsoft says Ctrl+Shift+F1 turns full screen view on and off, and that it hides the ribbon, the formula bar and the status bar.

Press the same shortcut again to return to normal view.

Microsoft’s page also carries a note that Full screen is not available in Excel 2013 and later, so if the shortcut does nothing, use the ribbon steps below.

Bring back a hidden ribbon

If tabs such as View are not visible, show the ribbon first.

Select the ellipsis (…) at the top right to bring it back temporarily.

Then open Ribbon Display Options and choose Always show Ribbon.

Ribbon Display Options choiceWhat it does
Full-screen modeHides the ribbon until you select the ellipsis (…) or press Alt
Show tabs onlyShows only the ribbon tabs
Always show RibbonKeeps all tabs and commands visible

Right-clicking a ribbon tab and clearing Collapse the ribbon also expands a collapsed ribbon.

Other display options on the same page

While you are in the Advanced Display settings, you can check related items.

OptionWhat it shows
Show row and column headersRow numbers and column letters
Show horizontal scroll barThe scroll bar along the bottom
Show vertical scroll barThe scroll bar at the side
Show sheet tabsWorksheet tabs at the bottom of the window

Row and column headers and gridlines are worksheet options, while the scroll bars and sheet tabs are workbook options.

Gridlines on screen but not on paper

Gridlines do not print by default, even when they show on screen.

Go to Page Layout > Sheet Options > Gridlines and select Print.

Our guide to printing gridlines and headings in Excel covers it in more detail.

Gridlines changed on several sheets at once

If your gridline change seems to affect many worksheets, you may have grouped sheets.

Microsoft says the title bar shows Group when several worksheets are selected.

To ungroup, click any unselected sheet, or right-click a selected sheet tab and choose Ungroup Sheets.

Make cells easier to see with borders

Gridlines are the same for the whole sheet, so they cannot outline specific cells.

For selective lines, select the cells and use the Border button in the Font group on the Home tab.

Microsoft recommends borders when you want to keep a fill color and still separate the cells.

Which Excel versions these steps cover

Microsoft’s gridlines article applies to Excel for Microsoft 365 on Windows, Mac and the web, plus Excel 2024, 2021, 2019 and 2016, and Excel for iPhone.

Its page has separate macOS and web tabs, so check the live page for the exact Mac or browser menus.

If the whole window opens blank or grey, see how to fix Excel opening to a blank screen.

To keep your headings visible while scrolling, see how to freeze rows and columns.

For crashes or odd behavior across Office, repair Microsoft 365 apps.

Sources: Microsoft: Show or hide gridlines on a worksheet, Microsoft: Excel Advanced options, Microsoft: Switch to full or normal screen view in Excel, Microsoft: Show or hide the ribbon in Office.

Leave a Reply

Your email address will not be published. Required fields are marked *