30 EXCEL POWER TIPS
Discover the shortcuts and tricks used by the pros
Enter your details for immediate access
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.
I hope you enjoyed this quick tip.
Did this clear something up for you? If so, please share on your socials and/or post a brief comment below.
Likewise, if something didn't make sense or you have a question, pop it into the comments below. I'll be waiting ...
Cheers. Here's to your learning and success. Enjoy the rest of your day.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.