Hide Gridlines in Excel: Keyboard Shortcut and Steps

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, press Alt, then W, V, and G in sequence to hide gridlines on the active worksheet. These are ribbon KeyTips, not keys to hold down together. You can also turn them off through View > Gridlines. The change affects how that sheet looks on screen; it does not erase cells or their contents.

Hiding gridlines can make a finished report, dashboard, or form look cleaner. Before you start, select the worksheet you want to change. If you only want a cleaner printout, use the separate print setting instead, because hiding gridlines on screen does not automatically change whether they print.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows, with the worksheet you want to edit selected.
  • A keyboard if you want to use the shortcut. The ribbon method works with a mouse or touch controls.
  • Permission to edit the workbook, if it is protected or opened read-only. You can still inspect display settings in some protected files, but saving a change may be restricted.

Step-by-Step

  1. Open the right worksheet. Click the sheet tab at the bottom of the workbook. Gridline visibility is a worksheet-level display setting, so changing it on one tab does not normally change every other sheet. If several sheet tabs are highlighted, the sheets may be grouped. Click a single tab before proceeding if you intend to change only one worksheet.
  2. Use the Windows KeyTip shortcut. Press and release Alt, then press W to open the View tab’s KeyTips. Press V, then G, one at a time. In the standard Microsoft 365 Windows ribbon, this sequence toggles the Gridlines option for the active sheet. If the ribbon displays different letters on your installation, use the letters shown beside the relevant ribbon controls instead; KeyTips can vary by version, update, or ribbon customization.
  3. Check that the gridlines disappeared. Look at the blank cells around your data. The faint cell separators should no longer be visible. The worksheet still has the same rows, columns, cell addresses, values, and formulas. The shortcut is a toggle: repeating the sequence turns gridlines back on.
  4. Use the ribbon if you prefer a visible control. Click View on the ribbon. In the Show group, clear the Gridlines check box. If the ribbon is collapsed or the Excel window is narrow, expand the ribbon or look for the Show controls on the View tab. The check box is a direct way to see whether the option is on or off.
  5. Use Page Layout to check display and print separately. Click Page Layout, then find the Sheet Options group and its Gridlines section. Clear View to hide the gridlines on screen. The adjacent Print option controls printing independently. Leave Print checked if you want gridlines on paper while hiding them in the workbook window, or clear it too if you do not want them printed.
  6. Save the workbook if you want to keep the setting. Press Ctrl+S or choose File > Save. The visibility choice is saved with the worksheet in the workbook, so someone opening the saved file will generally see that sheet with the same gridline setting. Saving does not turn off gridlines in other worksheets you have not changed.
  7. Turn them back on when needed. Select the same sheet and repeat Alt, W, V, G, or select the Gridlines check box on the View tab. Use whichever method is easier to remember. If the result is unexpected, verify that you are on the intended sheet and that its Gridlines box is checked or cleared as desired.

On Mac: The Windows KeyTip sequence is not the dependable shortcut for Excel for Mac. Select the worksheet, open the View tab, and use the Gridlines check box to change visibility. Depending on the Mac version and ribbon layout, the control may appear in a Show section. For print output, use the sheet’s page layout or print settings and check the separate gridline option. On Excel for the web, select View and look for Gridlines under the Show options; the web ribbon can differ slightly from the desktop ribbon.

Common Mistakes

  • Holding the keys down as a chord. The Windows sequence uses KeyTips: press and release Alt, then press the letters in order. It is not the same as pressing Alt+W+V+G simultaneously.
  • Assuming the change applies to the entire workbook. Gridline visibility is set per worksheet. A workbook with several tabs can have gridlines hidden on one sheet and visible on another. Check each sheet you want to adjust.
  • Confusing gridlines with borders. Gridlines are the faint default separators between cells. Borders are formatting applied to particular cells. Hiding gridlines does not remove borders, and it does not remove cell fill colors. If dark lines remain around a table, inspect its border formatting.
  • Expecting the shortcut to change printed pages. The View setting controls the on-screen appearance. Printing is controlled separately in Page Layout > Sheet Options > Gridlines > Print. Preview the page before printing if the paper version matters.
  • Changing a group of worksheets by accident. When multiple sheet tabs are selected, Excel groups those worksheets and some changes can apply to all of them. Check the tab highlights before using the shortcut. To ungroup, right-click a selected tab and choose Ungroup Sheets, or click a single unselected sheet tab.

Tips

  • Use the shortcut for a quick toggle, not a permanent deletion. The grid is still part of the worksheet structure. Turning the display back on restores the visual separators without recovering or rebuilding anything.
  • Keep important tables readable with borders. If you hide gridlines across a sheet but still need a clear table outline, select the table range and apply borders from Home > Font > Borders. This gives you control over which lines remain visible. It is formatting, so it may appear on screen and in print.
  • Make the sheet easier to review before presenting. Hide gridlines on a dashboard or summary tab, then check headings, spacing, and cell borders at normal zoom. Gridlines are a viewing aid, not a substitute for deliberate layout.
  • Know which setting you are changing. On Page Layout, View and Print are separate check boxes. For example, you can leave View cleared and Print selected to work with a clean screen while retaining printed gridlines. Confirm both options if screen and paper results need to differ.
  • Use the current KeyTips as the authority. If the shortcut letters do not match, press Alt and read the labels Excel displays. Keyboard layouts, ribbon changes, and customized commands can affect which letters appear. The View tab check box remains an easy fallback.

Troubleshooting

The shortcut does nothing. Make sure Excel has focus: click inside the workbook, press and release Alt, and look for KeyTips on the ribbon. Then enter each letter in sequence. If the letters shown differ from V and G, follow the displayed prompts. If the ribbon does not show KeyTips or you find the sequence awkward, use View > Gridlines instead. Some keyboards or remote desktop setups may intercept Alt combinations.

The gridlines are still visible after you clear the option. First confirm that you changed the correct worksheet. Next look at the lines themselves: borders can resemble gridlines, particularly when a table has thin gray borders. Select one of the affected cells and inspect Home > Font > Borders; you can remove unwanted borders there, but do so only if you intend to change cell formatting. Also check whether a cell fill or a shape is affecting how the area appears.

Gridlines disappear on one tab but not another. That is usually expected. Select each worksheet that needs the same appearance and change its Gridlines setting. If you had multiple tabs selected, verify whether the sheets were grouped and whether the changes were applied to more than one tab. Save the workbook after setting each sheet as intended.

The lines disappear on screen but show in a printout. This is controlled by the separate print setting. Open Page Layout > Sheet Options > Gridlines and clear Print if you do not want gridlines on paper. Use File > Print to inspect the preview before printing. The on-screen View check box alone does not guarantee a gridline-free printout.

The gridlines are missing only in some cells. A cell with a fill color may not show the standard gridline in the same way as an unfilled cell. This does not necessarily mean the worksheet-wide setting is off. Check View > Gridlines, then inspect the fill and border formatting of the affected cells. Avoid clearing formatting across a range unless you are sure you will not remove number formats, colors, or other styling you need.

Frequently Asked Questions

What is the shortcut to hide gridlines in Excel for Windows?
In the standard Microsoft 365 Windows ribbon, press and release Alt, then press W, V, and G in sequence. It toggles the Gridlines setting for the active worksheet. If your KeyTips show different letters, follow the on-screen labels.

Is there a single Ctrl-key shortcut for hiding gridlines?
Excel does not provide a standard Ctrl-key shortcut dedicated to this toggle. The Windows Alt KeyTip sequence is the built-in keyboard route; View > Gridlines is the straightforward ribbon alternative.

Does hiding gridlines delete cells, data, or formulas?
No. It changes only the display of the default cell separators. Cell contents, formulas, row and column structure, and any explicitly applied borders remain in place.

Will hiding gridlines affect every sheet in my workbook?
Normally, no. The setting is worksheet-specific. Change it on each sheet as needed, and avoid changing it while multiple worksheet tabs are grouped unless you want the change applied to those selected sheets.

Can I hide gridlines on screen but keep them when I print?
Yes. Clear View but leave Print selected in Page Layout > Sheet Options > Gridlines. Check Print Preview to confirm the result for your worksheet.

How do I hide gridlines in Excel for Mac?
Select the worksheet and clear the Gridlines check box on the View tab. The Windows Alt KeyTip sequence is not the Mac equivalent. Use the separate page layout or print option if you also need to control printed gridlines.

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.