Browse » Home
Monday, July 11, 2011
How to Create New Table Style in Excel 2007
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.