Wrap Text

[Guest]

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!

 

[David McRitchie]

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.

 

[Guest]

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.

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!

 

[David McRitchie]

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/shortx2k.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.