3 Quick Methods to Show or Hide Gridlines in Your Excel Worksheet

Sometimes you need to show or hide gridlines to fulfill some tasks. Here we will provide 3 quick methods to show or hide gridlines easily.

In your Excel worksheet, the gridlines can help you distinguish different cells. But on the other hand, sometimes you don’t need the gridlines. Therefore, you need to hide them. Below are the 3 different methods that you can apply.

Method 1: Use Features in Toolbar

There are two different places in the toolbar that you can show or hide gridlines. Here we will introduce one by one.

  1. Click the tab “Page Layout” in the ribbon.
  2. And then uncheck the option “View” in the “Sheet Options” of the “Gridlines”. If you need to show the gridline, you need to check the option here.Uncheck View

Thus, the gridline will hide or show according to your setting.

Below we present the steps of using another option.

  1. Click the tab “View” in the ribbon.
  2. And then uncheck the option “Gridlines” to hide them. Besides, if you need to show gridlines, you need to check the options here.Uncheck Gridlines

And the gridline will show or hide according to the setting in the toolbar. These two options have the same effect. You can use either of them according to your habit.

Method 2: Add Buttons in the Quick Access Toolbar

Instead of using the previous method, you can also add buttons in the quick access toolbar.

  1. Click the small arrow in the quick access toolbar.
  2. And then select the option “More Commands”.More Commands
  3. In the “Excel Options” window, choose the option “All Commands” for the “Choose commands from”.
  4. And then drag the scrollbar until you see the options about gridlines”.
  5. There are two different options about gridlines. Here we add both into the toolbar. First click one of the options.
  6. And then click the button “Add”.
  7. Next repeat the steps and add another button.Add Buttons
  8. After that, click the button “OK” in the window. Thus, you have added the buttons in the quick access toolbar.
  9. Now you can directly click the button in the quick access toolbar to show or hide gridlines.Button in Quick Access Toolbar

Instead of adding buttons in the “Excel Options” window, you can also add it from the toolbar directly.

  1. Right click the option “View” or “Gridline” in the first method.
  2. And then choose the option “Add to Quick Access Toolbar”.Right Click

Thus, the button will also appear in the quick access toolbar. You may follow these steps and add buttons quickly.

Method 3: Use VBA Process

Instead of using the above two methods, you can also use the VBA codes to fulfill the task.

  1. Press the shortcut “Alt + F11” on the toolbar to open the Visual Basic Editor.
  2. And then right in the VBA project.
  3. In the menu, move your cursor on the option “Insert”.
  4. Next click the option “Module” in the menu.Insert a Module
  5. Now copy the codes and paste into the new module.

Sub ShowHideGridline()

     ActiveWindow.DisplayGridlines = not ActiveWindow.DisplayGridlines

End Sub

  1. And then press the button “F5” on the keyboard to run the process. You can also click the “Run Sub” in the toolbar. Therefore, you can also use this procedure to show or hide gridlines quickly in your worksheet.

A Comparison of the 3 Methods

You may wonder which method is the most suitable for you. Here we have listed the advantages and disadvantages of the three methods.

Comparison Use Features in Toolbar Add Buttons in the Quick Access Toolbar Use VBA Process
Advantages This method can be used in other computers. You don’t need to have additional settings. You can quickly show or hide gridlines by this method.  With just one click,you can show or hide gridlines.
Disadvantages Compared with other methods, there are more steps in this method. Before you can use the quick access toolbar, you need to spend time to ass buttons into it. Using VBA codes will make the task more complicated.

Do Not Lose your Valuable Data Due to an Excel Crash

Excel crash will cause damage to your data and information. Actually, most of the lost data are recoverable as long as you can take the right action. If you don’t know the reason of the corruption, do not try to recovery by yourself. Otherwise, you will lose those precious data forever. At this moment, you can use an Excel repair tool to repair xls data damage. With this tool at hand, you can get back your data and information in a quick time.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair doc file problem and outlook repair software products. For more information visit www.datanumen.com

One response to “3 Quick Methods to Show or Hide Gridlines in Your Excel Worksheet”