3 Ways To Add Or Remove Gridlines In Google Sheets

• Open Google Sheets > relevant worksheet > View > Show > select Gridlines.
• Go to the Google Sheets file > Extensions > Apps Script > copy-paste app script > Save project > type TRUE in the A1 cell.
• Open the relevant sheet > File > Print > Formatting tab > uncheck the Show gridlines option > Next > finish the process.

Method 1: Add or Remove Google Sheets Gridlines From View Menu

The easiest way to remove or add gridlines from Google Sheets is using the View menu. Simply check or uncheck the gridlines option to hide or make them visible. Here’s how to do it.

Step 1: Go to Google Sheets , open the relevant worksheet , and click on View . Click on Show and select Gridlines .

If you want to disable these gridlines, follow the above steps and uncheck the Gridlines option from the View menu. This will remove gridlines from the entire worksheet.

Tip: If you want gridlines to be visible only for a certain section, add borders to those areas instead. Simply select the specific range of cells > borders icon.

Method 2: View or Get Rid of Gridlines in Google Sheets With an Apps Script

Apps script lets you write custom function commands for Google Sheets. So, using Apps Script, view or get rid of gridlines in Google Sheets with a simple true or false command. Follow the below steps to create one for your worksheet.

Note: This Apps Script command will be bound to the document it was created for. If you wish to use this command for other sheets, you need to create it again using that sheet’s Apps Script menu.

Step 1: Open the Google Sheets file and click on Extensions . Click on Apps Script .

Step 2: Once the Apps Script window opens, copy and paste the below script into the code editor section.

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 3: Click on Save project and run it.

Step 4: Now, go back to your worksheet, and in the A1 cell type TRUE to hide the gridlines.

Note : To get rid of gridlines, type FALSE instead.

This will allow you to automatically trigger Google Sheets to show or get rid of gridlines. If you have any issues, clear the cell content and try again.

Method 3: Show or Hide Gridlines When Printing a Sheet in Google Sheets

While gridlines in Google Sheets can help when you’re working, you might not want them to be visible once the sheet is done and ready to be printed. Here’s where the Google Sheet’s print settings might come in handy. Here’s what to do.

Note: If you’ve added borders to the cells, go back to the main worksheet and remove them before printing the sheet.

Step 1: Open the relevant sheet and click on File . Click on Print .

Tip: You can also use the Control + P (Windows) or Command + P (Mac) keyboard shortcut to open print settings.

Step 2: Click on the Formatting tab and uncheck the Show gridlines option.

Step 3: Click on Next and follow the on-screen instructions to finish.

If you want gridlines to show, follow the abovementioned steps and check the Show Gridlines option. This will make gridlines visible when printing the Google Sheets file.

Gridlines can disappear in Google Sheets if they’ve been turned off or if a white border is applied to the sheet. To fix this, either enable gridlines or remove the white border and check if gridlines are visible again in Google Sheets.

To add gridlines using the Google Sheets mobile app, open the relevant sheet > worksheet name > turn on the toggle for Gridlines. This will add gridlines to the entire sheet.

If you don’t want gridlines to appear in the entire worksheet, then adding borders to the table can give the appearance of gridlines. Click on Table properties and enable borders from the menu options.

Was this helpful?