How To Construct a Data Table in Excel 2007

The Microsoft Excel 2007 spreadsheet application allows users to enter a series of data into the cells of the spreadsheet. The data that is entered can be formed into a table or formatted into a table or graph to represent the data graphically. Users can create a table first and then add data to the table. Also, they can enter the data into the cells and then choose to form the table. After the table is made, changes can be made to the table style, including the size of the border, font and color.

Instructions

1. Open the Microsoft Excel 2007 application on your computer. Select a group of cells with your mouse so that the cells are highlighted.

2. Click the "Insert" tab and then click the "Table" option from the "Tables" group.

3. Press the "CTRL" and "L" keys on your keyboard and a table will automatically be created in the area of cells that you previously selected.

4. Click the "Home" tab and then click the "Format as Table" option from the "Styles" group. Select a "Light", "Medium" or "Dark" table style.

5. Highlight the entire table and right-click on your mouse. Click the "Format" option and then make any specific changes to the "Font", "Border" or "Fill" tabs to meet your preferences. Click "OK" to save your changes.

Tips & Warnings

• Make sure that you have your data readily available when you begin to create your data table.

References

• Microsoft Office: Create or Delete an Excel Table in a Worksheet
• Microsoft Office: Format an Excel Table
• Microsoft Support: An Overview of Data Tables in Excel 2003 and in Excel 2007