Identify your Excel data as a list
Identify your data as a list in Excel so that you can get automatic subtotals and dynamically expand your list.
Here are the steps to follow in this video lesson:
- Select one cell in your data and then click Data, List, Create List. The keyboard shortcut is Ctrl+L.
- Verify that Excel has identified the range of cells for your list and click OK.
- Notice that Excel has drawn a blue border around your list; added drop-down filter menu arrows; and added a floating List Toolbar.
- Scroll down to see that there is an * in the 1st blank row beneath your last record in the list. You can add additional records here and Excel expands your list dynamically.
- You can also add a new column / field and your list expands to include it.
- The Toggle Total Rows button adds an AutoSum to the last column. You can change the Function that it uses by clicking the drop down arrow next to any cell in the Total row.
- You can have multiple “lists” in the same worksheet when you identify your data as a list.
August 12th, 2010 at 5:32 AM
Almost all quality improvement comes via simplification of design, manufacturing… layout, processes, and procedures.
August 12th, 2010 at 6:26 AM
Thanks for your comment. I agree. Constant improvement that leads to simplification and clarification is what I seek. I like to say, “I work hard to make it easy for your to learn.”
Danny
December 16th, 2010 at 9:54 AM
[...] Identify your Excel data as a List [...]