Am setting up a table for my DVD collection, so far, so good. Under the Notes column where I put in information regarding the movie, I've been going to Format, Cells, Alignment and clicking Wrap Text to get how I want it. Is there a way where the text would wrap without me doing that for every movie?

TIA

How about selecting the colums or rows first and apply the wrap text to all of them, so when u type, it will wrap the text itself where it is needed.

hadi88

To expand on what hadi said, just click the header of the Notes column, then format it for Word wrap.

I've tried that, it worked for the first few entries, then I had to go to Format, Cells, Alignment, Wrap Text. For some reason, Excel isn't remembering the setting for Wrap Text. Any other suggestion?

If you highlight the whole column it should remember it.

Hi Scott,

Did that before adding any information, then again when it forgot. Just added two more entries, again I had to do the "Format, Cells, Alignment, Wrap Text". Checked for spyware and viruses thinking perhaps that could be the problem, nothing found except for the usuall cookies. This is happening in Excel 2003 and 2007.