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 missing | Fix | Where |
|---|---|---|
| Gridlines on every cell | Check Gridlines | View tab, Show group |
| Gridlines in some cells only | Set the fill to No Fill | Home > Font > Fill Color |
| Formula bar | Select Show formula bar | File > Options > Advanced |
| Ribbon, formula bar and status bar together | Leave full screen view | Ctrl+Shift+F1 |
| Gridline color is too faint | Change Gridline color | File > Options > Advanced |
Show gridlines from the View tab
This is the quickest fix when the whole sheet looks blank.
- Select the worksheet whose gridlines are hidden.
- Go to the View tab.
- 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.
- Select File, then Options.
- Choose Advanced.
- Find Display options for this worksheet and pick the worksheet in the list box.
- Make sure Show gridlines is checked.
- 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.
- Select the cells.
- Go to Home and open the Fill Color drop-down in the Font group.
- 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.
- Select File, then Options.
- Choose Advanced.
- In the Display area, select Show formula bar.
- 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 choice | What it does |
|---|---|
| Full-screen mode | Hides the ribbon until you select the ellipsis (…) or press Alt |
| Show tabs only | Shows only the ribbon tabs |
| Always show Ribbon | Keeps 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.
| Option | What it shows |
|---|---|
| Show row and column headers | Row numbers and column letters |
| Show horizontal scroll bar | The scroll bar along the bottom |
| Show vertical scroll bar | The scroll bar at the side |
| Show sheet tabs | Worksheet 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.
Related Excel fixes
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.