Browse » Home
Sunday, July 15, 2012
How To Use the List Feature In Excel
Excel 2003
1. Open Excel 2003. Create a new spreadsheet or open an existing spreadsheet.
2. Enter data headers in the first row. Enter the data below them.
3. Click and drag to select your data including the headers.
4. Open the 'Data' menu. Point to the 'List' menu and click 'Create List.'
5. Check the 'My list has headers' check box. Click 'OK.'
6. Click a header to sort the data based on that column.
7. Type in the bottom row containing an asterisk to add a row to your list.
8. Click and drag the handle at the bottom right corner of your list to expand the range.
9. Click outside the list cells to deselect the list.
Excel 2007 and 2010
10. Open Excel 2007 or 2010. Create a new spreadsheet or open an existing spreadsheet.
11. Enter data headers in the first row. Enter the data below them.
12. Click and drag to select your data including the headers.
13. Click the 'Home' ribbon and click 'Format as Table.' Select a table style from the drop-down menu.
14. Check the 'My table has headers' check box. Click 'OK.'
15. Click a header to sort the data based on that column.
16. Select the bottom right corner and press 'Tab' to insert a new row.
17. Click and drag the handle at the bottom right corner of your list to expand the range.
18. Click outside the list cells to deselect the list.