View original (French)

Hidden Column A in Excel

Solved
c6l73 Posted messages 2 Registration date   Status Member -  
 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 answer

  1.
    man1999 Posted messages 90 Registration date   Status Member 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
    1. c6l73 Posted messages 2 Registration date   Status Member
       
      That's great... finally the solution!
      Thank you very much.
      0
    2. 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
      1. Lo > Ol V
         
        Thank you very much!!!
        0