MS Excel
- To move vertically but not horizontally then C$1
- To move horizontally but not vertically then $C1
- To fully freeze it $C$1
Input Controls - describes how you can control the range of data or type of data that a user
enters in excel. (useful in designing questionnaires, etc.)
❖ Controlling Data Entry - DROP DOWN LIST
➢ Enter the values (different possible answers that can be given to question) in
excel, ex. “single”, “married”, “divorced”, “unmarried cohabiting”
➢ Select all and give them a name (ex. marital_status)
➢ Write down question and then in seperate cell next to question place your cursor
➢ Select Data → Data Tools → Data Validation
➢ Select List and in Source write: = name you gave values ( ex. = marital_status)
➢ After selecting OK in the cell you selected previously your answers (of single,
married, etc.) will appear in a dropdown list
❖ Controlling Data Entry - OTHER METHODS (create invalid entry by limiting values)
➢ Place your cursor on a cell (any cell)
➢ Select Data → Data Tools → D
ata Validation → Decimal in data validation
Screen
➢ Select “between” under Data in the data validation screen→ enter (for example) a
minimum value of 1,0 and a maximum 10,0 value
, ➢ Select input message and enter a helpful message such as “ Enter any value
between 1,0 and 10,0)
➢ Select Error Alert tab and eventer a helpful message such as “Invalid
entry:please enter any value between 1,0 and 10,0
- To move vertically but not horizontally then C$1
- To move horizontally but not vertically then $C1
- To fully freeze it $C$1
Input Controls - describes how you can control the range of data or type of data that a user
enters in excel. (useful in designing questionnaires, etc.)
❖ Controlling Data Entry - DROP DOWN LIST
➢ Enter the values (different possible answers that can be given to question) in
excel, ex. “single”, “married”, “divorced”, “unmarried cohabiting”
➢ Select all and give them a name (ex. marital_status)
➢ Write down question and then in seperate cell next to question place your cursor
➢ Select Data → Data Tools → Data Validation
➢ Select List and in Source write: = name you gave values ( ex. = marital_status)
➢ After selecting OK in the cell you selected previously your answers (of single,
married, etc.) will appear in a dropdown list
❖ Controlling Data Entry - OTHER METHODS (create invalid entry by limiting values)
➢ Place your cursor on a cell (any cell)
➢ Select Data → Data Tools → D
ata Validation → Decimal in data validation
Screen
➢ Select “between” under Data in the data validation screen→ enter (for example) a
minimum value of 1,0 and a maximum 10,0 value
, ➢ Select input message and enter a helpful message such as “ Enter any value
between 1,0 and 10,0)
➢ Select Error Alert tab and eventer a helpful message such as “Invalid
entry:please enter any value between 1,0 and 10,0
