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

**melocotones_pmi** · 03-12-2008, 09:00 PM

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.

**shg** · 03-12-2008, 11:14 PM

Format the cell to wrap text?

**Claymation** · 03-15-2008, 07:38 PM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions