Lists
Sean wants to make use of the list features to manage and analyze groups of related data in an Excel worksheet. For example, to sort the list in ascending order of the marks obtained, he can filter names of students who have secured more than 90 marks in
Note: You cannot create a list in a shared workbook. You must remove the workbook from shared use first if you want to create a list. Every column in the list has AutoFilter enabled by default in the header row. AutoFilter allows you to filter or sort your data quickly. The dark blue border around the list clearly distinguishes the range of cells that makes up your list.
To Create a List
- Highlight the range of data that you want make into a list.
Note: You can also select the range of cells to be specified as a list by selecting the range of cells from the Create List dialog box.
- On the Data menu, point to List, and then click Create List.
- If the selected data has headers, select the My list has headers checkbox and click OK.
The selected range of data is highlighted by the list indicator, and the most common list-related functionality is made available on the List toolbar.
Note: If you don't see the List toolbar, on the View menu, point to Toolbars and then click List.
After the list has been created, it will be identified by a blue border. In addition, AutoFilter drop-downs will be automatically enabled for each column in the list and the insert row will be added as the last row of the list.
If you choose to add a total row by clicking Toggle Total Row on the List toolbar, a total row will be displayed under the insert row.
