A very quick tip for you today. I want to show you how to hide gridlines in Excel.
Let's say your spreadsheet looks like this ...
Once you have completed your spreadsheet - you’ve entered your data, written your formulas and formatted everything nicely, one final touch that makes all the difference is to switch off the gridlines.
So the same spreadsheet now looks like this ...
In Excel, the gridlines are only displayed on the screen as a guide. They WILL NOT be printed.
However, any borders you add manually WILL be printed.
So if you had the following spreadsheet …
… and you go to the Print Preview, you would see that the BORDERS will be printed, but the GRIDLINES won’t.
How to hide gridlines in Excel for a clean finish
1. Click the View tab.
2. Tick the Gridlines box to show gridlines.
3. Untick the Gridlines box to hide gridlines.
I hope you enjoyed this quick tip.
What do you think?
Please feel free to post any questions you have into the comments below. And before you leave this page, I want to give you one quick little action item!
ACTION ITEM: Comment below with ONE thing you picked up from this post and share how it has helped, or will help, you. It's good to share your successes because it encourages others and provides an instant boost.
Enjoy the rest of your day!