if Cell is full then move to next cell

**Davo** · 03-10-2010, 05:30 PM

This sounds fairly simple to do but I can't think of how to actually do it.
I would like to have about 15 cells available to type text into (they are stretched to be about the size of half a page long and the normal height of a line. I don't want to merge the cells together) and I would like to be able to start in the first cell and when the text comes to the end of that space (not the total amount the cell can hold but the space shown as if you were writing on a piece of paper) you are moved down to the next cell down without having to press enter.

Can that be done?

**JBeaucaire** · 03-10-2010, 05:43 PM

No. Once you start typing in a cell, all Excel interactivity is suspended until you release control by pressing enter.

**rwgrietveld** · 03-10-2010, 06:09 PM

JB is right. To be able to do what you want, data input needs to be done via e.g. a textbox.

EDIT: Added an example

See attachement

Note: For testing I set the string length to 5, please adjust to your needs !