Auto fit to content
 

Is there a way of setting up your worksheet so that the cells expand
automatically to fit the content
--
Thank you for reading my post. Hopefully you can answer my querie

Auto fit to content
 

Try,

Format|Cells|Alignment tab
select shrink to fit

Mike

"Shazza" wrote:

Is there a way of setting up your worksheet so that the cells expand
automatically to fit the content
--
Thank you for reading my post. Hopefully you can answer my querie

Auto fit to content
 

This just makes my data unreadable, I wanted it to automatically expand as i
typed into the cell. I assume the answer is no as i have tried jsut about
everything that i can think of :(
--
Thank you for reading my post. Hopefully you can answer my querie


"Mike H" wrote:

Try,

Format|Cells|Alignment tab
select shrink to fit

Mike

"Shazza" wrote:

Is there a way of setting up your worksheet so that the cells expand
automatically to fit the content
--
Thank you for reading my post. Hopefully you can answer my querie

Auto fit to content
 

FormatColumnAutofit or FormatRowAutofit and FornatCellsAlignmentWrap
Text.

Will not expand as you type, only after you hit Enter or Tab or arrow out of
the cell.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 05:24:00 -0700, Shazza wrote:

This just makes my data unreadable, I wanted it to automatically expand as i
typed into the cell. I assume the answer is no as i have tried jsut about
everything that i can think of :(