Microsoft Excel Tutorial PDF
Document Details

Uploaded by VivaciousCarbon
Tags
Summary
This document provides instructions and examples for various formatting options in Microsoft Excel, including centering, merging, text wrapping, text orientation, and number formatting. It also covers freezing row and column titles in workbooks and unfreezing these features.
Full Transcript
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.