O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Defining a Valid Set of Values for a Range of Cells

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.

Defining a Valid Set of Values for a Range of Cells

You can use the Data Validation dialog box to define the type of data that Excel should allow in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required