Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Location
    Bristol, Avon, England
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhide Column A (file imported from Lotus) (Excel 97)

    Hi,
    This is my first time on the forum - hope someone can help. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>
    I have imported a Lotus 123 file (.wk4) into Excel 97 and columns A:C have been hidden. I have tried selecting the whole worksheet and unhiding the columns but no joy. A colleague tells me that there is a particular issue with Excel when unhiding Column A which require a different approach. My other thought is that the Lotus file may have some form of protection which doesn't translate well in to Excel.

    Regards

    Graham

  2. #2
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unhide Column A (file imported from Lotus) (Excel 97)

    Graham,
    Try this (It works on the standard Excel sheet):

    GoTo (key F5) A:A

    Then from the menu, select Format | Column | Width...

    The width should show 0. Change that to nearly anything, like 10, and the column will open up.

    Errol

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Unhide Column A (file imported from Lotus) (Excel 97)

    You might also try WINDOW - Unfreeze panes.
    Steve

  4. #4
    New Lounger
    Join Date
    Jul 2003
    Location
    Bristol, Avon, England
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unhide Column A (file imported from Lotus) (Excel 97)

    Thanks Errol/Steve - you've saved the day!

    Graham

Posting Permissions

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