To hide gridlines in Excel for Microsoft 365 on Windows, open the worksheet, select the View tab, and clear the Gridlines checkbox in the Show group. This changes how the current worksheet looks; it does not delete data or cell borders. If you also want gridlines omitted from printouts, change the separate print setting described below.
What You’ll Need
- An Excel workbook with the worksheet you want to change.
- Permission to edit the workbook. You can still view the gridline setting in many protected files, but protection or shared-workbook restrictions may limit what you can change.
- A moment to decide whether you want to hide gridlines on screen, in print, or both. These settings are independent.
Step-by-Step
- Open the worksheet you want to clean up. Gridline visibility is set per worksheet, not for every sheet in a workbook at once. If the workbook has several tabs, click the tab for the sheet you want to change. You can select more than one sheet first if you deliberately want to apply the same setting to a group, but take care: a view change made while sheets are grouped can affect all selected sheets. To avoid surprises, start with a single sheet.
- Go to the View tab. Find the ribbon at the top of the Excel window and select View. In the Show group, locate the Gridlines checkbox. If you do not see the group, maximize the Excel window or expand the ribbon; a narrow window can hide or compress controls.
- Clear the Gridlines checkbox. Click the checked box once. The faint lines between cells should disappear immediately from the worksheet view. This is the quickest way to hide them. You do not need to select cells, erase anything, or change the workbook’s data.
- Check the result across the sheet. Scroll to another part of the worksheet or click a few cells to confirm that the gridlines are hidden throughout that sheet. The setting applies to the whole worksheet, not just the visible area or the cells currently selected. Existing text, numbers, formulas, and cell borders remain in place.
- Repeat for any other worksheets. Click another sheet tab and clear its Gridlines checkbox if needed. If your goal is a consistent presentation across the workbook, check each relevant tab. A workbook can have gridlines hidden on one sheet and visible on another; this is normal and does not mean the setting failed.
- Set the print option separately if needed. To control printed output, open Page Layout and find the Sheet Options group. Under Gridlines, clear Print to omit gridlines on paper or in a PDF. The View checkbox under this group controls on-screen display, while the Print checkbox controls printing. Check File > Print to preview the result before printing.
On Excel for Mac, use the View tab and clear Gridlines in the ribbon’s display controls; the precise grouping can vary with the ribbon layout. For printed output, use the Page Layout tab’s gridline options and turn off Print. In Excel for the web, open View and clear Gridlines in the Show options. The web version may offer fewer page setup controls than the desktop app, so use desktop Excel if you cannot find the print option you need.
Common Mistakes
Expecting the View checkbox to control printing. Hiding gridlines on screen does not necessarily remove them from a printout. Excel provides a separate Print option in Page Layout. If a PDF or paper copy still has lines, check that setting and inspect Print Preview rather than repeatedly toggling the View checkbox.
Confusing gridlines with borders. Gridlines are the light worksheet guides Excel displays around cells that do not have a visible border. Borders are formatting applied to selected cells and can remain visible after gridlines are hidden. If dark or colored lines are still present, select the affected cells and inspect Home > Borders. Remove a border only if you intend to change that formatting.
Using a white fill to cover the lines. Applying a white fill can make gridlines disappear in the filled cells, but it changes cell formatting and may conceal the worksheet background. It is not the same as turning off gridlines. Use the View setting for a clean on-screen sheet, and use Home > Fill Color > No Fill if you need to remove an accidental fill.
Assuming the setting applies to the whole workbook. Gridline visibility is a sheet-level display setting. If you change one tab and then move to another, the other sheet may still show its gridlines. Check each sheet you plan to present, print, or export.
Trying to erase gridlines as if they were cell contents. Gridlines are not values or objects stored in cells, so Delete and Backspace will not remove them. Avoid clearing cell contents or deleting rows and columns to solve a display issue; those actions can remove important workbook data.
Tips
Keep useful structure when hiding the guides. A worksheet without gridlines can look polished, especially for a dashboard, form, or report. If readers still need to distinguish sections, apply subtle borders to selected ranges instead of leaving every cell outlined. For example, use a bottom border beneath headings or an outside border around a summary table. This gives the layout deliberate structure without recreating a dense grid.
Use Print Preview as the final check. The worksheet view is not a reliable substitute for a print preview. Page breaks, scaling, margins, and print settings can alter the appearance of a page. Open File > Print to inspect how the current sheet will look on paper or in a PDF. If the page is too wide, adjust scaling or orientation separately; hiding gridlines will not change page size or fit.
Remember that hiding gridlines is reversible. To show them again, return to View and select Gridlines. This does not restore borders that were removed or undo other formatting. If the lines you miss were actual borders, restore them with the Borders controls or use Undo immediately after an accidental formatting change.
Make a presentation copy when appropriate. If you need one version for editing and another for a polished handoff, save a separate copy before changing extensive formatting or print settings. Hiding gridlines is a low-risk display adjustment, but a copy makes it easier to preserve an original layout and compare versions.
Check sheet tabs before changing a group. When multiple worksheet tabs are selected, Excel groups them. A visual cue such as [Group] in the title bar can indicate grouped sheets. Right-click a selected tab and choose Ungroup Sheets when you are done. Grouping can be useful for consistent changes, but it can also apply an action to sheets you did not mean to alter.
Troubleshooting
The Gridlines checkbox is already clear, but lines remain. The visible lines may be borders rather than gridlines. Click a cell or range where the lines appear and inspect Home > Borders. If the lines are borders, select the relevant cells and use Home > Borders > No Border only when removing those borders is intended. If only some cells lack the faint guides while others show them, check for cell fill: filled cells do not display gridlines in the usual way, even when worksheet gridlines are on.
Gridlines disappear in one area but not another. Check whether the affected cells have a fill color, including white. Select a cell in the area and look at the Fill Color control on the Home tab. Choose No Fill to restore the normal background, if appropriate. Also check for borders, which can create lines that remain visible independently of the gridline setting.
The lines are hidden on screen but appear in a printout. Go to Page Layout > Sheet Options > Gridlines and clear Print. Then reopen File > Print and confirm the preview. If the Print control is unavailable or the layout differs in Excel for the web, open the workbook in the desktop application and adjust the page setup there.
You cannot find the control. Make sure you are looking at the ribbon’s View tab, not the Home tab, and expand the Excel window if the ribbon is compressed. On Mac or in the web app, the control may be arranged differently, but it remains a View display option. If the workbook is open in a simplified ribbon layout, expand or switch the ribbon to expose more commands.
The setting changes back after reopening the file. Confirm that you saved the workbook after changing the setting and that you reopened the same file, not another copy. If the file is read-only, stored in a location where you lack edit permission, or opened in a viewer, Excel may not save your changes. Use File > Save As to create an editable copy if you are allowed to do so.
Frequently Asked Questions
Does hiding gridlines delete anything from the worksheet?
No. It changes the worksheet’s display setting only. Cell contents, formulas, and existing borders remain. You can show the gridlines again at any time by selecting the Gridlines checkbox on the View tab.
Can I hide gridlines in just one part of a worksheet?
The View setting applies to the entire worksheet, not a chosen range. To create a different visual effect in one area, use cell fills or borders carefully. Remember that fills can conceal gridlines in those cells, and borders are separate formatting.
Why do I still see lines after turning gridlines off?
They are likely cell borders, or the cells may have formatting that makes edges visible. Check Home > Borders and the Fill Color setting. Gridlines are usually faint and uniform; borders are often darker, colored, or applied only to certain cells.
Will hiding gridlines affect formulas or calculations?
No. Gridline visibility does not change values, formulas, references, or calculation results. It is a visual setting, so calculations continue to work as before.
How do I remove gridlines from a PDF or printed page?
Clear the Print checkbox under Page Layout > Sheet Options > Gridlines, then check File > Print before saving or printing. The on-screen View setting alone may not control printed output.
Can I hide gridlines in every worksheet at once?
Yes, you can select multiple sheet tabs to group them and then change the setting, but grouped sheets can receive other changes together as well. For a safer approach, change each sheet individually, or group only the intended sheets and ungroup them immediately afterward.
Related
- Copy in Excel and Paste as an Image: Step-by-Step
- How to Copy in Excel and Keep Formatting
- How to Copy an Image in Excel: Clear Steps and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create a PowerPoint Template Using AI: A Practical GuideTo create a PowerPoint template using AI, ask an AI presentation tool to draft a consistent visual system…
- Excel Data Validation Lists Based on CriteriaTo make an Excel drop-down list change according to a criterion, put a FILTER formula in a helper…
- Create a Table in Excel With a Title: Step-by-StepTo create a table in Excel with a title, type the title in a row above your data,…
- Copy Paste in Excel: Keep Column Widths When PastingIn Excel for Microsoft 365 on Windows, copying cells does not normally copy their column widths. To match…
- Excel Text to Value: Convert Numbers Stored as TextTo turn numeric text into a real Excel number, select the cells and choose Convert to Number from…
- Excel Shortcut Keys to Select a Column: Quick GuideIn Excel for Microsoft 365 on Windows, press Ctrl+Space to select the entire column containing the active cell.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.