How to remove the gridlines in Excel? Well, it's very simple.
Do not color borders in white.
If you want to hide the gridlines of an Excel sheet, do not try to color the borders of all the cells (No Way !!!)
Indeed, many people who are new to Excel do not know the trick that will be explained here. To hide the gridlines, they color the borders of THE entire worksheet white.
THIS IS NOT THE CORRECT METHOD
Not only is it a massive waste of time, but mainly it can be counterproductive if you change the background color of your cells.
Remove the gridlines from the Excel ribbon
In fact, to remove the gridlines from your spreadsheet, you need to select one of the following options:
- Page Layout
Other Excel tricks
- Remove filters in one click
- Draw borders with the mouse
- Fill series automatically
- Increase the Size of the formula bar