excel 2003 automatic word wrap?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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 to expand...

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
 
Back
Top