Home » Microsoft Excel 2003 » 04 - Working with Data
4

Insert Row and Total Row

Here we cover inserting rows into your lists and displaying total rows.

Insert Row

Another action that is common when you work with a list is to add new rows. To that end, an insert row is displayed whenever the list is active. This interface element consists of a blank row, displayed directly below the last row of data, with a blue asterisk (*) inside the left-most cell.

When the list is inactive, the asterisk is removed and the list border shifts up to the bottom of the last row of data.

Total Row

To display a total row, click the Toggle Total Row on the List toolbar. This total row is displayed below the insert row when the list is active, and shifts up to the row just below the last row of data when the list is not active. When turned on, the word "Total" is displayed in the left-most cell, and an appropriate Subtotal formula in the right-most cell.