How to Create New Table Style in Excel 2007

Spreadsheet programs are enormously helpful in organizing data. Microsoft Excel is one of the top programs for analyzing and managing information. The 2007 version provides quick styles for formatting tables. You can also create new custom table styles to meet your needs. F

Instructions

Difficulty: Moderate

1. Locate the Styles group under the Home tab. Click "Format as Table."
2. Choose an existing table. Table styles are organized under light, medium and dark. Each style includes a variety of color choices.
3. Click anywhere in the table to bring up Table Tools. Select the Design tab and click "More." Select "New Table Style." Type a name for the new table you are creating in the name box.
4. Makes changes to the Table Element box by clicking on each element. Click "Format" to format or "Clear" to clear the existing formatting.
5. Click the options you want from the Font, Border and Fill tabs. Press enter or click "OK" after you make your choices. You can also change the look of a table by turning elements on and off from the Table Tool tab. This allows you to include or omit headers, rows, row banding, column banding, and emphasis on first or last columns.
6. Vary the colors of the table. Look in the Table Styles gallery to choose among sixty different color schemes.
7. Check the formatting changes you made by Previewing. Adjust your changes as needed, and then save.

Tips & Warnings

• Make your new table style your default table by checking the box "Set as default table quick style for this document."
• Your new table style is now available to use again under "Custom" under the Styles group.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.