Automatically expand cells to match the data contained
 

Hello,

When a bring up Excel sometimes all of the columns are compressed to a
standard size and therefore the data is unreadable ie ########, is there an
Excel command that will expand each column out to a size that will match the
width of the data so the data is readable?.....within sizing limits of course?

Thanks very much!
--
bobk

Automatically expand cells to match the data contained
 

Select the columns, & then use Format/ Column/ AutoFit Selection
--
David Biddulph

"bobk544" wrote in message
...
Hello,

When a bring up Excel sometimes all of the columns are compressed to a
standard size and therefore the data is unreadable ie ########, is there
an
Excel command that will expand each column out to a size that will match
the
width of the data so the data is readable?.....within sizing limits of
course?

Thanks very much!
--
bobk

Automatically expand cells to match the data contained
 

Hi Bobk
Go to "Format - Column- Autofit Selection.
Regards
Cimjet

"bobk544" wrote in message
...
Hello,

When a bring up Excel sometimes all of the columns are compressed to a
standard size and therefore the data is unreadable ie ########, is there
an
Excel command that will expand each column out to a size that will match
the
width of the data so the data is readable?.....within sizing limits of
course?

Thanks very much!
--
bobk