Defining a Table

• Excel 2003 included a structure called data list that has evolved to table in Excel 2007
• To create a data table type a series of column headers in adjacent cells and then type a row of data below the headers
• Home tab in the styles group click on format as table
• The cells in the where is the data in your table? field reflect your current selection and that the my table has headers check box is selected and then click ok
• Excel 2007 can also create a table from an existing data list- different formatted header and no spaces
• Add data to a table by selecting the cell in the row below the last row in the tabel
• Add roew and columns to a table or remove a table by dragging the resize handle
• Adding a total row excel creates a formula that calculates the sum of the values in the rightmost column
• Add a name to a table by clicking the Design contextual tab and in properties group edit the value in the Table name field
• Convert a table back to range of cells click any cell in the table and then on the table tools contextual tab in the tools group click convert to range