Excel: Validation Lists

Submitted by BinksUK on

Because I keep forgetting...

Type list in separate sheet
Highlight all values
Give a name in the name box (top left ish)
Go to where you want the list
Click on tools - validation
Select list type
type =the_list_name
done

(it's the equals sign I keep forgetting)

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

More information about text formats

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.