Leading the way in Microsoft Office Development

Advantages of a List Object

There are several advantages when you convert a regular list to an actual List Object

New rows and columns are automatically included.

A total row at the bottom of your list can be easily added to display sums, averages, counts etc.

You can easily print the whole list.

Columns added to the right are automatically incorporated into the List object.

Charts based on rows and columns will be expanded automatically.

Named Ranges assigned to rows and columns will be expanded automatically.

The list is protected from accidental row and column deletion.

This list can be published to a SharePoint site.

Creating a List Object

Select any cell within your list and select (Data > List > Create List)

This will display the Create List dialog box.

Adding new rows and columns

Toggle Total Row

(Data > List > Total Row)

Excel inserts a new row at the bottom of your list and automatically displays the sum of the last column.

When you select the last cell of any row an additional drop-down list appears allowing you to select from any of the aggregation functions.

The total row uses the SUBTOTAL() function to perform the necessary aggregation.

These total rows only reflect the rows that are currently visible, any hidden rows causing by filtering are ignored.