Hiding worksheets in a spreadsheet application like Microsoft Excel or Google Sheets is an effective may to make it difficult for someone to edit data, but still keep that data available in case you need it later, or in case it needs to be used by a formula.
But you might find that you need to edit some of the data in a hidden worksheet, which can be difficult in Google Sheets if you are having trouble unhiding the sheet in question. Our tutorial below will show you a couple different methods that can help you to unhide a worksheet.
How to Unhide a Tab in Google Sheets
The steps in this article were performed in Google Chrome, but will also work in desktop Web browsers like Firefox or Edge. This guide assumes that you have an existing workbook in Google Sheets, and that this workbook contains at least one hidden sheet.
Step 1: Open your Google Drive at https://drive.google.com/drive/my-drive and select the file containing the worksheet that you want to unhide.
Step 2: Click the All sheets button at the bottom-left of the window.
Step 3: Click the hidden worksheet that you want to unhide. The hidden sheets are a slightly lighter gray color than the visible ones.
You can also unhide a sheet by clicking the View tab at the top of the window, selecting the Hidden sheets option, then clicking on the sheet that you wish to unhide.
Did you create a spreadsheet in Google Sheets, only to discover later that it was missing a full column of data? Find out how to insert a column in Google Sheets and avoid having to manually move all of your data one row to the right, or one row to the left.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.