O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting with AutoFormat

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.

To Do: Apply an AutoFormat

1.
Select the cells that contain the data you want to format; in this case, select cells A3:D9.
2.
Choose Format, AutoFormat. The AutoFormat ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required