How to Delete Gridlines in Excel Without Hiding Cell Borders

How-to basics · Updated November 20, 2026

To hide gridlines in Excel, open the worksheet, select the View tab, and clear the Gridlines checkbox. This changes how the sheet is displayed; it does not delete cells or remove borders you have added. You can turn the gridlines back on at any time, and you can control screen display separately from printing.

What You’ll Need

  • An Excel workbook and the worksheet where you want to hide gridlines.
  • Permission to edit the workbook if it is protected or shared with restricted access.

Step-by-Step

  1. Open the right worksheet. Open the workbook in Excel for Microsoft 365 on Windows, then click the sheet tab at the bottom of the window. Gridline visibility is a worksheet-level setting, so hiding lines on one sheet does not automatically hide them on every other sheet. If you have several sheets to change, you will repeat the setting for each one. Check the sheet name before you start, especially if the workbook has similarly named tabs.
  2. Go to the View tab. On the ribbon, select View. Find the Show group, which contains display options such as Gridlines, Headings, and the Formula Bar. If the ribbon is collapsed, click a ribbon tab to expand it. In a narrow Excel window, some group labels or controls may be condensed, so maximize the window or widen it if you cannot see the checkbox.
  3. Turn off Gridlines. Clear the checkbox labeled Gridlines. The worksheet’s faint cell lines should disappear immediately. The setting affects the current sheet, not just the selected cells, and it does not change the values, formulas, or layout of your data. If nothing appears to change, inspect a blank area of the sheet: filled cells or custom formatting may already be concealing the lines there.
  4. Check the whole worksheet. Scroll to a blank region and look across the sheet to confirm the display is what you want. Excel’s row and column headings, such as A, B, C and 1, 2, 3, are separate from gridlines. If you want a cleaner view without those labels too, clear Headings in the same View tab group. Do not clear it unless you want the row numbers and column letters hidden as well.
  5. Repeat on other sheets if needed. Click each additional sheet tab and clear View > Gridlines for that worksheet. If you want the same view on multiple sheets at once, you can group the sheets by selecting one tab and then Ctrl-clicking other tabs on Windows. Be careful: grouped sheets can receive other edits simultaneously. Once you have changed the setting, right-click a grouped tab and choose Ungroup Sheets before making unrelated changes.
  6. Save the workbook. Press Ctrl+S or select File > Save. Gridline visibility is saved with the workbook’s worksheet settings. If you are working in a shared or cloud-saved file, wait for the save or sync indicator to finish before closing the workbook. The change affects the view of the worksheet for people opening that workbook, so consider whether collaborators expect the usual grid display.
  7. Set printing separately if that is your goal. Hiding gridlines on screen does not by itself guarantee they will be omitted from a printed worksheet. On Windows, go to Page Layout > Sheet Options, then clear Print under Gridlines. Use Print Preview to confirm the result before printing or exporting. The View checkbox controls on-screen gridlines; the Print checkbox controls whether gridlines are printed.
  8. Use the equivalent control on another platform. In Excel for Mac, select View > Gridlines and turn the option off; labels and ribbon layout can vary slightly by release. In Excel for the web, open the View tab and clear Gridlines in the Show area. If you do not see that control, expand the ribbon or check the current web interface’s View options. The worksheet-level behavior is the same: change each sheet whose gridlines you want hidden.

Common Mistakes

Confusing gridlines with borders. Gridlines are Excel’s default, faint guides between cells. Borders are formatting that someone applied to particular cells, and they remain visible when you turn off gridlines. If a table still has dark outlines after you clear the checkbox, those are likely borders. To remove selected borders, select the cells and choose Home > Borders > No Border. This removes the chosen border formatting, so use it only when that is what you intend.

Expecting one click to affect every sheet. The View tab checkbox applies to the active worksheet. A workbook can therefore have gridlines hidden on one tab and visible on another. Check each sheet you plan to present, print, or share. If you group tabs to make the same change across sheets, remember to ungroup them afterward; leaving sheets grouped can cause later edits to affect all selected sheets.

Looking for a permanent delete command. There is no need to delete cells or alter the worksheet structure to remove the faint guides. Turning off Gridlines is the normal method, and it is reversible. Avoid selecting the entire sheet and deleting content or formatting just to make the lines disappear; that can damage data and still may not give the intended display.

Assuming screen and print settings are identical. The View setting and the Print setting are separate. A sheet can look clean on screen but still print gridlines if the print option is enabled. Conversely, gridlines can remain visible on screen while being omitted from printouts. Check both settings when you are preparing a worksheet for someone else.

Tips

  • Keep useful structure visible. With gridlines hidden, data can look like a continuous block. Add deliberate borders to tables, totals, or section headings rather than restoring every default line. A small number of consistent borders often makes a report easier to read than a fully boxed-in sheet.
  • Know what fill formatting does. Cells with a fill color can hide gridlines within the filled area, even if the worksheet’s Gridlines option is on. This includes a white fill that visually resembles the sheet background. If you want the default lines back in a particular region, select those cells and choose Home > Fill Color > No Fill, provided removing the fill will not change the intended formatting.
  • Use Print Preview before sharing a paper copy. Select File > Print and review the preview. It can reveal gridlines, page breaks, or clipped columns before you use paper or save a PDF. For a polished report, consider whether borders, page orientation, scaling, and print area also need adjustment.
  • Remember the Windows shortcut difference. Ctrl+S saves the workbook on Windows. On Mac, use Command+S. There is no standard single keyboard shortcut for toggling worksheet gridlines in Excel for Windows, so use the ribbon setting rather than relying on an unverified shortcut.
  • Choose a suitable background. Hiding gridlines is especially useful for a dashboard, form, or presentation sheet, but it does not hide row and column headings unless you switch those off separately. You can also use borders and cell fills to guide a reader’s eye while leaving the rest of the worksheet uncluttered.

Troubleshooting

The checkbox is already clear, but lines are still visible. Check whether the lines are borders. Select a cell in the affected area and inspect Home > Borders; applied borders may remain when gridlines are off. Also consider whether the visible marks are page breaks, drawing objects, or table formatting rather than gridlines. A page break is usually a heavier or dashed line, not the light cell-by-cell pattern.

Gridlines remain in only part of the sheet. A fill color may be covering the default gridlines in that region. Select a cell that looks different and check Home > Fill Color. If the cells have a fill, you can choose No Fill to reveal the worksheet’s normal display again. If you need the colored background, leave the fill in place and use borders where you want visible cell divisions.

You cannot change the setting. The workbook or worksheet may be protected, or you may have read-only access. Check the title bar and the Review tab for protection options, or ask the workbook owner for edit permission. Do not remove protection if you do not have authorization. In a browser, a view-only workbook may let you inspect settings but not save changes; make an editable copy only if your organization permits it.

The setting changes back after reopening. Confirm that you saved the same workbook you edited and that the save or cloud-sync process completed. If the file is a template or you opened a separate downloaded copy, you may be reopening a different file. Gridline visibility is per worksheet, so also confirm that you changed the intended tab rather than another sheet with a similar name.

Gridlines disappear on screen but print anyway. Open Page Layout > Sheet Options and clear Print under Gridlines. Then revisit File > Print to check the preview. If lines still show in the preview, inspect the cells for applied borders; borders are separate formatting and are not removed by the print-gridlines setting.

Frequently Asked Questions

Does turning off gridlines delete cells or data?
No. It changes the worksheet’s display setting only. Your cell values, formulas, rows, columns, and workbook structure remain in place, and you can show the gridlines again by selecting the checkbox.

Can I hide gridlines in just one part of a worksheet?
The Gridlines checkbox applies to the entire worksheet, not a selected range. To make lines appear absent in a particular area while leaving the rest visible, use a cell fill or format borders intentionally. A fill can conceal the default gridlines, but it is not the same as switching the worksheet setting off.

How do I get gridlines back?
Click the worksheet tab, open View, and select the Gridlines checkbox. If the lines return everywhere except certain cells, check whether those cells have a fill color or whether the visible divisions depend on custom borders.

Will hiding gridlines remove borders from my table?
No. Borders are independent cell formatting and remain visible. To remove them, select the relevant cells and use Home > Borders > No Border. Use that command carefully because it removes borders rather than merely hiding the worksheet’s default guides.

Why do gridlines show in the printout if they are hidden on screen?
Excel has separate controls for display and printing. On Windows, go to Page Layout > Sheet Options and clear Print under Gridlines. Check Print Preview afterward, since applied cell borders can still print even when gridline printing is off.

Can I hide gridlines in Excel for Mac or the web?
Yes. In Excel for Mac, use the Gridlines option on the View menu or tab, depending on the ribbon layout. In Excel for the web, use View > Gridlines in the Show controls. The exact placement can vary by interface version, but the setting is still applied to the active sheet.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.