• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Designing a Worksheet with Excel > Formatting Data with AutoFormat

Formatting Data with AutoFormat

Formatting worksheet data can be a lot of fun but also time consuming, especially for busy healthcare professionals. To make formatting data more efficient, Excel includes 18 AutoFormats. An AutoFormat includes a combination of fill colors and patterns, numeric formats, font attributes, borders, and font colors that are professionally designed to enhance your worksheets. If you don't select any cells before choosing the AutoFormat command, Excel will “guess” which data should it should format.

Apply an AutoFormat

Select a cell or range to which you want to apply an AutoFormat, or skip this step if you want Excel to “guess” which cells to format.

Click the Format menu, and then click AutoFormat.

Click an AutoFormat in the list.

Click Options.

Select one or more Formats To Apply check boxes to turn a feature on or off.

Click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint