Excel spreadsheet Query?

Question

I'm doing a spreadsheet for a database and what I want to be able to do when filling out the spreadsheet is, in one particular column I want users to only be able type certain things (or select from 2 options) i.e YES or NO. Can anyone help?

Answer 1

go to (office 2003)

view>toolbars>forms

in offfice 2007 check out these links...

http://office.microsoft.com/en-us/excel/...

http://www.homeandlearn.co.uk/excel2007/...

hope this helps

Answer 2

you can use the "validation" feature of Excel.

in some cell (say A1 & A2) enter "Yes" and "No"

then select your input cell (let's say B1)

go to Data > Validation  (in excel 2003)

(For excel 2007 go to Data ribbon and select the Data Validation option)

select the "List" option

in the formula area, highlight cells A1 & A2.

you can also go to the other tabs and put a custom error message (like "you can only select yes or no").

now when someone goes to B1 they'll see the drop down list.  If they try to type anything else in, they'll get an error message

Answer 3

Simplest way I think for you (presumably using pre 2007 version) is, Data, List and create your list of Yes, No so that your users click on the downward arrow and make their choice. Presumably you have all other cells protected so that they can't overwrite your formulae etc.

Answer 4

you would be better creating this as an actual database in Access instead of using Excel. In database you can set up the columns to use YES/NO, text, number etc