Loading...

Create Drop Down List in Excel Worksheet Cell

96,395 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Dec 23, 2010

http://www.contextures.com/xlDataVal0... In an Excel worksheet, you can create a drop down list in a cell, or group of cells.

Instead of typing, people can just select from that drop down list, to prevent typing mistakes and invalid entries.

The list can be stored on a different worksheet, as long as you give the list a name.

Watch this video to see how to name a list, and then create drop down lists in the worksheet cells, based on that list.

These instructions are for Excel 2007 and Excel 2010.

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...