+ Reply to Thread
Results 1 to 2 of 2

How To Fix Column Width???

  1. #1
    Registered User
    Join Date
    09-22-2011
    Location
    Texas, USA
    MS-Off Ver
    Excel 2002
    Posts
    2

    How To Fix Column Width???

    Hi All,

    I have a little issue with a data sheet i'm working with. One column lists descriptions of products. The descriptions are very long, but the column is somehow formatted to where it is only so wide and the text cuts off, but if I click on the cell the whole text will pop up, and if I click in a different cell not in that column it is normal again.

    Somehow, I did something to the sheet that caused the column to expand so that all the text shows. This caused the column to not only expand but the text to go into other cells. For example, this column is F and row 1 went into AB and row 2 went into CC and row 3 went into AA and so on. I do not know what to do to fix this. Any ideas?

    Thank you,
    Elle

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: How To Fix Column Width???

    It shouldn't be in the other cells, but if they are empty the text will appear over them. If you hover the cursor over the bottom og the Column letter until it changes to a + then ouble click the column will expand
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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