What Are Gridlines and How Do They Work?
Most Excel spreadsheets come with gridlines visible as the default setting. However, you may receive a spreadsheet from a co-worker or friend where the gridlines are not visible. You may also decide your data might look better without the gridlines being seen by other users. Either way, adding or removing gridlines is straightforward and doesn’t take much time to do. Several different methods will allow you to show or hide gridlines in Excel 2019, Microsoft 365, and Excel 2016. These include changing the color of the gridlines themselves, altering the fill color of the worksheet, hiding the gridlines in specific tables and cells, and showing or hiding the gridlines for the entire worksheet.
Change the Color of Excel Gridlines for the Whole Worksheet
Whether you need your gridlines to stand out more or you want to remove them from view, you can change the default gridline color with ease.
Change the Fill Color to Remove Excel Gridlines
How to Hide Gridlines for Particular Columns and Rows
There may be times when you only want to have a certain section of gridlines removed to provide visual emphasis for those viewing it.
How to Turn Gridlines On and Off for the Whole Worksheet
Occasionally, you might get a spreadsheet from a friend or colleague that’s had the gridlines removed or made invisible. There are two options to quickly and easily restore gridlines for the entire spreadsheet.