Formatting Overview

Looking good

The judicious use of formatting can make data easier to understand as well as pleasant to see.
Scott Lowe put together a series of articles on how to format data in Excel.

The Articles are on TechRepublic.com

Anatomy of Excel formatting: Part 1

• Boldface, italicize and underline cell content
  
• Change the size and font of your text
  
• Apply a default Excel style (i.e. dollar, percent, etc) to cells
  
• Use date and time formatting in your spreadsheet
  
• Apply shading

Anatomy of Excel formatting: Part 2

• Apply borders
  
• Resize rows
  
• Resize columns

Anatomy of Excel formatting: Part 3

• Text formatting
  
• Justify cell contents
  
• Change the direction of the text in your spreadsheet
  
• Word wrap text

Anatomy of Excel formatting: Part 4

• Automatically format cells based on their contents
  
• Change the margins for your printed page
  
• Add a header and footer to your printer spreadsheet

[Edited entry from 11/20/2006]



See all Topics