excel 2003 automatic word wrap?
 

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

excel 2003 automatic word wrap?
 

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?

excel 2003 automatic word wrap?
 

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

excel 2003 automatic word wrap?
 

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