Show hidden columns in EXCEL

No problem. So try this.

Select your entire sheet (by clicking on the small square above row 1. You see the one located to the left of column D in your case)

Your entire sheet is selected.

Click on Format --> Columns --> Show.

And you're all set.
I'm telling you this on Excel 2003, if you have 2007, convert these steps with what you need.

Hello,
For me too, the panes were frozen, so the explanations given earlier didn’t work.
So, I went to View/Freeze Panes/Unfreeze Panes and my columns A B C became accessible.

the problem is that the hidden columns are A, B, and C, so when I do this manipulation, my entire sheet gets selected and it doesn't work...

So click on E and without releasing go to A and release.

Now click between E and F (without releasing) and widen a bit)

I just tested it on Excel and it's OK

I shouldn't do what needs to be done because it only expands the displayed columns.
But since A is also hidden, it must come from that, right?

it still doesn’t work either... no matter what I do, it doesn’t change anything at all...

Hello,

Select the entire sheet by clicking on the small square located at the top left at the intersection of the rows and columns, then go to Format menu, Column => Show.

m@rina
--
- "On the office forum, questions about office software are asked..."
- "Oh really???""

Hello,
I was intrigued by this problem.
After hiding columns A, B, C in Excel 2007, I clicked on the header of column D and dragged it left (a tooltip indicated that 4 columns were selected). Then I double-clicked at the intersection of the column D header and the rectangle. Nothing happened.
However, by then activating cell D1 and dragging left, columns A, B, C reappeared!!!
Another problem, when selecting a column and clicking on the Hide button in the View tab, the entire sheet gets hidden instead of just the selected column!!!
Final note: if you hide an empty column, you cannot make it reappear. The only solution is to use the Go To... command, enter something, and repeat the process to display the column (reminder, the mouse pointer takes the shape of a cross with two small arrows on the horizontal line).

See you later

pépé

So, Lucie? All sorted or not?
--
Retirement is good! Especially in the Caribbean... :-)
☻ Raymond ♂

That's it! Thank you very much!!!

Hello

for fun a macro

Sub Macro1()
ActiveWindow.FreezePanes = False
Cells.EntireColumn.Hidden = False
Cells.EntireRow.Hidden = False
Range("A1").Select
End Sub

See you +

Maurice

Hello m@rina,

It's this order that I don't see the use of.
However, when it comes to "finding" the other order, we can't say that Microsoft has kept it simple. Fortunately, there's the right click for the columns.

Have a good day

pépé