Formatting worksheet

Lesson Plan: Unit - 02 Microsoft Office

Subject: BELE2CFA: Computer Fundamentals And Applications
Topic of Study: Formatting worksheet using font type, color, size and alignment.
Grade/Level: Bachelor of SCIENCE

Objective: To demonstrate and explain formatting of worksheet option using font type, font size, font color, and alignment.

Time Allotment: 30 Minutes

16.0 Formatting Worksheet in MS - Excel 2010

• To make attractive worksheet - we need to use formatting option using font size, font type, font color and alignment
  

16.0.1 To change font size

• Select the cell.
• Click the Font Size drop down on the Home tab.
  
• Select the font size from the drop down or you may write any value and press Enter key.

16.0.2 To change font type

• Select the cell.
• Click the Font box drop down on the Home tab.
  
• Select the font.

16.0.3 To change font color

• Select the cell.
• Click the Font Color drop-down arrow on the Home tab. 
  
• Select the font color that you want to apply on text.

16.0.4 To apply bold, italic and underline

• Select the cell.

Figure 10.0.4 Bold, Italic and Underline Options

• Click the Bold (CTRL + B) to make it bold.
• Click the Italic (CTRL + I) to make it italic
• Click on Underline (CTRL + U) to draw a underline.

16.0.5 To change text alignment

• Select the cell.
• There are main Six types of alignment.
  

• Select one of the six alignment options on the Home tab.
• Top Align:to align text at top of cell.
• Middle Align: to align text at middle of the cell
• Bottom Align: to align text at bottom of the cell.
• Align Text Left: to align text left side.
• Center: to align text center side.
• Align Text Right: to align text right side.