Results 1 to 4 of 4

Thread: Greyed out columns and rows
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2003
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Greyed out columns and rows

    Some time ago I created a spreadsheet and greyed out the areas that weren't needed. Now I need to expand the spreadsheet and use more columns. Trouble is I've forgotten how to unhide those columns. I didn't write any macros and usings the right-click unhide method is proven futile. The sheet isn't protected which is puzzling since I can't get the mouse to even highlight any of the greyed out areas.

    Any suggestions would be fantastic!
    thanks

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Greyed out columns and rows

    Click the header of the last visible column and drag to the right (you'll see a popup with eg 252C). Then right click and choose Unhide.
    Microsoft MVP - Excel

  3. #3
    Board Regular Mike Blackman's Avatar
    Join Date
    Jun 2007
    Location
    Basingstoke, UK
    Posts
    2,494
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Greyed out columns and rows

    Hi,

    Click the top left corner of the SS adjacent to the A and the 1 in the headers, then on any row or column header right click and hit un-hide. You may have also set the column widths so small that they are not hidden but near impossible to select, if this is the case again highlight all the cells using the previous method, right click on any header and this time try Column Width, set to 5 or 10.
    Regards

    Mikey B

  4. #4
    Board Regular
    Join Date
    Jun 2003
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Greyed out columns and rows

    Many thanks, I'm in business again!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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