Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel Data Validation - how to put the validation list on a separate sheet

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
582 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Oct 15, 2010

In Microsoft Excel, if you've tried to validate a cell to a list of values, you'll know that you have to put the validation list on the same sheet as the cell that you're validating, which is usually not what you want.

This tutorial shows you how to put the list on a different sheet.

It is assumed in this tutorial that you've used Data Validation before.

Category:

Education

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (0)

Sign In or Sign Up now to post a comment!
Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more