Excel Drop Down List
© Ted French
A drop down list gives you a set number of entries to choose from when entering data. Not only can this speed up data entry, but it can also prevent people from misspelling entries or even from entering the wrong data altogether.
When creating a list, it is often a good idea to store the data for the list on a different worksheet from the list itself.
The advantages for doing this include protecting the list data from accidental or intentional change.
To find out how to store the list data on a separate worksheet, read the tutorial on Creating a Drop Down List in Excel.Related Tutorials
Simply desire to say your article is as surprising. The clarity in your post is just
great and i can assume you are an expert on this subject.
Well with your permission allow me to grab your RSS feed to keep
updated with forthcoming post. Thanks a million and please keep up the
rewarding work.