Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Restrict input into cell array
Hello, New to the Excel forum. I have a question on restriciting the number of inputs into a range of cells to only a single entry. I'm building a Lickert-type scale from 0 to 10 (disagree - agree) for a school pilot study. I have restricted the individual cells to limit input to the appropriate value for the individual cells of the scale (e.g. you can only input a 5 into the '5' cell and so on). I don't know how to make sure that the respondents don't type in more than a single value within each scale. If someone has an idea how to do this or what terms to use in Excel Help the assistence would be much appreciated. Thanks. Dan -- dlp1848 ------------------------------------------------------------------------ dlp1848's Profile: http://www.excelforum.com/member.php...o&userid=27558 View this thread: http://www.excelforum.com/showthread...hreadid=470852 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Input cell information | Excel Discussion (Misc queries) | |||
Entering array in single cell | Excel Discussion (Misc queries) | |||
what is the format for an input cell? | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) |