You’ll often discover that it makes sense to arrange your Excel data as a table, where each column contains a specific data element (such as an order number or the hours you worked on a given day) and each row contains data about a specific thing (such as the details of order number 1403). The following graphic shows an Excel 2007 data table.

In Excel 2007, tables make it easier for you to enter and summarize your data. If you want to add data to a table, just click in a cell in the row just below the table and type the data. Excel will recognize that you want the data to be part of the table and will expand to include it. You can also have Excel display a Totals row at the bottom of your table.

You have full control over your table’s appearance and how it summarizes your data in the Totals row.