Wrap Text
 

Am using MS Excel 2003, Wrap Text wrked the first few entries, then I go to
Format, Cells, Alignment and check Wrap Text. Why isn't Excel remembering to
wrap the text?

When I first started, highlighted the Letter on top, and did the above. The
other thing is that I don't want to have to hit Alt and Enter everytime
either.

Thanks!

Wrap Text
 

The scope of a setting is not always clear whether it applies to
all use of Excel, entire workbook, entire worksheet, selection of cells

Everything under Format, Cells applies to a selection of cells.
You could select all cells and apply wrap text.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Whiskey14" wrote in message ...
Am using MS Excel 2003, Wrap Text wrked the first few entries, then I go to
Format, Cells, Alignment and check Wrap Text. Why isn't Excel remembering to
wrap the text?

When I first started, highlighted the Letter on top, and did the above. The
other thing is that I don't want to have to hit Alt and Enter everytime
either.

Thanks!

Wrap Text
 

"David McRitchie" wrote:

The scope of a setting is not always clear whether it applies to
all use of Excel, entire workbook, entire worksheet, selection of cells

Everything under Format, Cells applies to a selection of cells.
You could select all cells and apply wrap text.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Whiskey14" wrote in message ...
Am using MS Excel 2003, Wrap Text wrked the first few entries, then I go to
Format, Cells, Alignment and check Wrap Text. Why isn't Excel remembering to
wrap the text?

When I first started, highlighted the Letter on top, and did the above. The
other thing is that I don't want to have to hit Alt and Enter everytime
either.

Thanks!




Hi David,

I did that. Selected all cells, Format, Cells, Alignment, Wrap Text. For
some reason, after 10 or so entries, Excel forgot the setting, now I have to
do it everytime. Any other suggestions?

Have tried rebooting, thinking perhaps memory was low but that didn't help
either.

TIA!

Wrap Text
 

The problem is probably that because you are using Excel 2003
that you are not selecting all of the cells. Ctrl+A no longer selects
all cells -- evidently no top 10 company has complained about this.
You can use the gray button between the row and column headers
to select all cells -- nowhere near as good as Ctrl+A because the
activecell gets changed. Other alternatives are to hit Ctrl+A until
all cells are actually selected or to use a macro, see
http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar

Also if you manually adjust the row height then you are obligated
to continue to do so. Merged cells also interfere with automated
row height.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Whiskey14" wrote in message
I did that. Selected all cells, Format, Cells, Alignment, Wrap Text. For
some reason, after 10 or so entries, Excel forgot the setting, now I have to
do it everytime. Any other suggestions?