• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Focusing on Specific Data Usi... > Defining a Valid Set of Values for a...

Defining a Valid Set of Values for a Range of Cells

Part of creating efficient and easy-to-use worksheets is to do what you can to ensure that the data entered into your worksheets is as accurate as possible. While it isn’t possible to catch every typographical or transcription error, you can set up a validation rule to make sure the data entered into a cell meets certain standards.


To create a validation rule, you open the Data Validation dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint