+ Reply to Thread
Results 1 to 3 of 3

##### when entering large texts into a cell.

  1. #1
    Registered User
    Join Date
    03-12-2008
    Posts
    1

    ##### when entering large texts into a cell.

    I am unsure how to explain this so my problem is clear but... I am entering fairly large chunks of text into a cell. When I'm done and move on to the next one this appears instead :

    ######################

    If I double click on the cell, then my text (magically!!!) re appears... I really need the text to stay there as it is for a quick quote guide and I don't want to be having to click on everything... This does not happen all the time however, and it does not seem to matter how big I make the box (it happens with texts of the same size in boxes of different sizes). How can I stop it from happening at all?

    Thank you in advance for your help!

    Help!

    Melissa.
    Last edited by melocotones_pmi; 03-12-2008 at 09:36 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,501
    Format the cell to wrap text?

  3. #3
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    199
    If you want to simply autofit the entire worksheet, just highlight everything (CTRL + A) and then double click on a column, and then on a row. This will then autofit all of the columns and rows for the entire sheet.

    If you wrap the text as was suggested, doing the autofit with the rows will allow you to see all of the text as well and increase the height.

    If the cell is blank this feature will leave the size of the blank cells as the default.

    Hope that helps.

+ 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