How to Remove Gridlines in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Remove Gridlines in Excel



In this tutorial, you will learn how to remove gridlines in excel. Knowing how to delete gridlines in excel is useful if you feel your sheets interface in the spreadsheet will be better without using vertical and horizontal lines that become default cell borders in this software.


Why do We Need to Learn How to Get Rid of Gridlines in Excel?


In preparing the data interface on the spreadsheet, sometimes we might want to know and practice how to remove grid in excel. We want to do this because we might feel the data interface that is being shown is better without the default cell lines from this software settings or maybe we want to edit data in our sheets by paying attention in the look of them when they are printed. After all, those default lines will not be printed later unless we change its settings specifically. Moreover, we might want to make the data table borders or other shapes that we have given in each of our sheets clearer and we feel that the default lines are potential distractions to achieve that goal.

As an example of this need in our job, imagine we want to use this software to make a form that will be filled in internally in the company. If we want to make each shape and filling parts of the form clearer, then we might want to use various things like images, borders, graphs, or other things that can help to make the form interface better and easier or more intuitive in its filling process. The vertical and horizontal default lines from the spreadsheet might be felt to disturb this objective and it will be better if they can be removed from the form interface.

To accomplish the objective in that case, then it will be good if you know how to remove gridlines in excel. By knowing the ways to do this, then you can use the knowledge when you need it and your spreadsheet interface has a higher possibility to be adapted more according to your preferences.


What is How to Remove Excel Gridlines?


How to remove the gridlines on excel is a function with the usage objective to hide default vertical and horizontal borderlines in the spreadsheet. This can be done easily if you know where and how to set it in this software.


How to Get Rid of Gridlines on Excel?


The following will explain the steps of how to remove gridlines in excel with some screenshots given in each of the steps to make them clearer. There are three methods to do this (2 if you use Mac) which will be explained in detail.


Excel How to Remove Gridlines Methods


Method 1 - Using View or Page Layout Tab


  1. Click on the View or Page Layout tab on your spreadsheet

    How to Remove Gridlines in Excel - Screenshot of Step 1-1

  2. Click once on the Gridlines or View Gridlines checkbox. If you want to show those lines again, then just click again on the checkbox

    How to Remove Gridlines in Excel - Screenshot of Step 1-2-1

    How to Remove Gridlines in Excel - Screenshot of Step 1-2-2


Method 2 - Using Fill Color in the Cells (Can Also Be Used if You Only Want to Remove the Lines in Some Parts of the Sheets)


  1. Highlight the cell range which you want to remove the lines from or press Ctrl + A (Command + A for Mac) if you want to remove them from your sheet completely

    How to Remove Gridlines in Excel - Screenshot of Step 2-1

  2. Click Fill symbol in the Home tab and choose the color that you want for the background of all cells in your current highlighted range (pick white color if you want the color to look the same as before)

    How to Remove Gridlines in Excel - Screenshot of Step 2-2-1

    How to Remove Gridlines in Excel - Screenshot of Step 2-2-2

    How to Remove Gridlines in Excel - Screenshot of Step 2-2-3


Method 3 - Using Shortcut (Only in Windows)


Press Alt + W + V + G buttons on your keyboard at the same time



Exercise


After you have understood how to do each of the methods explained above, now is the time you try them on your spreadsheet. Open your spreadsheet file and try to remove the gridlines in excel by using each of the methods that have been explained. Can you do it?


Additional Note


If you instead want to print the default vertical and horizontal lines from the spreadsheet, then you only need to go to the Layout tab and make sure that the Print checkbox in the Gridlines part is checked.

How to Remove Gridlines in Excel - Screenshot of Additional Note 1

How to Remove Gridlines in Excel - Screenshot of Additional Note 2





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert