Editing drop down data in Excel 2007

[vikingant]

I have just upgraded to 2007 and am using a spreadsheet I created in the old excel that has a drop down box.

I have extra data that needs to be included in the drop down, but cannot find how to edit the range.

I even tried to create the drop down from scratch but it wont let me select the range from a different worksheet.

Any suggestions?
Thanks
Ant

 

[Von Pookie]

Re: Editing drop down data in ecxel 2007

You have to use a named range if you want to have the list and dropdown on separate sheets.

For example, you want the list on Sheet1 to refer to Sheet2!$A$1:$A$5, you have to name that range on sheet 2 first. Then for your dropdown list, you would use =RangeName as the list source.

Also: http://www.contextures.com/xlDataVal08.html#Refer