When working with Google Sheets, you may at times want to hide certain columns without deleting their data. The challenge, however, comes in when you want to view the hidden columns again. Don’t worry! In this blog post, we’ll guide you on how to view hidden columns in Google Sheets.
Why hide columns in Google Sheets?
There are several reasons why you might want to hide columns in Google Sheets. You might want to hide irrelevant data, sensitive information, or just reduce clutter on your spreadsheet. The good news is that Google Sheets allows you to hide as many columns as you like and still access them whenever you want.
How to view hidden columns in Google Sheets
To view hidden columns in Google Sheets, follow the simple steps below:
Step 1: Open your Google Sheet
The first step is to open the Google Sheets document that contains the hidden columns.
Step 2: Identify the hidden columns
Columns are hidden in between visible ones. For instance, if you see columns A, B, and D, but column C is missing, then column C is hidden.
Step 3: Unhide the columns
To unhide the columns, you need to select the columns surrounding the hidden one. If column C is hidden, select columns B and D. Then, right-click and select the “Unhide columns” option.
Unhiding Multiple Hidden Columns
If you have multiple consecutive hidden columns, you can unhide them all at once. For example, if columns C, D, and E are all hidden, select columns B and F. Then, right-click and select the “Unhide columns” option.
Conclusion
As you can see, viewing hidden columns in Google Sheets is not as complicated as it may seem. It’s all about knowing where to look and what to do. Hopefully, this guide has made the task easier for you. Happy data organizing!