Forms and data validation

Before following these instructions, you might want to take a look at a blog post I wrote about forms and how to make them accessible. There is a section here dedicated to Excel forms.

Create a Form

Creating forms
Outcome Keyboard Dragon command
Colour the input cells
  1. Select the range of cells you want to apply colour to
  2. Alt
  3. H
  4. J
  5. ↓ / ↑ / ← / → to select a 20% accent
  6. Enter
  1. Select cell [ref] to cell [ref]
  2. Home
  3. Cell styles
  4. Go down [number] to select a 20% accent
  5. Press enter

Data Validation

Data validation
Outcome Keyboard Dragon command
Create an input message
  1. Go to the input cell where you want to give an input message
  2. Alt
  3. A
  4. V to open the Data Validation menu
  5. V to open the Data Validation dialogue
  6. → to go to Input Message
  7. Tab x 2 to the Title field
  8. Type in a title
  9. Tab to the Input Message field
  10. Type in a brief input message
  11. Tab x 2 to OK
  12. Enter
  1. Go to cell [ref]
  2. Data
  3. Data validation
  4. Input message
  5. Title
  6. Dictate a title
  7. Tab to move to Input Message field
  8. Dictate a brief input message
  9. OK
Set data type and range
  1. Alt
  2. A
  3. V
  4. V
  5. ← if the Settings tab is not already selected
  6. Tab to Allow
  7. ↓ to browse data types
  8. Enter to select chosen data type
  9. Tab to other fields
  10. ↓ to browse data types
  11. Enter to select chosen data type
  1. Go to cell [ref]
  2. Data
  3. Data validation
  4. Settings
  5. Allow
  6. Say what you see
  7. OK when you have finished
Provide error message
  1. Alt
  2. A
  3. V
  4. V
  5. → to the Error Alert tab
  6. Tab to Title field
  7. Type a title for this error alert
  8. Tab to Error Message field
  9. Type an error message
  10. Enter to select chosen data type
  1. Go to cell [ref]
  2. Data
  3. Data validation
  4. Error alert
  5. Title
  6. Dictate a title for this error alert
  7. Error message
  8. Dictate an error message
  9. OK
Clicky