Sometimes you have to hide columns in Google Sheets to make it easier for you to read and analyze the data in spreadsheets. Now comes the time that you are looking for certain information that you are pretty sure is written inside the spreadsheet. But you can’t easily find it! You realize that you have hidden the column where that information is located! How can you unhide that column again?
Step 1: Look for where the hidden column might be located:
Step 2: Locate the box with arrows, which represents the hidden columns.
Step 3: Simply click the box, and voila! That was faster than saying the word “quickly.”
Clicking the box not the only simple technique for this. After finding where the hidden column is located, you may:
Step 1: Select the columns sandwiching the hidden column.
Step 2: Right click on the column names bar above the selected columns. A drop-down list will appear, and the Unhide Column will appear.
Step 3: Click Unhide Column, and, just like that, the hidden column is visible again.
Note: These methods also work if two or more columns in succession are hidden; for example, Columns B, C, and D are hidden!
If you are in a hurry most of the time, you might be using Google Sheets via your smartphone. The step is much quicker via your smartphone:
Step 1: Look for where the hidden column is located.
Step 2: Just click on one of the small arrows on the ends of Columns A and C.
Voila! The hidden column is visible again.