After you add AutoFormat, it remains on the Quick Access Toolbar.
There are 17 AutoFormat styles available in Excel.
These styles affectnumber formatting, borders, fonts, patterns and background colors, alignment, andcolumn and rowsize.
Select theQuick Access Toolbardrop-down arrow.
ChooseMore Commandsto open theCustomize the Quick Access Toolbardialog box.
Select theChoose commands fromthe drop-down arrow.
ChooseAll Commandsto display all the commands available in Excel.
Scroll through the alphabetical list and chooseAutoFormat.
SelectOKto add the AutoFormat icon to the Quick Access Toolbar.
Go to theQuick Access Toolbarand selectAutoFormat.
In theAutoFormatdialog box, choose a style.
SelectOKto terminate the dialog box.
The new style is applied to the table.
To apply a different style, select any cell in the table and chooseAutoFormat.
In theAutoFormatdialog box, selectOptions.
The examples in the dialog box update to reflect the changes.
SelectOKto apply the modified style.
To create custom AutoFormat styles for tables:
Select any cell in the table.
Go to theHometab, selectFormat asTable, then chooseNew Table Style.
Do this for each table element you want to change.
