The Excel Trainer
  • Live Training
  • Free Tutorials
  • Newsletter
  • Partners
  • Contact Mike
Select Page

Define a Validation List Using a Name

Feb 23, 2013

When creating a validation list, it is often neater to store the source of the list on a separate worksheet, away from the main data. In Excel 2007 and earlier, you can’t store the “list source” on a different sheet to where the list will be used,...

Recent Tutorials

  • Do You Want Early Access to Excel Updates?
  • Why You Should NOT Buy Excel 2019
  • Excel – Import a List of Tasks into Outlook
  • Excel – NEW in March 2018: Geography and Stock Data Types
  • Excel – Create a Pivot Table Using Excel Online
  • INDEX & MATCH v VLOOKUP / HLOOKUP
  • Excel Slicers – 2 Pivot Tables Based on Different Data Sources
  • Excel 2010 – Create a Combo Chart
  • Power Pivot and Power Query
  • Excel – What is a Dashboard?

© 2012-2021 - theexceltrainer.co.uk    Privacy Policy