How to View or Hide Gridlines in Google Sheets on an iPhone

To view or hide gridlines in Google Sheets on an iPhone, open the spreadsheet in the Sheets app, tap the name of the sheet tab at the bottom of the screen, then tap the switch next to Gridlines. The change applies only to that sheet tab, and you can switch it back the same way at any time.

These steps are for the Google Sheets app on iOS 27 and work the same on iPad; computer, Android, and printing have their own sections.

Install the Google Sheets App

  • The app. You need the Google Sheets app, signed in to the Google account that can open the file. If you do not have it, Google Sheets is a free download in the App Store. Updating the app first avoids most “missing setting” problems.
  • Edit access. Hiding or showing gridlines changes the sheet itself, so you need to be able to edit the file. If someone shared it with you as view only or comment only, ask the owner for edit access or make your own copy.
  • One sheet at a time. Google treats gridlines as a property of each individual sheet, not of the whole file. A spreadsheet with three sheet tabs has three separate gridline settings.
  • It is shared. Because the setting is saved in the file, other people who open that sheet see the same result. It is not a private view that only affects your phone.

How to View or Hide Gridlines in the Google Sheets iPhone App

  1. Open the Sheets app on your iPhone.
  2. Tap the spreadsheet you want to change. It opens with the sheet tabs in a row at the bottom of the screen.
  3. Tap the sheet tab you want to change so it is the active one. The active tab is highlighted.
  4. Tap that same tab name again, or tap the small Down arrow on the tab. A menu of options for that sheet opens. Google documents this menu as the place to duplicate, rename, or delete a sheet on iPhone and iPad.
  5. Find Gridlines in the menu. You may need to scroll down a little to see it.
  6. Tap the switch to the right of Gridlines. Switch it off to hide the gridlines, or on to show them.
  7. Tap anywhere on the spreadsheet to close the menu.
Gridlines row from the Sheets iPhone sheet-tab menu, with its green on switch and row outlined in red
The sheet-tab menu’s Gridlines control. On shows gridlines; off hides them. Menu appearance varies by app version. (Recreated interface)

How to Confirm It Worked

Look at an empty area of the sheet. With gridlines hidden, blank cells run together as one plain background and only your data, fill colors, and borders remain. With gridlines shown, you see the light gray lines around every cell again. There is no save button. Google Sheets saves the change for you.

How to Undo It

Open the same sheet tab menu and tap the Gridlines switch again. Nothing is deleted when you hide gridlines. Your values, formulas, and formatting stay exactly as they were.

Gridlines vs. Borders in Google Sheets

These two kinds of lines look similar, and mixing them up is the most common reason the gridlines switch seems not to work.

Comparison card showing the difference between gridlines and cell borders in Google Sheets
Illustration: gridlines are a setting for the whole sheet tab, while borders are formatting on the cells you choose.

Gridlines are a display setting for a whole sheet. They are either all on or all off, and you cannot change their color or thickness. Borders are formatting that you apply to specific cells, with a style and color you choose. When Google first added the option to hide gridlines, it described the result as leaving only the borders you had added. That is still how it works: borders stay visible after gridlines are hidden.

This is useful. If you want lines around a table but nowhere else, hide the gridlines and then add borders to just that table. The iPhone steps are in Google’s guide to editing and formatting a spreadsheet: select the cells, tap Format, open the Cell tab, and use Borders, Border style, and Border color. For more on each option, read about adding or removing borders in Google Sheets.

How to Hide Gridlines for Only Some Cells

There is no setting that hides gridlines for part of a sheet. The switch covers the entire sheet tab. You have two workable options on an iPhone.

  • Hide everything, then add lines back. Turn off Gridlines, select the cells that should have lines, and apply borders to them from Format > Cell > Borders.
  • Cover the gridlines in a small area. Leave gridlines on, select the cells you want to look blank, and give them a white Cell fill color or white borders from the same Cell tab. If the sheet uses a colored background, pick that color instead of white so the cells blend in. This does not turn anything off. It only places formatting over the lines, so to bring the gridlines back in that area later, remove the fill color in Google Sheets from those cells.

The first option is usually cleaner, because you are not left with hidden formatting that someone else has to find later. Merging cells also removes the lines inside the merged area, but only merge cells for titles and labels, since a merge changes how the cells hold data.

How to Show or Hide Gridlines on a Computer

If you cannot find the setting in the app, or you have many sheet tabs to change, a computer is quicker.

  1. Open the spreadsheet at sheets.google.com in a web browser.
  2. Click the sheet tab you want to change at the bottom of the window.
  3. Click View in the menu at the top.
  4. Point to Show.
  5. Click Gridlines. A check mark next to it means gridlines are visible. No check mark means they are hidden.

You can also press Alt + / on Windows or ChromeOS, or Option + / on a Mac, to open the Tool finder search box (formerly called search the menus). Type “gridlines” and press Enter to flip the same setting. The shortcut appears in Google’s list of Google Sheets keyboard shortcuts.

Because the setting lives in the file, the sheet looks the same the next time you open it in the iPhone app. To use the rest of that Show menu, learn how to show formulas and gridlines in Google Sheets. If you change dozens of tabs regularly, a short Apps Script on a computer can hide gridlines on every sheet at once, but that is optional and the menu works fine for a few tabs.

On an Android Phone

The Android app uses the same idea. Tap the sheet tab, tap the tab again or its Down arrow, and turn the Gridlines switch off or on. The setting is saved in the file, so it shows up on your iPhone too.

Lines That the Gridlines Switch Does Not Control

Some lines in a spreadsheet come from features with their own settings. If lines remain after you hide gridlines, and they are not cell borders, check these.

  • Tables. Google Sheets can convert a range into a table with a name, column types, and its own formatting. Google’s tables help page lists Show gridlines under Table formatting in the table menu on a computer. That option only affects the table, not the cells around it.
  • Charts. The lines inside a chart are chart gridlines. On a computer, double-click the chart, click Customize, and open the Gridlines section (called Gridlines and ticks for some chart types) to change or remove them (more in Google’s chart customization help).

Gridlines When You Print or Export

Hiding gridlines on screen doesn’t decide what prints. In the web version of Google Sheets, click File > Print, open Formatting in the side panel, and check or clear Show gridlines. The same Formatting option appears when you click File > Download > PDF (.pdf). Both choices affect only the printout or PDF, not the sheet.

Google’s iPhone printing steps (More > Share & export > Print) don’t include a gridlines option, so check the preview. If you need lines on paper, add borders or print from a computer. For other print settings, read about printing a Google Sheet on one page, and check the result after you convert a Google Sheet to PDF or Excel.

Troubleshooting: The Gridlines Setting Is Missing or Does Not Work

Checklist of things to check when the gridlines setting will not change in the Google Sheets iPhone app
Illustration: what to check, in order, when the gridlines setting does not change.
  • You do not see Gridlines in the menu. Make sure you opened the sheet tab menu at the bottom of the screen, not the More menu at the top. Scroll within the menu. If it is still not there, update Google Sheets in the App Store and try again.
  • The menu does not open, or the switch is grayed out. You probably have view-only or comment-only access. Ask the owner for edit access. A file that is still in Microsoft Excel format can also behave differently from a native Google Sheets file.
  • Lines are still there after you hide gridlines. Those are usually cell borders. Select the cells, tap Format, open the Cell tab, and clear the borders. If the lines sit inside a table or a chart, see the section above.
  • Gridlines are on, but some cells have no lines. A cell fill color, including white, can cover the gridlines, and merged cells do not show lines inside the merged area. Reset the fill color for those cells to bring the lines back.
  • Only one tab changed. That is expected. Repeat the steps on each sheet tab.
  • Someone else changed it back. Anyone with edit access can flip the same switch. Agree on the look with the people you share the file with.

Once the gridlines look the way you want, you can keep tidying the sheet from your phone. Add borders around the tables that need them, or insert a picture in Google Sheets if the sheet needs a logo or photo.

Sheets iPhone Gridline Questions

Does hiding gridlines in Google Sheets delete anything?

No. Hiding gridlines only changes how the sheet looks. Your data, formulas, and formatting are untouched, and you can turn the gridlines back on with the same switch.

Can I hide gridlines on every sheet at once on an iPhone?

No. The gridlines setting belongs to each sheet tab, so you have to open the sheet tab menu and tap the Gridlines switch on each tab you want to change.

Can I change the color of gridlines in Google Sheets?

No. Gridlines can only be shown or hidden. If you want darker or colored lines, hide the gridlines and add cell borders in the color and style you want.

Will other people see the gridlines I hid?

Yes, they will see the sheet without gridlines too. The setting is saved in the spreadsheet, so it follows the file to every device and every person who opens that sheet.

Are the steps the same on an iPad?

Google publishes one set of Sheets instructions for iPhone and iPad, and the sheet tab menu works the same way on both. The larger iPad screen may place the menu differently.