+ Reply to Thread
Results 1 to 4 of 4

Excel not displaying two columns

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    Costa Rica
    MS-Off Ver
    Excel 2007
    Posts
    2

    Excel not displaying two columns

    So, to start answering your first questions, they are not hidden. My spreadsheet suddenly starts with column C, yet when I put my cursor on a cell there and arrow left, I can see the contents of Column B and A, yet I'm unable to move further left to view these columns. I have hidden and unhidden columns before, even column A and that is not the issue. Why is Excel refusing to let me view those two columns?

    I'm using Excel 2010 on Windows 7.
    Last edited by suestaurus; 09-30-2011 at 09:25 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Excel not displaying two columns

    Hi suestaurus and wecome to the forum,

    Try to select columns A:C and then Format Column Width and make it some number like 5 to see if that is the problem.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Excel not displaying two columns

    Another option is to turn off "Freeze Panes".

    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  4. #4
    Registered User
    Join Date
    09-30-2011
    Location
    Costa Rica
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Excel not displaying two columns

    That's exactly what it was, the panes were Frozen. I've never seen them disappear though. I freeze panes all the time to view data but I must've done something wrong, obviously. Thank you for your assistance.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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