Formatting Cells

Formatting Cells

Formatting can be done in MS-Excel by

• Formatting with auto format
• Copying format with the format painter button
• Format from Toolbar

Various options on formatting toolbar are

• Merge and Center
• Currency Button
• Percentage Button
• Comma Button
• Indent Buttons
• Border Buttons
• Fill Color  
• Font Color

Various horizontal alignments are

• General
• Left (Indent)
• Center
• Right (Indent)
• Fill
• Justify
• Center Across Selection
• Distributed (Indent)

The Vertical alignment options are

• Wrap Text
• Shrink to Fit
• Merge Cells
• Orientation

Conditional Formatting
MS-Excel provides the feature of Conditional Formatting used to apply format to selected cells based on predefined conditions.