Drop Down List in Excel 2007

D

Dan

I would like to choose a name that I have created from a Drop Down List and
then be redirected to the corresponding cell in the spreadsheet.
 
G

Gord Dibben

The name is a defined rangename you created in Insert>Name>Define?

And this name refers to a particular cell?

Would be easier to click on the NameBox and select the name from there.

Or F5 and pick the name from there and OK


Gord Dibben MS Excel MVP
 
Top