Sample Excel Forms Provided

Please take a look at the form examples for Excel created by the author as one example of an accessible form that uses the techniques discussed in this training. There are two versions, one for Excel 97-2003 and one for Excel 2007.

EXERCISE: As you move through and explore this form, take notice of some of the different elements within it as follows:


  1. Hyperlinks reside in cells D1 through D6
  2. Some cells are merged to provide a more uniform look. Using Office 2007, after selecting two or more cells to merge, press ALT followed by H, then M, and then choose to either merge and center or merge cells only.
  3. Cell A21 contains a title using the Name feature in Excel that reads to JAWS and or MAGic users the column headers such as Quantity, Unit of Measure, Description, and Cost per Unit when navigating from left to right in those particular columns. To learn more about how to use the Name feature to create titles in Excel please read the DAISY book entitled Column and Row Titles in Excel (DAISY 9.7MB) found on the Training Downloads Web page.
  4. The Quantity column has a validation type of "any value" and has no error alert.
  5. The Unit of Measure column has a validation type of "list" and uses the information error alert, which allows the end-user to either choose something from the list or to type in something that does not exist in the list.
  6. The Description column has a validation type of "any value" and has no error alert.
  7. The Cost per Unit column has a validation type of "decimal" and has a stop error alert. In this particular case the end-user is limited to a value between zero dollars and $1000. The currency format in Excel was also applied to the items in this column.
  8. Cell D27 contains a formula that calculates the total cost for the items requested. The formula multiplies the quantity times the cost per unit for all items entered and then sums them all.
  9. The Date Needed By field has a validation type of "date" and in this particular instance the author assumes the company began in the year 2005, so there is a stop alert applied that requires date input greater than 12/31/2004.

Prior page

Next page