Hidden Column A in Excel

Solved
c6l73 Posted messages 2 Registration date   Status Membre -  
 Lo -
Hello,
I'm working on a document in Excel 2007. I first filtered the data in column A before hiding it.
But now I can't display it anymore. I've tried the usual methods: going to it, searching for it, selecting everything before clicking "unhide" but nothing works. The data is there because if I type A1, the column title appears in the formula bar.

I don't know how to recover this damn column A. Is it a bug in 2007 or is it because I applied a filter before hiding it?

I hope you can help me.
Thanks to everyone.
Configuration: Windows 2003 Internet Explorer 7.0

1 réponse

man1999 Posted messages 90 Registration date   Status Membre 19
 
Hi

I tried and it works:

you disable the filter.
you select column B and then the one with the line numbers (logically 2 columns selected)
then right-click on B and then show

--
Cheers
Man 1999
0
c6l73 Posted messages 2 Registration date   Status Membre
 
That's great... finally the solution!
Thank you very much.
0
Ol V
 
you just need to unfreeze the panes (View > Freeze Panes) and you can access column A again without any issues. Then you can re-freeze the panes if you want.

It must be a bug in Excel 2007 ...
5
Lo > Ol V
 
Thank you very much!!!
0