How do I... Use pre-built style features to format Excel 2007?

By Mark W. Kaelin

Formatting an Excel worksheet to look professional and at the same time convey the vital information you want to communicate with your audience has always been a bit of a challenge. With the release of Microsoft Office 2007, formatting styles in Excel 2007 has been simplified with the introduction of the Office Ribbon interface. Colorful and dynamic spreadsheet formatting at the worksheet and cell level are just a few mouse clicks away. This TechRepublic How do I... explores the formatting features of the Styles section of the Home tab in Excel 2007.

The Styles section of the Home tab in the Excel 2007 ribbon interface contains three icons:
  • Conditional Formatting
  • Format as Table
  • Cell Styles

This gallery is also available as a TechRepublic download and as a TechRepublic blog.

By Mark Kaelin

Mark W. Kaelin has been writing and editing stories about the IT industry, gadgets, finance, accounting, and tech-life for more than 25 years. Most recently, he has been a regular contributor to,, and TechRepublic.