Microsoft Office Tutorials and References
In Depth Information
P ASTE Y OUR V ALIDATION L IST
1
2
3
Click in the cell that
contains your validation
list.
5
2
Click the Home tab.
1
6
3
Click the Copy button in
the Clipboard group.
7
4
Select the cells in which
you want to place the
validation list.
4
8
5
Click Paste in the
Clipboard group.
A menu appears.
6
Click Paste Special.
l The Paste Special dialog box appears.
7
Click Validation (
changes to
).
8
Click OK.
Excel places the validation list in the cells
you selected.
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.
Remove It!
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
5
 
Search JabSto ::




Custom Search