How to remove gridlines from 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 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 it can be counterproductive if you change the background color of your cells.
Hide the gridlines from the Excel ribbon
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