Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Sep 2007
    Location
    Chatham, Kent, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hide/Unhide (2000)

    Afternoon Loungers

    Whilst working on the attached spreadsheet I hid columns B to G.

    There now appears to be no way to unhide the columns! The unhide option is greyed out. Further, if I attempt to hide another column then the whole work book hides!

    Hopefully, someone will tell me I'm missing something simple (brain block caused by being overworked!) otherwise I'm well stuffed!

    Regards

    Graeme

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hide/Unhide (2000)

    A mystery, using Excel 2003 the unhide option was not greyed out.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2007
    Location
    Chatham, Kent, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide/Unhide (2000)

    Tony

    Thanks

    In that case, Heeeeeeeeelp!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide/Unhide (2000)

    What happens if you click on the column header of column A, then drag to the next column, and change the column width, either through Format | Column | Width... or by dragging the right edge of one of the selected column headers?

  5. #5
    2 Star Lounger
    Join Date
    Sep 2007
    Location
    Chatham, Kent, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide/Unhide (2000)

    Sorted!!!

    Selecting columns as per your screen dump and setting the column width to 10 unhides them.

    Window>Hide still hides the whole sheet though and Unhide is still grayed out.

    Still At least I can get on now!

    Thanks again.

    Graeme

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide/Unhide (2000)

    The options in the Window menu apply - as the name indicates - to the entire window. If no windows are hidden, Window | Unhide will indeed be grayed out. To (un)hide columns, you need the Format | Column submenu. Select columns A:N, then select Format | Column | Unhide.

  7. #7
    2 Star Lounger
    Join Date
    Sep 2007
    Location
    Chatham, Kent, England
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hide/Unhide (2000)

    Doh!

    Fairly obvious when you think about it.

    I think I need a holiday.

    I've still not got round to sorting <!post=this post ,413404>this post <!/post> yet!

    Could the Lounge start a new forum for me to help with installing Railway HV substation feeder cables?

    Thanks

    Regards

    Graeme

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hide/Unhide (2000)

    > Could the Lounge start a new forum for me to help with installing Railway HV substation feeder cables?

    Isn't the Hardware forum suitable for that? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •