We are trying to make a form that those that don't know Excel very well can easily use and not have to re-format, etc. to get things to fit on the page.
I have figured out how to format the cells how I want them to look by merging certain cells then locking the ones we don't want changed while leaving other cells unlocked so the user can tab to the fields they need to fill out (we are using "protect sheet).
The difficulty comes when they need to type a narrative in a row where I had to merge several cells together. They want to paste their text and then have the merged cell fit the text.
Or if there's an easier way to insert a field they can tab to and just type what they want - that would be ideal. Currently we are typing what we want in Word and pasting into Excel and then we cannot edit the text, etc. without the user messing up the whole paragraph... and having to stretch the row to fit. Or if we try the Text Box we run into the same thing where the user has to "monkey" with the form.
There's got to be an easier way - right? I know Excel is known for its formulas, etc. that is why we are creating the form in Excel, however, we need to be able to type paragraphs, also. Any ideas?
Bookmarks