Don’t Want to Spend Time Formatting Manually?

Microsoft Excel offers a set of predesigned worksheet formats for you to choose from. When you apply an autoformat, Microsoft Excel analyzes the current region of the worksheet and automatically applies formatting based on the positions of headers, formulas, and data. (A region is a contiguous range of cells defined by a perimeter of empty cells or worksheet boundaries. The current region is the region that surrounds the currently active cell.)

Apply an autoformat by selecting any cell in the current region, clicking AutoFormat (Format menu), and then selecting the style you want from the list.

Next Steps