Excel Pick List - What is it for?

What is the Excel Pick List feature? Maybe you are not familiar…

Simple. It eases your data entry! When you needs to enter volume of data into Excel spreadsheet, then this feature is a ‘must-have’ to use!

Why? It speed up your data entering process so you can accomplish the task faster.

Let’s see how it works.

To use a Pick From Drop-down List

Say you have entered the following data.

Right-click on the cell directly below the existing list.

From the pop-up menu, select Pick From Drop-down List and you will see the following.

Click on the required item. In this example, we selected the word Bala. It is then displayed as illustrated.

Get FREE ebooks! (Click for more info) Subscribe to... MS Office Tips Newsletter

E-mail Address: First Name: Then Don't worry -- your e-mail address is totally secure. I promise to use it only to send you MS Office Tips.

Can't find what you're looking for? Try Google Search!

	Enter your search termsSubmit search form
	Web www.msoffice-tutorial-training.com

Back to Top

Recommended book:

Revealed! 101 Excel Secrets

You're viewing the Excel pick list info page, click here to go back to the Home Page