.png)
How to Quickly Unhide Columns in Google Sheets
Step-by-step tutorials on how you can unhide columns in Google Sheets on both your desktop and smartphone! We'll take you through the toggle and right-click options.
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?
Unhide Columns on Desktop/Laptop
Via Unhide Arrows
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.”
Via Right-Click
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!
Unhide Columns on Smartphone
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.
