Microsoft Office: Excel 2010, Overview of Excel Tables, Managing Data in an Excel Table; Microsoft Office: Excel 2007, Add or Remove Table Rows and Columns in an Excel Table, Insert a Table Row or ...

Just move your cursor to the bottom of your table and enter a new record on the next available row; for example, enter Snowbird on row 17 and Alta on row 18. Excel formats the style as you type.

A row-by-row formatting rule is as easy to apply as a column-by-column in Microsoft Excel, but you might not get the results you thought you would.

Excel’s Table object is flexible enough to include new data and update dependent functions. To make the most of the Table arrangement, use a structured reference in the COUNTIF() functions.