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