VALIDATION

VALIDATION

Formula Use & Explanation:

Validation is used to create drop down menue’s wherein only predefined data or options, that are set by us, can be entered into a cell, by any other users.

The user will not have any other options other than the ones we specify and will also not be able to type in any other text into the cells that contain the valadation.

Example Used:

Select the Designations of each employee from the options specified.

VALIDATION STEPS IN DETAIL

STEP 1

Before you start prepare a list of options and save it as shown below, this will be required in Step4. (I have saved my list starting from Cell A300)
A very important point to remember is that, never save your data i.e. the list that contains all your options , in a row or column that may accidentally be deleted, always protect the cells if you want to save it in one of the top rows.

STEP 2

First select the empty cells that you require for valadation, as shown below.
Next click on Data from the toolbar and then click on Validation

STEP 3

In the Validation window, select List from the drop down.
On the Source bar click on the box circled in Red

STEP 4

Now go down to the data list that we had saved earlier in Step 1 i.e. in Cell A300.
Select the list and click the small box, circled in red

A completed Validation will look like this:

Page updated

Google Sites

Report abuse