Microsoft Office Tutorials and References
In Depth Information
P ASTE Y OUR V ALIDATION L IST
Click in the cell that
contains your validation
Click the Home tab.
Click the Copy button in
the Clipboard group.
Select the cells in which
you want to place the
Click Paste in the
A menu appears.
Click Paste Special.
l The Paste Special dialog box appears.
Click Validation (
Excel places the validation list in the cells
l When users make an entry into the cell,
they must pick from the list.
Did You Know?
Validation lists can consist of numbers,
names of regions, employees, products,
and so on.
To remove a validation list, click in any cell that contains the
validation list you want to remove, click the Home tab, and
then click Find and Select in the Editing group. A menu appears.
Click Go To Special. The Go To Special dialog box appears. Click
Data validation, click Same, and then click OK. The Go To
Special dialog box closes. Click the Data tab and then click
Data Validation in the Data Tools group. A menu appears. Click
Data Validation. The Data Validation dialog box appears. Click
Clear All and then click OK.
Chapter 1: Boost Your Efficiency