Data Validation

Resolved · Low Priority · Version 2007

Thu 1 May 2008, 20:33 Delegate Rakhi said...

Rakhi has attended:
Excel Advanced course

Data Validation

What is Data Validation?

Sun 4 May 2008, 16:17 Trainer Cress said...

RE: Data Validation

It a way of ensuring only a set series of data (usually from a list box) is enetered into a cell. If the value is always Yes or No then you want them to choose either option rather than typeing Yes rather than putting Y, Yeah or Correct. The following tutorial might help you understand it:
http://www.contextures.com/xlDataVal01.html

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

Data Validation

Data Validation

RE: Data Validation

Excel articles

Excel tip:

Highlighting a data range