** How to Hide (and Unhide) Columns in Excel Without Losing Your Mind**
We've all been there: a spreadsheet with 30 columns, and you only care about five of them right now. Deleting the rest feels wrong (what if you need them later?), and scrolling forever feels worse. The answer is hiding columns — and it takes about five seconds once you know where to click.
Here's the trick that trips people up: you have to click the column letter, not a cell inside it. If you right-click a cell, Excel gives you a totally different menu (Cut, Copy, Insert, that kind of thing) with no Hide option in sight. Click the letter at the very top of the sheet — the "A," "B," "C" row — and you'll get the column-specific menu instead.
Hiding Columns
- Click the letter of the column you want to hide.
- Want to hide several in a row? Click the first letter, then drag across to the last one.
- Want to hide a few that aren't next to each other? Hold ⌘ (Mac) or Ctrl (Windows) and click each letter individually.
- Right-click on your selection.
- Choose Hide Columns.
That's it. The column vanishes, but nothing is deleted — the data's just tucked out of sight.
Unhiding Columns
This is the part people usually get stuck on, because there's no column letter to click when the column itself is invisible. The trick is to select the columns around the hidden one.
- Click the column letter just before the gap.
- Hold Shift and click the column letter just after the gap.
- Right-click anywhere in that selection.
- Choose Unhide Columns.
One Handy Tip
Not sure if you've got a hidden column somewhere? Look closely at the column letters along the top. A hidden column leaves a subtle tell: you'll see something like D | F, with no E in between, and the line separating them is just a touch thicker than usual. Once you know what to look for, it's easy to spot.
And that's genuinely it — no plugins, no formulas, just two clicks and a right-click. Small trick, but it makes messy spreadsheets a lot easier to live with.
Top comments (0)