How to Remove Gridlines in Google Sheets

Marty Youssef
Last updated on
December 26, 2023

Tired of the relentless gridlines cluttering your Google Sheets workspace?

You're not alone.

Those default gridlines, while helpful, can sometimes make your spreadsheet look too busy, especially when you're working with large amounts of data or preparing a sheet for presentation.

But fear not, there's a sleek, gridline-free solution in store! This tutorial will walk you through the steps to remove gridlines in Google Sheets.

Let's jump in the tutorial!

How to Remove Gridlines in Google Sheets

Step 1: Open Your Google Sheets Document

First, open the Google Sheets document where you want to remove the gridlines. You can do this by navigating to Google Sheets and opening your desired file.

Step 2: Access the View Menu

Once your document is open, look at the top menu bar. Click on the "View" option. This will drop down a menu with various viewing options.

Step 3: Toggle Off Gridlines

In the dropdown menu under "View," you will see an option labeled “Gridlines.” This option is usually checked by default. Simply click on it to uncheck this option. As soon as you click, the gridlines in your entire sheet will disappear.

Toggle Gridlines off on Google Sheets

Step 4: Confirm the Changes

After you've toggled off the gridlines, take a moment to confirm that your sheet now appears as you intended. Remember, this change affects the entire document, not just the currently selected cells or sheets.

Gridlines Off in Google Sheets

How to Remove Gridlines in Google Sheets On Mobile

Removing gridlines in Google Sheets on a mobile device involves a few simple steps. This process can help make your spreadsheet look cleaner and more readable, especially when working on a smaller screen. Here's how to do it:

Step 1: Open the Google Sheets App

Start by launching the Google Sheets app on your mobile device. Open the spreadsheet where you want to remove the gridlines.

Step 2: Tap on the Sheet to Access Sheet Options

Once you open the spreadsheet, tap on the sheet itself. This action will bring up the sheet options, allowing you to modify various settings.

Sheet Options To Remove Gridlines Google Sheets Mobile

Step 3: Access the View Settings

In the sheet options, look for the “View” settings. This is where you'll find the options to alter the visual display of your spreadsheet.

Step 4: Toggle Off Gridlines

Within the view settings, locate the “Gridlines” option. By default, gridlines are usually turned on. Tap on the option to toggle off the gridlines, which will remove them from your current view in the spreadsheet.

Google Sheets Settings To Remove Gridlines

Step 5: Confirm the Changes

After you have disabled the gridlines, return to your spreadsheet to ensure that the gridlines are indeed no longer visible.

Google Sheets On Mobile Without Gridlines

How to Remove Gridlines from Specific Cells in Google Sheets

Unfortunately, Google Sheets doesn't allow for the direct removal of gridlines from specific cells. However, here's a clever workaround to achieve a similar effect. This can be particularly useful when preparing a workbook for presentations, where you want only certain cells to have visible borders.

Here’s how you can do it:

Step 1: Remove Default Gridlines

  • Navigate to View , then select Show: First, open your Google Sheets document. Go to the top menu and click on “View.” In the dropdown menu, hover over “Show.”
  • Uncheck Gridlines: In the expanded menu, you'll find the option “Gridlines” checked by default. Click on it to uncheck. This action removes all gridlines from your workbook, setting a clean slate for you to add new lines.
Toggle Gridlines off on Google Sheets

Step 2: Select Areas for Gridlines

Select Desired Cells: Click and drag your mouse to select the cells where you want to reintroduce gridlines.

Select Areas for Gridlines in Google Sheets

Step 3: Add Custom Borders

  • Access the Border Icon: With your cells selected, look for the “Border” icon in the toolbar. This icon typically looks like a square with borders indicated on it.
  • Choose 'All Borders' Option: Click on this icon and select the “All Borders” option. This action will add borders to each cell within your selected area, mimicking the appearance of gridlines.
Add Custom Borders in Google Sheets

Step 4: Customize Border Color (Optional)

Select Your Preferred Border Color: Feel free to pick a border color of your choice. This allows you to tailor the appearance of your custom gridlines to your personal preference or to match the theme of your workbook. Choosing a color that differs from the default black can give your sheet a unique and customized look.

Customize Border Color in Google Sheets

Step 5: Review Your Sheet

Review Your Sheet: Now, only your selected cells will have the newly added gridlines. It’s a good idea to review your sheet to ensure everything looks as expected.

Review Your Custom Gridlines in Google Sheets


By removing the default gridlines and selectively adding borders to specific cells, you can create a customized look in your Google Sheets document. This technique is especially useful for presentations where you need to highlight certain data areas while keeping the rest of the sheet clean and uncluttered.

Marty Youssef
Marty is a digital marketer with over 8 years working with clients to introduce word class software solutions for their business.