Gridlines help distinguish and separate cells in Google Sheets. This can be useful if you are working on large tables or large chunks of data. So let’s take a look at 3 easy ways you can add or remove gridlines in Google Sheets.
As the name suggests, gridlines help form a grid around the table cells, making each of them stand out from the others. However, this can also ruin the overall look of the document as gridlines can make the document look cluttered. If you are also experiencing this issue, read on as we discuss in detail how to add or remove gridlines in Google Sheets.
Note: Make sure you’re signed in to your Google account before you begin.
1. Add or remove Google Sheets Gridlines from View Menu
The easiest way to remove or add gridlines from Google Sheets is to use the View menu. Just select or deselect the gridlines option to hide or show them. Here’s how to do it.
Step 1: Go to Google Sheets and open the relevant sheet.
Step 2: Click View from the menu bar.
Step 3: Click Show from the options and select Gridlines.
This will display all relevant gridlines in your Google Sheets file. Now, if you want to disable these gridlines, go through the above steps again and uncheck the Gridlines option from the View menu. This will remove the gridlines from the entire worksheet.
Tip: If you want the gridlines to be visible only to a certain part of the worksheet, you can add borders to those areas. Just select a specific range of cells > click the border icon.
2. View or remove Gridlines in Google Sheets with Apps Script
Application scripts allow you to write custom function commands for Google Sheets. You can also use it to integrate your sheets with other Google services like Docs, Calendar, etc. And so by using Apps Script, view or remove gridlines in Google Sheets using a simple true or false command. Follow the steps below to create one for your sheet.
Note: This Apps Script command will be associated with the document in which it was created. If you want to use this command for other sheets, you’ll need to recreate the command using that sheet’s Apps Script menu.
Step 1: Open the Google Sheets file and click on Extensions.
Step 2: Then, click Apps Script.
Step 3: When the Apps Script window opens, copy and paste the code below into the code editor.
function onEdit(e) { var mySheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var myRange = e.range; var mySheetName = mySheet.getSheetName(); var myStatus = myRange.getValue(); var currRow = myRange.getRow(); var currCol = myRange.getColumn(); if ( currRow === 1 && currCol === 1 ) { mySheet.setHiddenGridlines(myStatus); }; };
Step 4: Then click Save Project and Run it.
Step 5: Now, go back to your worksheet and in cell A1, type THAT’S RIGHT to hide the gridlines.
Note: To get rid of gridlines, type WRONG instead of.
Using this method, you can automatically trigger Google Sheets to display or remove gridlines in Google Sheets.
3. Show or hide gridlines when printing sheets in Google Sheets
While gridlines in Google Sheets can be useful while you’re working, you might not want them to show up after the sheet is complete and ready to print. This is where the print settings of Google Sheets can come in handy.
So, let’s see how you can hide or, if necessary, show gridlines in Google Sheets using the print settings menu.
Note: The following steps will only remove gridlines from Google Sheets. If you added borders to the cells, you’ll need to go back to the main sheet and remove them before printing the sheet.
Step 1: Open the relevant sheet and click File.
Step 2: Scroll down and click on the Print option.
Alternatively, you can also use the keyboard shortcut Control + P (Windows) or Command + P (Mac) to open the print settings.
Step 3: Click the Format tab in the print settings bar.
Step 4: Here, uncheck the Show gridlines option.
Step 5: Then, click Next.
Once this is done, follow the on-screen instructions to finish printing your sheet without gridlines.
On the other hand, if you want to display gridlines, then just follow the steps outlined above and when you open the Format tab select the Show Gridlines option. This will allow gridlines to be displayed while printing the Google Sheets file.
Tip: You can also check out our article to fix any problems printing Google Sheets files.
FAQ for using Gridlines in Google Sheets
1. Why are gridlines disappearing in Google Sheets?
Gridlines may disappear in Google Sheets if they are turned off or if a white border is applied to the sheet. To fix this, you can enable gridlines or remove the white border and check if the gridlines show up again in Google Sheets.
2. Can I add gridlines to Google Sheets using the mobile app?
To add gridlines using the Google Sheets mobile app, open the relevant sheet and tap the sheet name. Then scroll through the options and toggle the switch for Gridlines. This will add the gridlines to the entire worksheet.
3. Can I enable table gridlines in Google Sheets?
If you don’t want the gridlines to appear throughout the entire worksheet, adding a border to the table can make the gridlines appear. Click Table Properties and enable the border from the menu options.
Managing Gridlines in Google Sheets
We hope that this article helped you better understand Google Sheets gridlines and how to add or remove them in sheets. You can also check out our other article for more on how you can format tables in Google Sheets.
Categories: How to
Source: thpttranhungdao.edu.vn/en/