Google Sheets · Verified tutorial
Verified by JosephineAbout 75 seconds
Columns disappeared in Google Sheets
A data column is hidden. Unhide every column in the sheet without changing any values.
Verified by JosephineAbout 75 secondsQuick answer
A data column is hidden. Unhide every column in the sheet without changing any values.
Step-by-step
1
Select the targetA data column is hidden.
2
Apply the changeUnhide every column in the sheet without changing any values.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
All columns are visible and the data is unchanged.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Undo the last change, reselect the intended range, and try again. All columns are visible and the data is unchanged.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Name | Team | Score |
| Anna | Blue | 8 |
| Ben | Green | 6 |
| Cara | Blue | 9 |
Video transcript
- Open the prepared Visibility repair spreadsheet.
- Select the target. A data column is hidden.
- Apply the change. Unhide every column in the sheet without changing any values.
- All columns are visible and the data is unchanged.