Text Inside
Text inside cell can be:
1. General Text
2. Number
3. Formula
Number Formatting
Home Tab–>Number Group
Different Numeric Data Formatting
1. Number
2. Currency
3. Accounting
4. Date (Short or Long)
5. decimal places
6. percentile
7. comma style
Clear Formats/Content:
Home Tab–>Editing Group–>Clear
Clear content only: del
Date must be entered by using either – or /
Auto Fill can be used to:
1. copy cell data into adjacent cells
2. fill numeric and date series
3. fill known list items
4. fill custom lists.
Create Custom List:
Office Button–>Excel Options–>Popular–>Edit Custom Lists