Prev: Run time 1004
Next: How do I find my previous post ?
From: PurseGirl24 on 22 Jan 2010 16:34
I want to create a form in Excel that I can send out so people can fill it
out electronically and then send it back to me. I need lines in the form and
when I add lines I have to widen the column and then it messes up the
previous wording. I know it can be done but not sure if I have to protect
it, create a template (how do I do that), or lock some of the cells. Help!

From: Gord Dibben on 22 Jan 2010 17:03
For lines have you considered simply bottom borders?

i.e. wording in A1 bottom borders on B1:E1

Or lines drawn from the Drawing Toolbar.

No need to widen any columns.

Save the workbook and send it out to users to fill in and send back after
they save it under a new name.


Gord Dibben MS Excel MVP


On Fri, 22 Jan 2010 13:34:01 -0800, PurseGirl24
<PurseGirl24(a)discussions.microsoft.com> wrote:

>I want to create a form in Excel that I can send out so people can fill it
>out electronically and then send it back to me. I need lines in the form and
>when I add lines I have to widen the column and then it messes up the
>previous wording. I know it can be done but not sure if I have to protect
>it, create a template (how do I do that), or lock some of the cells. Help!

From: trip_to_tokyo on 23 Jan 2010 01:26
Hi PurseGirl.

Please check out my web site:-

http://www.pierrefondes.com/

- and go to item number 42 where I show you how to set up and use a Form.

I think this is what you want (but am not sure).

If my comments have helped please hit Yes.

Thanks.



"PurseGirl24" wrote:

> I want to create a form in Excel that I can send out so people can fill it
> out electronically and then send it back to me. I need lines in the form and
> when I add lines I have to widen the column and then it messes up the
> previous wording. I know it can be done but not sure if I have to protect
> it, create a template (how do I do that), or lock some of the cells. Help!
>
 | 
Pages: 1
Prev: Run time 1004
Next: How do I find my previous post ?