Chat with us, powered by LiveChat

How to Remove Gridlines in Excel

How to Hide Worksheets and Gridlines in Excel 2019 EN (delete)

If you have a workbook that you are going to show to others, you may want to hide certain worksheets so some information isn't visible. Hiding a worksheet doesn’t delete any data, it just hides the sheet from view temporarily.

Hide a Worksheet

  1. Select the worksheet you want to hide.
  2. Click the Format button under the Home tab.
  3. Select Hide & Unhide.
  4. Select Hide Sheet.
    Hide a Worksheet

    You can also right-click a sheet tab and select Hide from the menu.

Excel hides the worksheet. Keep in mind, this doesn't protect the spreadsheet. Anyone with access to the file can easily unhide the sheet.

Unhide a Worksheet

  1. Ciick the Format button on the Home tab.
  2. Select Hide & Unhide.
  3. Select Unhide Sheet.

    You can also right-click any sheet tab and select Unhide from the menu.

    The Unhide dialog box appears where you can check for any hidden sheets in the file.

  4. Select the worksheet you want to unhide and click OK.
    Unhide a Worksheet

The worksheet is unhidden.

Hide or Display Worksheet Elements

The formula bar, worksheet gridlines, and headings are all on by default. Any of these items can be toggled on or off from the View tab.

  1. Click the View tab.
  2. Check or uncheck a worksheet item in the Show group.
    Hide or Display Worksheet Elements
    • Ruler: This option is only available in Page Layout view. The ruler allows you to see and set tab stops, move table borders, and line up objects in the spreadsheet.
    • Formula Bar: With the formula bar turned on, you can see and edit formulas in a selected cell.
    • Gridlines: These are the lines between the rows and columns in your worksheet that make it easier to read data.
    • Headings: Show or hide the column headings (A, B, C, etc.) and row headings (1, 2, 3, etc.) in your workbook.

FREE Quick Reference

Click to Download