Hide Gridlines in Excel (for a clean, professional finish)

AUTHOR:  JASON MORRELL 

Jason Morrell

Reading Time:
  minutes remaining

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 ...

A spreadsheet WITH gridlines

Figure 01: A spreadsheet WITH gridlines

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 ...

A spreadsheet WITHOUT gridlines

Figure 02: A spreadsheet WITHOUT gridlines

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 …

Gridlines vs Borders

Figure 03: Gridlines vs Borders

… and you go to the Print Preview, you would see that the BORDERS will be printed, but the GRIDLINES won’t.

In the Print Preview you can see that borders WILL print but gridlines WON'T

Figure 04: In the Print Preview you can see that borders WILL print but 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.

Where to switch gridlines on or off

Figure 05: Where to switch gridlines on or off

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!

Jason Morrell blog signature
About Jason Morrell

About the author

Jason Morrell


Jason loves to simplify the hard stuff, cut the fluff and share what actually works. Things that make a difference. Things that slash hours from your daily work tasks. He runs a software training business in Queensland, Australia, lives on the Gold Coast with his wife and 4 kids and often talks about himself in the third person!

SHARE

Office Legends Academy | Making Office Legends

Master Microsoft Office
in 30 days or less

more from

Office Mastery logo
Read More
SOS-Click: The Easy Automated Backup Tool For Home Users
Read More
6 Excel Templates to Help Organize Your Daily Activities
Read More
10 Ways Excel Consultants Can Help You Fully Leverage Your Business Spreadsheets
Read More
How to fix formulas: 21 Fatal Formula Fails (and how to avoid them)

JOIN THE DISCUSSION

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>