How to Remove Gridlines in Excel
Removing gridlines will make your Excel worksheet look like a blank document as shown below:
- Using the view and page layout options
- Changing the background color
- Using Visual Basic for Applications (VBA)
- Removing gridlines for specific cells in Excel
How to Remove Grid lines in Excel
When you open the Excel sheet, you see a cross-section of rows and columns with grey-coloured lines that separate cells. Those gray-colored lines are known as gridlines in MS Excel. The grey color is the default color offered by Microsoft and one can change the color of the gridlines. These Guidelines can be helpful in reading data, but they might become distracting or undesirable when presenting or printing the final document.
Borders and Gridlines are two things that create confusion among users, Borders are customizable and one can change their color, type, and width but the same is not true for gridlines.
Note: Gridlines are always applied on the whole worksheet or workbook, you can’t apply it on one cell or a set of cells. In this case, borders are applicable.
Contact Us