Certified Data Entry Operator Learning Resources Formatting Cells

Learning Resources

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.

 For Support