Excel without gridlines can feel like a city map with all the streets erased. The data is technically still there, but your eyes suddenly have to do Olympic-level gymnastics just to follow a row. Fortunately, learning how to show gridlines in Microsoft Excel is quick, simple, and surprisingly useful whether you are building a budget, cleaning a sales report, preparing a classroom worksheet, or trying to make sense of a spreadsheet someone named “Final_FINAL_v7.xlsx.”
Gridlines are the faint lines that separate cells on an Excel worksheet. They help you see where one cell ends and another begins. By default, Excel usually displays them on screen, but they can disappear if someone turns them off, changes worksheet settings, applies cell fill color, changes the gridline color, or prepares the sheet for printing. The good news: you do not need to be an Excel wizard with a cape made of pivot tables. You only need to know where to click.
In this guide, you will learn three simple ways to show gridlines in Excel, plus how to troubleshoot missing gridlines, how to print gridlines, and when to use cell borders instead. The steps apply broadly to Microsoft Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel for the web, and similar modern versions.
What Are Gridlines in Excel?
Gridlines are the light gray lines that appear around worksheet cells. They are not the same as borders. This is one of the most common Excel misunderstandings, right up there with “Why did my formula become a tiny novel?”
Gridlines are visual guides. They appear across the worksheet to help users read rows and columns more easily. Borders, on the other hand, are formatting elements you apply manually to selected cells. Borders can be customized with different colors, thicknesses, and styles. Gridlines are simpler: they are worksheet-level display lines that help you navigate your spreadsheet.
Gridlines vs. Borders: The Quick Difference
Gridlines appear automatically across a worksheet when enabled. They help you see cell boundaries but are not usually printed unless you turn on the print option.
Borders are formatting choices you add to specific cells or ranges. They print by default, stay visible even when cells have fill color, and can be styled for professional reports.
Think of gridlines as the pencil sketch behind your worksheet and borders as the ink you add when the document needs to look polished.
Why Excel Gridlines Disappear
Before fixing missing gridlines, it helps to understand why they vanish. In most cases, Excel is not broken. It is just obeying a setting, even if that setting has the personality of a prankster.
- The Gridlines checkbox is turned off on the View tab.
- The Gridlines View option is unchecked on the Page Layout tab.
- Cells have a white or colored fill applied, which hides default gridlines.
- The gridline color has been changed to white or another hard-to-see color.
- You are looking at printed output, where gridlines do not appear by default.
- You selected a chart, image, or object, making some worksheet options temporarily unavailable.
The solution depends on the cause. Let’s walk through the three easiest ways to show gridlines in Microsoft Excel.
Method 1: Show Gridlines from the View Tab
The fastest way to show gridlines in Excel is through the View tab. This is the method most users should try first because it takes only a few seconds.
Steps to Show Gridlines Using the View Tab
- Open your Excel workbook.
- Select the worksheet where the gridlines are missing.
- Go to the View tab on the Ribbon.
- Look for the Show group.
- Check the box labeled Gridlines.
Once the box is checked, the faint cell lines should immediately reappear. No restart, no secret Excel handshake, no dramatic music required.
When This Method Works Best
This method is perfect when gridlines are missing from the entire worksheet. If someone accidentally turned them off, the View tab restores them instantly. It also works well when you are reviewing data and need more visual structure.
If the Gridlines box is already checked but the lines still do not appear, the issue is probably not the View setting. In that case, jump to Method 3, because the cells may have fill color or the gridline color may have been changed.
Method 2: Show Gridlines from the Page Layout Tab
Another simple way to display gridlines is through the Page Layout tab. This area controls how your worksheet appears on screen and how it behaves when printed. It is especially helpful because it gives you separate options for viewing and printing gridlines.
Steps to Show Gridlines Using Page Layout
- Open the worksheet where gridlines are missing.
- Click the Page Layout tab.
- Find the Sheet Options group.
- Under Gridlines, check the View box.
This will show gridlines on the worksheet. If you also want gridlines to appear when printing, check the Print box under Gridlines as well.
How to Print Gridlines in Excel
By default, Excel gridlines do not print. This surprises many users because the lines are visible on screen, so it feels logical that they should appear on paper too. Excel, however, likes to keep us humble.
To print gridlines:
- Go to the Page Layout tab.
- In the Sheet Options group, find Gridlines.
- Check the Print box.
- Press Ctrl + P or go to File > Print.
- Check the print preview before printing.
Gridlines usually print around cells that contain data. If you want gridlines around empty cells too, you may need to set a print area that includes those blank cells or apply borders to the range.
What If the Gridlines Print Option Is Dimmed?
If the Gridlines options are unavailable or dimmed, make sure you do not have a chart, image, shape, or other object selected. Click any normal cell in the worksheet, then try again. Excel often disables sheet options while an object is selected.
Method 3: Fix Hidden Gridlines Caused by Fill Color or Settings
If the View and Page Layout settings are turned on but gridlines are still missing, the problem is often cell formatting. This is especially common when a worksheet has been styled with white fill, colored backgrounds, pasted formatting, or imported data.
Remove Cell Fill Color to Restore Gridlines
Excel gridlines may disappear when cells have a fill color. Even white fill can hide gridlines because Excel treats it as a background color. The result looks like the gridlines vanished, but they are actually being covered by formatting.
To remove fill color:
- Select the affected cells.
- To select the whole worksheet, click the triangle button in the top-left corner between row numbers and column letters.
- Go to the Home tab.
- In the Font group, open the Fill Color dropdown.
- Choose No Fill.
The gridlines should appear again if fill color was the problem. If you still need colored cells but want visible lines, use cell borders. Borders remain visible over fill colors and give you more control.
Check the Gridline Color
Sometimes gridlines are technically turned on but nearly invisible because the gridline color has been changed. If someone set the gridline color to white, the worksheet may look blank even though the setting is enabled.
To check or change gridline color in Excel for Windows:
- Click File.
- Select Options.
- Choose Advanced.
- Scroll to Display options for this worksheet.
- Make sure Show gridlines is checked.
- Open the Gridline color dropdown.
- Choose Automatic or a visible color.
- Click OK.
This setting applies to the selected worksheet. If several sheets have missing gridlines, you may need to repeat the process for each sheet.
Use Borders When Gridlines Are Not Enough
If you are preparing a report, invoice, schedule, checklist, or printable table, gridlines may not be the best choice. They are helpful for editing, but borders are better for presentation.
To add borders:
- Select the cells you want to format.
- Go to the Home tab.
- Open the Borders dropdown in the Font group.
- Choose All Borders, Outside Borders, or another border style.
Use borders when you need lines to print reliably, appear over colored cells, or create a professional layout. Use gridlines when you simply need worksheet visibility while editing.
How to Show Gridlines in Excel for the Web
Excel for the web also lets you show or hide gridlines. The steps are similar to the desktop version:
- Open your workbook in Excel for the web.
- Select the worksheet.
- Go to the View tab.
- Check Gridlines to show them.
One important note: printing gridlines works differently in Excel for the web than in desktop Excel. If you need reliable printed lines from a web-based workbook, applying borders to the selected range is often the better approach.
How to Show Gridlines in Excel on Mac
On Excel for Mac, the process is also straightforward. Go to the View tab and check Gridlines. You may also find gridline-related options on the layout controls depending on your Excel version.
If gridlines still do not appear on Mac, check for cell fill color, remove the fill, or apply borders where needed. The same basic rule applies: fill color can cover gridlines, while borders remain visible.
Common Problems and Quick Fixes
Problem: Gridlines Are Missing Only in One Section
If gridlines disappear in only one area of the worksheet, that range probably has fill color applied. Select the affected range and choose Home > Fill Color > No Fill.
Problem: Gridlines Are Missing from the Whole Sheet
Check View > Gridlines. Then check Page Layout > Sheet Options > Gridlines > View. If both are on, check the gridline color under Excel Options.
Problem: Gridlines Show on Screen but Not When Printed
Go to Page Layout and check Print under Gridlines. Then use Print Preview to confirm. If lines still do not print, use borders around the range instead.
Problem: Gridlines Are Too Light
You can change the gridline color in Excel Options. However, for final documents, borders are usually better because they give you stronger control over color and thickness.
Problem: Gridlines Disappear After Copying Data
Copied data often brings formatting with it, including fill colors. Use Paste Special or clear formatting if the copied range makes gridlines vanish.
Best Practices for Working with Excel Gridlines
Gridlines are useful, but they should not do every job. A clean spreadsheet uses the right visual tool for the right purpose. Use gridlines when editing raw data, checking formulas, comparing rows, or building a draft worksheet. Use borders when creating final documents, printed reports, dashboards, templates, or client-facing spreadsheets.
If you are designing a professional worksheet, consider turning off gridlines in areas where you have custom formatting. This can make dashboards and reports look cleaner. For example, a financial summary with carefully applied borders, bold headers, and subtle fill colors often looks more polished without default gridlines in the background.
On the other hand, if you are reviewing large data sets, gridlines help prevent mistakes. They make it easier to track values across rows and columns, especially when the sheet has many numbers. In everyday Excel work, gridlines are like lane markings on a road. You do not always notice them, but the moment they disappear, things get weird fast.
Example: Restoring Gridlines in a Budget Spreadsheet
Imagine you open a monthly budget spreadsheet and the entire worksheet looks like a blank white page with numbers floating in space. You need to compare rent, groceries, utilities, and savings, but without gridlines, the rows are hard to follow.
First, you check View > Gridlines. The box is already checked. That means the issue is probably formatting. Next, you select the entire worksheet and choose Home > Fill Color > No Fill. Suddenly, the gridlines return. What happened? Someone applied white fill to the entire sheet, which covered the gridlines. The fix took less than a minute.
Now suppose you want to print the budget for a meeting. The gridlines show on screen, but not in print preview. You go to Page Layout, check Print under Gridlines, and preview again. If the printout still does not look clear enough, you select the budget table and apply All Borders. Now the printed version is readable and meeting-ready.
Example: Showing Gridlines in a Shared Team File
Shared workbooks can become formatting jungles. One person adds color, another removes borders, someone else hides gridlines for a cleaner dashboard view, and suddenly the operations tracker looks like it survived a formatting tornado.
If you receive a shared Excel file with missing gridlines, start with the least destructive fix: turn on gridlines from the View tab. If that works, great. If not, inspect the cells for fill color. Avoid clearing all formatting immediately unless you are sure it is safe, because you might remove useful styles, formulas, or conditional formatting. When working with team files, it is better to test a small range first.
Should You Always Show Gridlines?
No. Gridlines are helpful, but they are not always necessary. For data entry, analysis, and review, keep them visible. For polished dashboards, executive summaries, printable invoices, and presentation-ready reports, you may want to hide them and use custom borders instead.
A good rule of thumb: if the spreadsheet is for working, show gridlines. If the spreadsheet is for presenting, consider borders and cleaner formatting.
of Practical Experience: What I’ve Learned from Real Excel Gridline Problems
After working with many spreadsheets, one thing becomes clear: missing gridlines are rarely a dramatic technical problem. They are usually a small setting hiding in plain sight. The challenge is that Excel gives users several different ways to affect how lines appear. That flexibility is useful, but it can also create confusion when a worksheet suddenly looks different.
The most common real-world issue is white fill. Many users apply white background color to make a worksheet look cleaner, especially when creating reports or dashboards. Later, they forget they did it. When they turn gridlines back on, nothing happens because the white fill is still covering them. This is why I always check fill color before assuming Excel has a display problem. Selecting a suspicious range and choosing No Fill solves the issue more often than people expect.
Another experience-based lesson is that gridlines and borders should not be used interchangeably. Beginners often try to print gridlines because they want a table to look organized on paper. That can work, but borders are more dependable. If a document is going to be shared as a PDF, printed for a meeting, or sent to a client, borders usually produce a more professional result. Gridlines are excellent for working inside Excel; borders are better for communicating outside Excel.
I have also seen many users panic when gridlines disappear only in part of a worksheet. This usually happens after copying information from another workbook, a website, or an exported report. The pasted content brings formatting with it, including background color. The fix is not to rebuild the worksheet from scratch. Instead, select the affected area, remove the fill, or use Clear Formats if you do not need the imported styling.
For large spreadsheets, I recommend keeping gridlines visible while editing. When you are reviewing hundreds or thousands of rows, those faint lines reduce eye strain and help prevent row-tracking mistakes. This matters when checking inventory, invoices, payroll records, student scores, or financial data. A missing gridline may not sound serious, but one misread row can turn a simple task into a detective story nobody asked for.
For dashboards, I usually do the opposite. I hide gridlines and use carefully placed borders, spacing, and fill colors. This makes the worksheet feel less like raw data and more like a finished product. The trick is to decide the purpose of the sheet. If the goal is analysis, gridlines are your friend. If the goal is presentation, custom formatting often wins.
Finally, always check Print Preview before assuming your worksheet will print the way it appears on screen. Excel’s screen view and printed output are related, but they are not identical twins. Gridlines may show while editing and still be absent from the printed page unless the print option is enabled. A ten-second preview can save paper, ink, time, and the tiny emotional collapse that happens when a printed spreadsheet looks nothing like expected.
Conclusion
Showing gridlines in Microsoft Excel is simple once you know where to look. Start with the View tab and check Gridlines. If that does not work, use the Page Layout tab and enable the Gridlines View option. If gridlines still refuse to appear, inspect cell fill color, gridline color, and worksheet formatting. For printed documents, remember to enable the Gridlines Print option or use borders for a stronger, more reliable layout.
Gridlines may be small, but they make a big difference in readability. They help your eyes follow data, keep rows and columns organized, and make Excel feel less like a blank field of floating numbers. Once you understand the difference between gridlines and borders, you can make better choices for editing, printing, and presenting your spreadsheets.
Note: This article is written for web publishing and synthesizes reliable Excel guidance with practical spreadsheet experience. No source-link markup or citation placeholders are included in the HTML.