How to Hide Gridlines in Excel (the Easy Way)

How to Hide Gridlines in Excel

In this short tutorial you’ll see the easiest way how to hide gridlines in Excel, either in the whole spreadsheet or in a selected area.

Ready to start?

Would you rather watch this tutorial? Click the play button below!

How to Hide Gridlines in the Whole Spreadsheet

f you want to hide gridlines in the whole spreadsheet, simply click on View tab, go to the section Show and unselect the option Gridlines.

How to Hide Gridlines in Excel - How to Hide Gridlines in the Whole Spreadsheet

The gridlines immediately disappear from the whole spreadsheet and the area looks nice and clean.

How to Hide Gridlines in Excel - The Gridlines disappear

How to Show Gridlines in Excel

In case you need the gridlines to be visible in the sheet, you can simply select the option Gridlines and they’ll be back on, making it easy to navigate through the cells.

How to Hide Gridlines in Excel - How to Show Gridlines in Excel

How to Hide Gridlines in a Selected Area

Now, you might wonder – what if I need to remove gridlines only in a selected area of the spreadsheet? This little tip will do the trick!

Let’s say we don’t want gridlines to appear in the data table.

How to Hide Gridlines in Excel - How to Hide Gridlines in a Selected Area

We select the area of the table, go to Home tab and use the function ‘Fill Color’ to change the background colour of the area to white.

How to Hide Gridlines in Excel - How to Hide Gridlines in a Selected Area - Little Tricks

Thanks to this, no gridlines are now visible in the area we’d selected!

How to Hide Gridlines in Excel - No Gridlines in a Selected Area

Don’t miss out a great opportunity to learn:

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.