

When you open a new Excel worksheet, it shows by default an empty table, just divided by thin grey lines. These grey gridlines are quite useful. They provide a quick impression of the rows and columns of your Excel worksheet. But once you want to finalize your layout, you worksheet or workbook often looks more professional without gridlines.
In this article we explore 5 methods of how to hide the gridlines in Excel. Furthermore, you learn how to hide them on all worksheets at once.
In a hurry? Go to the “View” ribbon and remove the tick mark from “Gridlines”. For more information, scroll down.
Contents
Unfortunately, this method can be found in practice quite often. Some Excel users “hide” the gridlines by using a white fill color. Although this way works – there are not any gridlines shown any longer – it’s strongly not recommended: Have you tried “restoring” the gridlines?
You can change the color of gridlines
You can change the color of the gridlines. If you want to hide them, you can choose white color.
Please note that you can only change the gridlines color of one worksheet at a time.
Hold on a second. Was this information helpful so far?
Why don't you subscribe to our monthly, free Excel newsletter?
Subscribe now! Your welcome gift: Our big 45 pages keyboard shortcuts package. In case the sign-up form above doesn't work, please use this page. Sorry for the inconvenience.
Of course, I'm also on other networks:
Twitter: Follow @professorexcel
Facebook:
Select all worksheets at once
You want to remove the lines on all worksheets at the same time? It’s easy:
In case the method 4 above is not working (maybe with older versions of Excel). Here is a simple VBA macro. Insert it into a new module (please see this article for more information) and press the start button.
Sub hideGridlinesOnAllWorksheets() Dim ws As Worksheet For Each ws In Worksheets ActiveWindow.Sheets(ws.Name).Activate ActiveWindow.DisplayGridlines = False Next ws End Sub
For more comfort use the “Layout Manager”
The Excel add-in Professor Excel Tools has a simple but powerful “Layout Manager”. It offers a variety of tools for easily applying layouts. If you open the layout manager you’ll also find the option of hiding all the gridlines in the whole workbook, on all selected worksheets or the currently active sheet only.
This function is included in our Excel Add-In 'Professor Excel Tools' Learn more Download Free Trial
(No sign-up, download starts directly)
More than 10k people on Facebook can't be wrong.
'Professor Excel Tools': Add more than 60 amazing features to Excel!
Professor's Error Helper for Excel: Solve any error in Excel.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.