• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel Lists

DiscoStu

Dirty kapitalist spekulant
Joined
Aug 20, 2007
Messages
8,154
Likes received
211
Thanks received
101
Location
Andyw's mum's house
I'm trying to amend a spreadsheet - it has a single worksheet, with several drop down fields that are populated by lists. I can view the name of the list by going into the Data > Validation option, but it doesn't tell me where the list is located. Is there an easy way to find this out?
 
If the data source is defined by a name then look under Insert > Name > Define to see it.
 

Advertisers

Back
Top