Versions Compared

Version Old Version 18 New Version 19
Changes made by

Daniel LaGrow

Daniel LaGrow

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Think of Data Validation as a way to assist people to filling out the form correctly. They act like post it notes or hints with little instructions. When using Data Validation, be sure to give a clear message and provide all relevant information.

To use Data Validation,

  1. Create your form and click in one of the fill in boxes.

    Military Registration form with the fill in cell for Date of Birth highlighted.

  2. Click the Data Tab, then choose Data Validation

    Data Tab in Microsoft Excel.Data Validation Button in Microsoft Excel.

  3. In the Data Validation Box, choose Input Message. Then type in some instructions that will help the reader with the form. Click OK. Your end result should show a yellow square with your instructions inside it.

    Data Validation box with Input Message Tab open. Input message section provides instructions.Military Registration Form with the Date of Birth fill in section highlighted. There are instructions next to it in a yellow box.

...