In this article:

Tabs Disappeared in Google Sheets (How to Fix It in 2024)

May 8, 2024

What to Do if Your Google Sheets Tabs Disappeared

Below are some common reasons why Google Sheets tabs disappear and what you can do to fix them: 

Browser Zoom and Screen Resolution

Sometimes, the issue might be due to the zoom level of your browser or screen resolution settings. Try resetting the zoom level to the default (usually 100%) by pressing Ctrl + 0 (Cmd + 0 on Mac) or adjusting it manually until the tabs appear. 

Additionally, adjusting your screen resolution may help if the issue is related to how much of the spreadsheet is visible on your screen.

google sheets tabs disappeared

Full-Screen Mode

If Google Sheets is in full-screen mode, it might hide the tabs. You can exit full-screen mode by pressing F11 on Windows or Ctrl + Cmd + F on Mac. 

Google Sheets Glitches

While there aren't specific Google Sheets settings that hide tabs, glitches can occasionally happen. Here are some solutions to consider:

1. Reload the Google Sheets page.

tabs disappeared in google sheets

2. Try opening the spreadsheet in another Google account or sharing it with someone else to see if the issue is account-specific.

3. Check if Google Workspace is experiencing any outages or issues that could be affecting Sheets by visiting the Google Workspace Status Dashboard.

my sheet tabs disappeared in google sheets

Hidden Tabs

If your sheet tabs have disappeared in Google Sheets, it could be because they've been hidden. You can easily unhide these tabs by going to View > Hidden Sheets then selecting the sheets you want to unhide.

If none of these solutions work, consider seeking help from Google's support forums or checking if there are any known issues with Google Sheets at the time.

We hope that this article has helped you and given you a better understanding of how to resolve the issue if your Google Sheets tabs disappeared. If you enjoyed this article, you might also like our articles on how to make a Pareto chart in Google Sheets and how to use the MIN function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->