Where can I quickly apply a format of cell colors, borders and styles to a table or range of cells in Excel 2007? You can use the AutoFormat feature! This feature is only available by adding it to the Quick Access Toolbar or QAT. After you add the AutoFormat button to your QAT then select a range on your worksheet that you'd like formatted with one of the default templates, then click on the AutoFormat button and choose from one of many templates you'd like applied to your range of cells. You can even customize the AutoFormat to where you can add or remove font, patterns, alignments, borders and more by clicking on the Options button!

Purchase the training video and you can see this in action for yourself!