Subscribe!

Excel does not allow you to keep your list on separate worksheets. All is not lost though, there is a way around this problem. You can simply name the cells on your other sheet, and then refer to the name in your data validation source.

Highlight the cells that you would like to be the source for your data validation drop-down. Select “Insert” from the menu, choose name=>define, name the range list. Go back to the worksheet that contains the cell that the data validation will be place in and open the data validation box. In the source data box for the list, enter =list. Your data on the other sheet will now be in your new drop-down.

Related posts:

  1. Excel Data Validation Data validation gives the Excel developer a way of dictating...
  2. User Passwords in Excel – Multiple Passwords Simple multiple user password protection in Excel....
  3. Referencing Data in Another Excel Workbook Q: Joe, I have data in another workbook that I...
  4. How to Import XML Data into Excel This article is a quick primer on using XML data...
  5. #VALUE! Error in Microsoft Excel The #VALUE error is an error that is seen almost...

This entry was posted on Tuesday, November 11th, 2008 at 12:05 pm and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Data Validation List on Seperate Sheet”

  1. Analyst Pulpit » Blog Archive » Excel Data Validation on November 11th, 2008 at 12:07 pm

    [...] have your data validation list on a separate sheet, see this: Data validation list on seperate sheets Bookmark It Hide [...]

Leave a Reply

You must be logged in to post a comment.