Microsoft Excel Tutorial PDF

Computer Applications Microsoft _ Excel-4 Centering a Title Over a Cell Range; To center and merge cells in multiple rows and columns in one cell, 1. Select close cells you need to merge. 2. Home  Alignment  Merge and Center Merging three cells in one Text Wrapping...

Computer Applications Microsoft _ Excel-4 Centering a Title Over a Cell Range; To center and merge cells in multiple rows and columns in one cell, 1. Select close cells you need to merge. 2. Home  Alignment  Merge and Center Merging three cells in one Text Wrapping; To multiple lines in one cell, 1. Select close cells you need to format. 2. Home  Alignment  Wrap text Multiple lines cell Text Orientation; 1. Select close cells you need to format. 2. Home  Alignment  Orientation To Clear Format of cells; 1. Select cells you need to clear off format. 2. Home  Editing  Clear Format Computer Applications Microsoft _ Excel-5 Number Formatting; Percentages; 1. Select cells you need to format. 2. Home  Number  Percentage. Applying or Removing Comma Style; Adding comma style for numbers more than a thousand; 1. Home  Number  Comma Style. Currency Symbol; 1. Shade cells you need to add currency symbol to. 2. Home  Number  Currency icon  choose currency the suitable symbol. To clear number formatting; 1. Home  Number  Number Format icon  General. Freezing Row and Column Titles; We can freeze headings to have row’s and column titles showing when entering data no matter where you're working at Worksheet. 1. View  Window  Freeze Pane. Unfreeze Panes; 1. View  Window  Unfreeze Pane. Freeze head titles only; To freeze head titles showing columns titles all the time when entering data. 1. View  Window  Freeze Top Row. To Freeze Rows titles; 1. View  Window  Freeze First Column.