• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Support Your Tech

Instructions and tutorials to help you get the most from your applications and devices

  • Android
  • Excel
  • Word
  • iPhone
  • Mac
  • Docs
  • Slides
  • Sheets
  • Streaming
You are here: Home / Google / Sheets / Two Ways to Unhide a Worksheet in Google Sheets

Two Ways to Unhide a Worksheet in Google Sheets

December 31, 2019 By Matt Jacobs

Working with large files in spreadsheet programs like Google Sheets or Microsoft Excel often requires some adjustments that often aren’t considered with smaller files. One such adjustment involves hiding unneeded worksheets.

But if you are hiding a worksheet rather than deleting it, then it’s usually because the sheet contains important or useful data that you might need to reference or edit later. Luckily it’s a fairly quick process to unhide a hidden worksheet in Google Sheets.

Our guide below is going to show you two different ways that you can unhide a worksheet tab in Google Sheets. Both methods are fairly similar in length, so you can use whichever option is most comfortable to you.

Method 1 – How to Unhide a Worksheet in Google Sheets from the Bottom of the Screen

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Edge.

Step 1: Sign into your Google Drive at https://drive.google.com and open the Sheets file containing the worksheet that you want to unhide.

Step 2: Click the button with four horizontal lines at the bottom of the window.

click the button with four lines

Step 3: Select the hidden worksheet that you want to unhide. Note that hidden worksheets are a slightly lighter color. I am unhiding Sheet2 in the picture below.

click the sheet to unhide

The next section will show you how to unhide a worksheet in Google Sheets from the menu at the top of the window.

Method 2 – How to Unhide a Worksheet from the View Menu in Google Sheets

As with the previous section, these steps are performed in the desktop version of the Google Chrome browser.

Step 1: Sign into Google Drive and open the Sheets file you wish to modify.

Step 2: Click the View tab at the top of the window.

click the View tab

Step 3: Select the Hidden sheets option, then click on the hidden worksheet that you want to unhide.

how to unhide a worksheet in Google Sheets

Find out how to freeze a row in Google Sheets if you would like to be able to see a row, or a couple of rows, at the top of the screen even when those rows should be hidden as you scroll down the sheet.

Matt Jacobs

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Related

Primary Sidebar

Recent Posts

  • How to Show Contact Photos in Messages on an iPhone 11
  • How to Sign Out of Spotify on an iPhone
  • How to Flip a Picture in a Microsoft Word Document
  • How to Announce Messages with Siri on an iPhone 11
  • How to Clear Spotify Cache on an iPhone

Featured Posts

How to Turn Off Restricted Mode in YouTube on an iPhone 11

What is a Watermark in Microsoft Word 2016, Word 2019, or Word for Office 365?

Can I Open a Google Slides File in Powerpoint?

How to Remove All Row Shading in Excel for Office 365

How to Turn Off Javascript in Safari on an iPhone

How to Merge Cells in Google Sheets

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Privacy Policy
  • Affiliate Disclaimer
  • Contact Us
  • About Us

SupportYourTech.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com.

Copyright © 2021 SupportYourTech.com