auto wrap columns

[imported_unknown]

When you add new data and a column becomes too long, is it possible to have the data at the bottom of the column automatically go to the top of the next column? What about to the next sheet? I know I can do this in WORD, but can't figure out how to do it in EXCEL.

 

[Derek]

Hi there
One way:
If you select an area, say A1:G10, and while selected type into A1, press enter, type into A2, press enter etc etc when you get to A10 your next entry will automatically go into the next column B1
Another way might be to protect your sheet and use an event macro to restrict selection to unlocked cells only
hope this helps
regards
Derek