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

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?

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

Click the blank square above the row 1 and to the left of column A in order
to select all cells in the spreadsheet and then right-click anywhere within
the highlighted area and select Format Cells from the popup menu that
appears. Next, click the Alignment tab on the dialog box that appears and
put a check mark in the box with the caption "Wrap text". Then click OK.
Now, click anywhere to remove the highlighting. If you now type into a cell,
the text will wrap on word boundaries when it reaches the right side of the
cell. Make your columns as wide as necessary.

Rick

Hey that worked like a charm, Rick. Thanks a bunch.
--
befuddled


"Rick Rothstein (MVP - VB)" 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?

Click the blank square above the row 1 and to the left of column A in order
to select all cells in the spreadsheet and then right-click anywhere within
the highlighted area and select Format Cells from the popup menu that
appears. Next, click the Alignment tab on the dialog box that appears and
put a check mark in the box with the caption "Wrap text". Then click OK.
Now, click anywhere to remove the highlighting. If you now type into a cell,
the text will wrap on word boundaries when it reaches the right side of the
cell. Make your columns as wide as necessary.

Rick