3 Ways to Add or Remove Gridlines in Google Sheets

Ankita enjoys exploring and writing about technology. Starting as a script and copywriter, her keen interest in the digital world pulled her towards technology. With GT, she has found her calling in writing about and simplifying the world of tech for others. On any given day, you can catch her chained to her laptop, meeting deadlines, writing scripts, and watching shows (any language!).

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 toGoogle Sheets, open the relevantworksheet, and click onView. Click onShowand selectGridlines.

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 theGoogle Sheets fileand click onExtensions. Click onApps Script.

Step 2:Once the Apps Script window opens,copyandpastethe belowscriptinto the code editor section.

Step 3:Click onSave projectand run it.

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

Note: To get rid of gridlines, typeFALSEinstead.

This will allow you to automatically trigger Google Sheets to show or get rid of gridlines. If you have any issues,clear the cell contentand 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 relevantsheetand click onFile. Click onPrint.

Tip:You can also use theControl + P(Windows) orCommand + P(Mac) keyboard shortcut to open print settings.

Step 2:Click on theFormattingtab and uncheck theShow gridlinesoption.

Step 3:Click onNextand 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.

Also Read:How to change default font in Google Sheets

FAQs

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?

Last updated on 27 August, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Internet and Social

How to Move Photos from Email to Google Photos

4 Ways to Fix Cast Button Missing on YouTube

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.