judgejustin
Board Regular
- Joined
- Mar 3, 2014
- Messages
- 150
I need to allow users to enter multiple lines of information into a cell. A cell which I have merged across 4 cells in a row, mostly for aesthetic reasons. There are several things I need the user to be able to do. Keep in mind these will be a wide range of users and they do not have real excel experience. This is a form style set up for them to enter data and have it transfer.
1. Enter information and drop down a line (line break) while staying in the same cell to enter more information. (I will never get them to do Alt + Enter, so I need an easier way.)
2. Auto Size the row height in this cell dependent on how many lines they enter. (Some may need one line some may need 10 or more.)
3. Just for your knowledge the data will be copied over to a couple of different places so I don't think a text box is going to work here, or at least I would not know how to make it work.
Any thoughts?
1. Enter information and drop down a line (line break) while staying in the same cell to enter more information. (I will never get them to do Alt + Enter, so I need an easier way.)
2. Auto Size the row height in this cell dependent on how many lines they enter. (Some may need one line some may need 10 or more.)
3. Just for your knowledge the data will be copied over to a couple of different places so I don't think a text box is going to work here, or at least I would not know how to make it work.
Any thoughts?