Create and Format an Excel Table
Understand the data list in Excel
- A list is a set of columns, with each column containing a different category of information
- Each row in a data list represents a full set of values
Create an Excel Table
TIP Some useful tips before creating an Excel table
- No blank rows in the Excel data list
- Avoid data against the left edge of the worksheet
- Do not include extraneous data which is not part of the list to the right, beneath or to the left of the data list because it will be included when you create the Excel table
1. Click any cell in the data list
2. From the Ribbon, click Tables tab, select Table Options, select New
3. Select one of the following options from the dropdown list
- Insert Tables with Headers
- Insert Tables without Headers
4. The Excel table is created
Add or remove a Total Row in an Excel Table
- To add/remove a Total Row to summarize the data in a Excel table, do the following:
- Select any cell in a table
- From the Ribbon, click Tables tab ð Table Options, select/deselect Total Row checkbox
- To add a row in an Excel table, select the last row, or the row above the Total Row, and press tab key
NOTE
- Excel will update the Total Row to include the new value entered in the new inserted row
- By default, the Total Row calculates the total of data (SUM function). To change the default calculation of the Total Row, for example Average, click the list arrow in the cell of the Total Row and select the new desired function
Add or remove a table column in an Excel table
1. Click in the first empty cell to the right of the Excel table
2. Enter the header name for the new column
3. Press return and Excel will add that column to the table
Delete an entire column in an Excel worksheet
1. Move the mouse over the column header until the mouse pointer changes to a downward-pointing arrow with a vertical bar across the top, which indicates that it’s a column in an Excel table
2. Hold down control + click the mouse button
3. Go to Delete, select Table Columns
