Fillable Forms in Excel?

**james_tang** · 09-06-2007, 10:00 AM

Hi,

I'm trying to create a feedback form in Excel that I can send out and have people fill out and send back. It consists of a text line, a radio button, a place to put a date, and a textbox a couple of lines high.

Is there any way to make radio buttons and sort of blank out the cells that the recipients won't be filling in? Basically, I need to make the sheet more like a professional form rather than just a formatted Excel sheet where people fill in cells.

Thanks,
James

**SamuelT** · 09-06-2007, 10:51 AM

Hi,

Regarding professional form style:

Formatting. Nice colours. Perhaps fill all the cells a colour, then make the ones you want filling in white (perhaps apply a border to these too). You could then lock all the cells you don't want people using and protect the sheet, therefore meaning they can only fill in what you want and not fiddle with the forms look.

If the form is only going to be the size of one screen - i.e. you don't have to scroll up and down - if you select all the cells on the screen, then Freeze Panes, the user will not be able to scroll outside of the area you want displaying.

Radio Buttons:

View > Toolbars > Control Toolbox. A little toolbar will open, on here is a radio button. Conversely, on the same tool bar there are text boxes that you could also use instead of actual cells in the spreadsheet.

Any queries, let me know.

SamuelT

**james_tang** · 09-06-2007, 11:29 AM

Samuel,

Thanks! That helped a lot.

Only thing is, I'm not really sure how to work the Radio buttons. What I have is a list of a few locations, and for each location, the user should select either Yes or No.

Can you help me with this?

Thanks,
James

**SamuelT** · 09-06-2007, 11:52 AM

Hi James,

Thanks for the reply. It strikes me (and I may be wrong

) that a lot of what you want you could do in Excel without buttons and text boxes etc and that you're over-complicating matters in search of your goal.

For example, you could use validation drop-downs instead of the radio buttons, and perhaps have a cell that uses conditional formatting to show if the answer is yes or no.

I've quickly knocked together an example (attached). If you must use radio buttons, etc let me know.

Cheers,

SamuelT