How to 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? Firstly, 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 makes your worksheet look a lot more presentable. Should you wish to remove the gridlines, here are the steps you can follow. We cover here 3 methods to hide gridlines in Excel Worksheet.
1] Hide Gridlines in Excel using Traditional Method
2] Remove Excel gridlines by using the shortcut key
If you use Windows shortcuts frequently to perform various tasks, here’s another for you. To hide gridlines in Excel worksheet using a Windows shortcut key. Press “Alt + W+V+G” key in combination and see the magic work.
3] Hide Gridlines in Excel by changing background color:
A very simple way of hiding the gridlines in Excel is by changing their background color 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 color.
If your 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!
