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

Part I: Everyday Worksheet Tasks > Formatting Worksheets

Chapter 5. Formatting Worksheets

  • Format with AutoFormats

    Quickly format reports, tables, and lists automatically using Excel's selection of AutoFormats.

  • Format text

    Format text to look the way you want by changing the fonts, font sizes, font styles and colors.

  • Format numbers, dates, times, rows, and columns

    You can select from a range of built-in number, date, and time formats or create custom numeric formats. Row-height and column-widths can be adjusted and you can hide selected rows and columns.

  • Create conditional formats

    A new feature in Excel 97 enables you to create formats that are applied only when certain conditions are met, so that you can highlight data that meets these conditions.

  • Add colors, patterns, and borders

    To further enhance your work-sheets and make your tables and reports easier to read, you can add colors, patterns, and borders to cells or cell ranges.

Appearance isn't everything, but it counts for a great deal when you need to communicate with confidence. Your work may be excellent, but it may make a poor impression if important information is obscured or has a slipshod appearance.

Excel has formatting features that make reports, worksheets, and databases easier to read and understand. Using the TrueType fonts that come with Windows'applications, you can format your worksheet and see on-screen what it will look like on paper. Another useful formatting feature is AutoFormat, which enables you to format tables and reports in one step with preset combinations of numeric formats, alignments, borders, and shading.

In addition to changing column widths or selecting preset numeric and date formats, you can create your own numeric and date formats; change the height of rows; change the font, size, color, and style of characters; control the placement of text within cells; hide columns, rows, and grid lines; and shade, color, and border ranges. A new feature in Excel 97 allows you to apply conditional formats to a cell, so that the formatting for the cell varies depending on which, of up to three, specified conditions are met. You also can protect portions of your document that you don't want changed and can use styles to simplify your formatting tasks. With Excel, your printed worksheet or database can look as though it just came from the typesetter. You can drive your point across with emphasis and elegance.



Not a subscriber?

Start A Free Trial

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