Inside The Web
    Facebook Twitter Instagram
    Inside The Web
    • Office
      • Excel
      • Ms Word
      • Gmail
    • Productivity
      • Time Management
      • Task Automation
    Inside The Web
    Home»Excel»How to Show or Remove Gridlines in Excel

    How to Show or Remove Gridlines in Excel

    jabinBy jabinFebruary 7, 2023 Excel 4 Mins Read

    Gridlines are basically horizontal and vertical lines that spread across rows and columns. Excel displays them by default so that it’s easier to identify each cell in the worksheet.

    However, if your worksheet contains design elements like a chart or a dashboard, you may want to hide gridlines for better visualization.

    On Excel, you can hide/show gridlines across an entire worksheet or workbook. And, while you can’t do so for a particular area of a worksheet, you can still use cell borders as an alternative solution.

    Using the Excel Advanced Options

    Using the Excel Advanced options, you can show/remove gridlines for the worksheet(s) or even a whole workbook. Also, you can apply the gridlines setting for multiple worksheets at once.

    1. Select File > Options.
    2. Click the Advanced tab.
    3. Scroll down to the Display options for this worksheet section.
    4. Click the dropdown next to it and select a whole workbook or one of the worksheets for which you want to show/hide gridlines.
      Show-or-hide-gridlines-on-a-worksheet-or-workbook
    5. Then, uncheck the Show gridlines checkbox to hide or enable it to show gridlines.
      Show-hide-gridlines-Excel
    6. To select multiple worksheets in a workbook, first select them while pressing the Ctrl key. Then, repeat the above steps and make sure you choose the Multiple Selected dropdown worksheets option.

    Using the Page Layout Tab

    You can also use the Page Layout tab to quickly show/remove the gridlines on your worksheet.

    1. Select the Page Layout tab.
    2. To hide/remove the gridlines, disable the View checkbox under Gridlines. You can find it inside the Sheet Options section. 
      Show-hide-Excel-Gridlines-using-Page-Layout-tab
    3. Similarly, enable the View checkbox to show gridlines.

    Using the View Tab

    Another way to show/hide gridlines is through the View tab. 

    1. Select the View tab.
    2. To hide/remove the gridlines, uncheck the checkbox next to Gridlines inside the Show section.
      Disable-Gridlines-using-View-tab
    3. To show it again, enable the Gridlines checkbox.

    Via the Quick Access Toolbar

    Initially, you don’t have gridlines on the quick access toolbar. However, you can add the gridlines setting much like other Excel tools. Once you do so, you can easily access them no matter which tab you are using.

    1. Go to the View tab.
    2. Right-click on Gridlines and select Add to Quick Access Toolbar.
      Add-Gridlines-to-Quick-Access-Toolbar
    3. Now, the Gridlines setting should appear at the top left corner and you can enable/disable its checkbox to show/hide it.
      Access-Gridlines-on-Quick-Access-Toolbar

    How to Show or Hide Gridlines for a Specific Region in a Worksheet?

    Whether you turn on or off gridlines, Excel reflects it on the whole worksheet. Now, this can sometimes become an issue if you want to display gridlines for specific data only and leave other spaces blank.

    To solve it, you can use cell borders as an alternative. Here’s how to do it.

    1. First, turn off the gridlines. Then, select the region where you want the gridlines.
      Select-cells-without-the-gridlines
    2. Now, you need to apply a cell border. So, press Ctrl + 1 and select the Outline/Inside option under the Border tab. Additionally, use the color gray if you want it to appear as regular gridlines.
      Apply-cell-border
    Note: By default, tables will display cell borders even if you hide gridlines.

    How to Enable or Disable Gridlines for Charts?

    Some charts come with built-in gridlines inside them. To disable gridlines on them,

    1. Select the chart.
    2. Right-click on one of the gridlines and select the Format Gridlines option. Or, select anywhere on the chart area and select the Format Plot Area option.
      Choose-Format-gridlines
    3. Once the navigation pane appears on the right side, expand Line/Border and select No line to hide the gridlines inside the chart.
      No-line-option
    4. To enable gridlines, choose other options like the Solid line and Gradient line.

    How to Show Gridlines while Printing?

    By default, the gridlines don’t appear when you print the worksheet. However, you can choose to show them on the printed paper as follows.

    1. Select the Print Layout tab.
    2. Enable the Print checkbox under Gridlines.
      Disable-Grid-lines-while-printing-an-Excel-worksheet

    Related Questions

    Why Am I Still Seeing the Gridlines Even after Disabling Them?

    If you see some dotted lines across your worksheet, they aren’t actually gridlines, but probably automatic page breaks or cell borders. So, you need to disable/remove them instead.

    Cell Formats Excel Basics
    jabin

      As a tech content writer, Jabin covers Excel-related articles at InsideTheWeb. His articles mainly involve helping new users to quickly familiarize themselves with the Excel interface and explaining various essential features. While he got introduced to Excel in his early school days, he developed a keen interest in it after working on a college project. He was impressed at how quickly one could accomplish several tasks with built-in functions like the filter function and user-friendly tools like the power query. Keeping beginner audiences in mind, he loves to explain even the most fundamental Excel concepts in detail and break down complex topics with a step-by-step approach. As an avid Excel user, he believes every task can be done a lot quicker if you know the right tools and techniques. When he’s not behind a keyboard, he loves to listen to interesting audiobooks and podcasts.

      Add A Comment
      Table of Contents
      • Using the Excel Advanced Options
      • Using the Page Layout Tab
      • Using the View Tab
      • Via the Quick Access Toolbar
      • How to Show or Hide Gridlines for a Specific Region in a Worksheet?
      • How to Enable or Disable Gridlines for Charts?
      • How to Show Gridlines while Printing?
      • Related Questions
        • Why Am I Still Seeing the Gridlines Even after Disabling Them?
      Recent Posts
      • How to Calculate Discount Percentage in Excel
      • How to Create a Progress Bar in Excel
      • What is VSTACK in Excel
      • How to Separate Dates in Excel
      • How to Lock a Cell in Excel Formula
      • Home
      • Privacy Policy
      © 2023 Inside The Web

      Type above and press Enter to search. Press Esc to cancel.