How do I create a form in Excel that I can send to be filled out?

P

PurseGirl24

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!
 
G

Gord Dibben

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
 
T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a form in Excel 1
Create Fillable PDF Forms With LibreOffice Writer 3
How do I create a cell that must be filled before anything else? 2
How do I create a feedback form? 1
How May I create a form 2
How do I create a form that can be filled in on the computer 1
how do I block users to save the excel file if conditions not met 1
How do I set up an electronic form with fixed wording? 2

Top