Apply Formatting in Excel 2010

Formatting Cells

In MS Excel, you can apply formatting to the cell or range of cells by Right Click » Format cells » Select the tab. Various tabs are available as shown below

Alternative to Placing Background

• Number − You can set the Format of the cell depending on the cell content. Find tutorial on this at MS Excel - Setting Cell Type.

• Alignment − You can set the alignment of text on this tab. Find tutorial on this at MS Excel - Text Alignments.

• Font − You can set the Font of text on this tab.Find tutorial on this at MS Excel - Setting Fonts.

• Border − You can set border of cell with this tab.Find tutorial on this at MS Excel - Borders and Shades.

• Fill − You can set fill of cell with this tab. Find tutorial on this at MS Excel - Borders and Shades.

• Protection − You can set cell protection option with this tab.