The horizontal and vertical faint lines that represent the boundaries are used to distinguish cells on the worksheet are called Gridlines. By default, gridlines are displayed in worksheets using a color that is assigned by Excel.
Hide Gridlines in Excel
If you do not like the default color, you can change it to a color of your choice or even remove them. What are the benefits that Gridlines offer in a worksheet?
First, they make your data-tables readable when they are without a border and second, gridlines make it easier for you to align text or objects. That said, removing gridlines make your worksheet look a lot more presentable. Should you wish to remove the gridlines, here are the steps you can follow.
Here are 3 methods to hide gridlines in Excel Worksheet.
Hide Gridlines in Excel using Traditional MethodNavigate to the
View tab on the Excel ribbon. Under it search for the Gridlines option in
Show section.
Uncheck the
Gridlines option and the gridlines will be hidden, instantly.
Alternatively, you can choose to hide the grid lines from
Page layout and uncheck the Gridlines
View option.
Remove Excel gridlines by using the shortcut keyIf you use Windows shortcuts frequently to perform various tasks, heres another for you. To hide gridlines in Excel worksheet using a Windows shortcut key. Press
Alt + WVG key in combination and see the magic work.
Hide Gridlines in Excel by changing background colour:A very simple way of hiding the grid lines in Excel is by changing their background colour so that it matches the worksheet background.
To begin, press
Ctrl key + A in combination to select all the rows and columns of the spreadsheet. Then, click the
Fill Color option and select the white colour.
If you find for some reason your Excel Worksheet grid lines are invisible and do not appear by default. You can show them by pressing keys
Alt + WVG or checking the
Gridlines option again (highlighted in the first method to make the gridlines clearly visible.
Enjoy a grid-less Excell worksheet!
