Excel's AutoFormat feature takes away some of the hard work involved in formatting a worksheet. AutoFormat provides you with 16 predesigned table formats that you can apply to a selected range of cells on a worksheet.
Instead of applying each format to your data, one at a time, you can apply a group of formats in one shot with one of Excel's predesigned formats. The AutoFormat command lets you select a format and transform your table with a couple of mouse clicks.
In this To Do exercise, you get to try out a predesigned format using the AutoFormat command.
Select the cells that contain the data you want to format; in this case, select cells A3:D9.
Choose Format, AutoFormat. The AutoFormat ...