How do I... Perform basic formatting in Excel 2007

By Mark Kaelin

To get your point across when communicating information in the form of a spreadsheet of numbers, it is often necessary to add some formatting beyond the basic numbers in a set of cells. Column headings, row names, fonts, colors, and other basic formatting techniques can help you emphasize the data points you want your audience to focus on. The last thing you want to do is bog your communication down with an overwhelming sea of numbers.

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


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.