Docs tower · floor

How to unhide columns in Excel, including column A

How to unhide columns in excel is a right-click for most of the columns in a worksheet and something else entirely for one of them. Column A has its own Microsoft support page and its own search demand, which is a fair indication of how many people get stuck on it — and the reason is a single sentence of geometry.

The ordinary case, and how to see it coming

Everything here is from Microsoft’s page on hiding and showing.

The tell: “The double line between two columns is an indicator that you’ve hidden a column.” On a wide sheet this is easier to miss than with rows, because column letters skipping from C to F is a small change to notice.
The method: “Select the adjacent columns for the hidden columns”, right-click them, then Unhide.
The shortcut: “Or, double-click the double line between the two columns where hidden columns exist.” Fastest when you can see exactly where the gap is.
All at once: Select the whole worksheet, then Home › Cells › Format › Hide & Unhide › Unhide Columns. Microsoft’s caveat applies: this “displays all hidden rows and columns … which you may not want to do”.

And the reason the command sometimes is not there at all: “If you don’t see Unhide Columns or Unhide Rows, make sure you’re right-clicking inside the column or row label” — the lettered strip along the top, not the cells beneath it.

“If the first row (row 1) or column (column A) is not displayed in the worksheet, it is a little tricky to unhide it because there is no easy way to select that row or column.”

Microsoft, read 22 August 2026. Column A is a searched-for problem in its own right, and this is why: the usual method needs the columns on both sides, and column A only has one. There is nothing to the left of it to include in the selection.

Two ways in, both from the same page. The Name Box, beside the formula bar: type A1 and press Enter. Or Home › Editing › Find & Select › Go To, with A1 in the Reference box. Either one puts the cursor in a cell you cannot click on.

Then Home › Cells › Format › Hide & Unhide › Unhide Columns. There is also a simpler route Microsoft gives for the web version: “right-click the column B header or label and pick Unhide Columns”.

One thing that cannot be the cause, and it saves you time

When rows go missing, a filter is one of the likeliest explanations — Microsoft describes filtered data as showing “only the rows that meet criteria that you specify” and hiding the rest. Note the word: rows.

A filter does not remove columns. So if letters are missing from the top of your sheet, filtering is not what happened, and you can stop looking for a funnel icon. It is one of four things: the columns are hidden, one of them is column A, the width has been set to almost nothing, or you are right-clicking in the wrong strip.

That last possibility for width is worth checking before you conclude anything, and it uses the same menu: Format › Cell Size › Column Width, then type a value. A column at a width of zero looks exactly like a hidden one and will not respond to Unhide.

Why this is worth two minutes rather than one click. A spreadsheet that arrives with columns missing usually arrived that way on purpose: somebody hid the working columns before sending it, or hid a column of costs before showing the sheet in a meeting. Unhiding everything is the fastest way to see the data and also the fastest way to put something on screen that was deliberately taken off it. If the file came from someone else, unhide the specific gap rather than the whole sheet.

And the reverse, if you are the sender. Hidden columns are not removed — they are in the file, and one right-click away for anybody who receives it. Hiding is a tidying device, not a redaction. If a column genuinely must not travel, the answer is to delete it from a copy of the workbook, and to check afterwards that no formula elsewhere still refers to it.

One small habit that prevents the confusion entirely. When you hide working columns in a sheet other people will open, put a note in a cell at the top saying which letters are hidden and why. It takes a line, it survives being emailed, and it turns a puzzle into a piece of information.

The methods, the double line indicator, the note about column A, the Name Box and Go To routes, the right-click tip and the description of what a filter hides are quoted from Microsoft’s own Excel documentation, read on 22 August 2026 and listed below. The point that a filter cannot explain missing columns, and the advice about hiding as tidying rather than redaction, are ours.

Where to start

Four ways in.

“The letters skip from C to F.”: Ordinary case — the ordinary case
“Column A is gone.”: It needs a different route — column a
“Unhide is not in the menu.”: Check where you are right-clicking — the ordinary case
“Could it be a filter?”: No, and that saves you time — what it cannot be

The ordinary case

Select either side and right-click, or double-click the double line. Both are Microsoft’s, and one of them is much faster.

Hidden rows in ExcelThree clicks — and the four reasons they fail, including the one where the rows were never hidden.Open this floor → Freezing rows in ExcelOne rule from Microsoft explains every case.Open this floor → Wrapping text in ExcelTwo ways to break a line in a cell, and the two documented reasons the wrapped text stays invisible.Open this floor →

Column A

It has no neighbour on the left, so the usual method has nothing to grip. Microsoft gives it its own page.

Sorting alphabeticallyOne word in Microsoft’s first step keeps your rows together.Open this floor → Merging cells in ExcelMicrosoft says merging deletes the other cells, and merged blocks break everything downstream.Open this floor → Lock cells in ExcelEvery cell is already locked, so the real job is unlocking the ones people should edit.Open this floor →

What it cannot be

Filters hide rows, not columns. Ruling that out immediately leaves four possibilities instead of five.

Comparing two workbooksMicrosoft’s tool is restricted to enterprise Windows — and one helper column does the job anywhere.Open this floor → Removing duplicates in ExcelThree tools and only one deletes, and what Excel actually counts as a duplicate.Open this floor → PDF to ExcelWhat survives the conversion, and the numbers that arrive as text.Open this floor →

Before you send it on

A hidden column is still in the file. Hiding tidies a sheet; it does not remove anything from it.

Checkboxes in ExcelHere the box is the cell’s value, so the ticks can be counted.Open this floor → Drop-down lists in ExcelPut the source in a table so it updates itself, and the option that decides whether the list is enforced.Open this floor →

Customer data and the lawWhat you are holding about other people, and what it obliges you to do.Being built

What this tower will not do

It will not give one method for every column. Column A has no left-hand neighbour, and Microsoft gives it a page of its own for that reason.

It will not send you looking for a filter. Filters hide rows, so a missing column is never that.

And it will not describe hiding as a way of removing something. A hidden column is in the file, one right-click away. What holds instead is simple: the methods, the note about column A and the description of what a filter hides are quoted from Microsoft’s own Excel documentation, with the date each page was read.

Where this page got its facts

Microsoft Support — Hide or show rows or columns, including the double line indicator, the right-click method and the double-click shortcut — support.microsoft.com, read 22 August 2026.
Microsoft Support — Unhide the first column or row in a worksheet, including the note that there is no easy way to select column A, the Name Box and Go To routes, the column B right-click, the Column Width option and the tip about right-clicking inside the column label — support.microsoft.com, read 22 August 2026.
Microsoft Support — Filter data in a range or table in Excel, for the statement that filtering hides rows that do not meet the criteria — support.microsoft.com, read 22 August 2026.

Written by Alberto Gulotta

Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.

Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.

Written on 22 August 2026.

Independence and limits

No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.

This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.