Google Sheets: How To Hide Gridlines
This tutorial shows how to remove gridlines in Google Sheets.
By default, Google Sheets displays gridlines as you’re editing a spreadsheet.
Gridlines are different from cell borders, which you can manually add to cells to make them stand out. Disabling gridlines in Google Sheets won’t remove any additional cell borders or formatting you’ve applied to cells in your spreadsheet.
There are two ways to do it. One literally hides all gridlines in the selected worksheet.
The other way is to uncheck the option "Show gridlines" in your Print settings and your data will be without gridlines in your printed documents.
First, if you want to hide the gridlines as you edit, you just go to the “View” menu, select the “Gridlines” option to uncheck it. Once that’s unchecked, all gridlines between cells across your spreadsheet will disappear from view.
The first method above will hide gridlines as you edit a Google Sheets spreadsheet, but not if you decide to print it. When you print from Sheets, gridlines will cover the area containing any non-empty cells, allowing you to view them separately.
If you want to hide gridlines from printed Google Sheets documents, however, you’ll need to start by opening your spreadsheet and clicking File - Print to open the printer settings menu. In the “Print Settings” menu, select the “Formatting” category option in the menu panel on the right. From the options listed below it, uncheck the “Show Gridlines” option.
Your Google Sheets spreadsheet should now print, showing the contents of your document, but with any visible gridlines removed.
Drop a 👍 on the video and subscribe if you like Google Sheets!
Timestamp
0:00 Why would you do that?
0:31 Removing gridlines
0:58 Gridlines are gone, but..
1:20 Remove gridlines when printing
2:03 Congrats! You learned something new
🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: • 💰 Compound interest calculator templa...
🎥 Common errors: • 🚨 How to solve the #DIV/0! error in E...
🎥 How to tutorials: • How to use UPPER in Excel
🎥 Regular functions explained: • BASIC EXCEL FUNCTIONS
Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel