excel 2003 automatic word wrap?

[Guest]

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

 

[Gord Dibben]

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

Format to word wrap..........and row>autofit.

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Guest]

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