automatic cell resize

[xman123]

In my excel spreadsheet, i type a lot of information into individua
cells. Most of the time this information carys on to anonther line an
i have to resize the cell by hand if i want the information to print.

How can i create a macro to resize these cells automatically? Pleas
help

 

[CWillis]

If you format the cells the same way each time, you can record a macro
(Tools>Macro>Record New Macro) while you format one cell. Then, each time
you need to reformat a new cell, you can run that macro. (If you do this, be
careful that the macro runs the formatting on the active cell.) You could
also make the macro do this formatting on every cell with text it in by
changing a portion of the code. I know I'm being vague. If you give more
info on formatting, which cells, etc, I may be able to help more.

-Chris