Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
list? Or you can use the same technique to simply create a designated list from a group of data. This enhanced feature of Microsoft Excel 2003 makes it easier to visualize your list and it provides you a lot of options right up front without having to turn on various features of your list. Let's start by selecting the range of cells that contain your list. Going up to the Data menu, and you may need to expand your menu in order to see the list functionality, and here under the List menu we have Create List. Let's go ahead and select that or you can see you can use Control+ L, and it verifies the range of my list and again we have a choice of adding headers or not. Because I have titles I do want headers. I'll say OK, and you can see all of the various functions that we have inside of our list. We have the AutoFilter drop downs available to us. If I just deselect that range you'll see a border that's been applied. Now the blue indicates a border that is currently not active. If I click anywhere inside of my list, that border thickens up again drawing our eye to the fact that this is a list of information and you'll also notice that when we use the Form feature, the Form feature allowed us to enter data in a very structured way, and it placed the new record at the bottom of our list. Well when you create a designated list you'll see we have an empty row automatically inserted at the end with an asterisk indicating to us that we're going to enter new data here. If I click inside of that row I can begin entering another record, let's say Big Fish, and this is primarily a Drama, Fantasy element, and Comedy, 2003.
When I hit Enter, it goes back to the beginning of the next new row and allows me to enter data again. So instead opening up the Form dialog box, we can go ahead and enter right into our list in still a very structured way. Designated lists is a good addition to the list functionality within Excel, and overall lists are extremely useful, again inside or outside of the office.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70586 Viewers
80 Video lessons · 127667 Viewers
52 Video lessons · 62560 Viewers
59 Video lessons · 48267 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.