Ctrl + a(twice in 2003) to select all cells.

Format to word wrap..........and rowautofit.

If you mean by default on all new workbooks or worksheets, you would have to
create a template with these settings.


Gord Dibben MS Excel MVP


On Sun, 24 Jun 2007 09:55:01 -0700, befudd
wrote:

Is it possible to have Excel automatically wrap text as required in any cell
of a worksheet, instead of copying formating to individual cells?