Excel formatting question

[timcadieux]

I made a spreadsheet and made a particular Row able to Wrap Text becuase i'm expecting alot of text in that cell. However, all the rows i have that do NOT have enough text to make it wrap have more Height to them than necessary. If i set the Row Height manually, then they no loger wrap, how can i fix this?

 

[SkipVought]

Hi,

Use the AutoFit feature.

Select Cells (the Button just above the Row 1 and to the left of Column A)

Double click on any Row and/or Column boundary.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[timcadieux]

Unfortunatly, when i do that, nothing changes, it's almost as if there were some AFTER Paragraph formatting?

 

[SkipVought]

Please describe in detail the formatting of the cell(s) that wrap and AutoFit properly and the cell(s) that do not.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[timcadieux]

Working Cell

Text Align
Horiz - Left
Verti - Top
Wrap Text = True
Font Arial 10


This is the Cell Format for all, whether they work or not.

 

[SkipVought]

Do you have cells MERGED?

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[timcadieux]

yes, A few at the very top of the spreadsheet where i have my Page Title. Not within the information Table itself.

 

[SkipVought]

If the AutoFit feature is not working AT ALL, then you are not activating it properly.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[timcadieux]

ok, i'll try some more and get back tamara, thank you!