+ Reply to Thread
Results 1 to 5 of 5

Columns "disappeared"

  1. #1
    Registered User
    Join Date
    11-23-2009
    Location
    Somewhere between heaven and hell
    MS-Off Ver
    Excel 2007
    Posts
    11

    Columns "disappeared"

    I have a spreadsheet here that the last column is AL. I am using Normal view and usually, you can see an "unlimited" (I know there is actually a limit of number of columns per sheet) number of columns. But this sheet, there is no more column after column AL. I want to see the columns after AL, how can I do that? I tried removing the print area, that didn't work. I can insert columns after AL which can solve my problem since I just need another 10 columns after AL. But I would like to know what cause the columns from not displayer. Would it be like you can set how many sheets per workbook when you open a new one?

    Can someone point me in the right direction on this problem? Thanks.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Columns "disappeared"

    Sounds like columns are hidden.

    Click the select all button (above row 1, left of column-A), then right-click on a column-A and choose "Unhide". Make sure when you right-click not to deselect the cells.
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Registered User
    Join Date
    11-23-2009
    Location
    Somewhere between heaven and hell
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Columns "disappeared"

    I can sellect all but when I right click there is no "unhide" option. Where can I find "unhide"? I am using Excel 2007.

    Thanks again.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,374

    Re: Columns "disappeared"

    Home Ribbon - Format (in the cells section) - Hide & Unhide - unhide columns

  5. #5
    Registered User
    Join Date
    11-23-2009
    Location
    Somewhere between heaven and hell
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Columns "disappeared"

    Woohoo!!! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1