Table of Contents:

• Preview
  
  
  
  • Display Toolbar
  
  
  • Print Part of Worksheet
  
  
  • Sort Cell Data
  
  
  • Name Worksheet Tab
  
  
  
  


• Entry and Editing
  
  
  
  • Digit data
  
  
  • Change Cell Contents
  
  
  • Clear Cell Contents
  
  
  • Replace Existing Data
  
  
  
  


• Display


• Toolbars
  
  
  
  • Display Toolbar
  
  
  • Remove Toolbar
  
  
  
  


• Format
  
  
  
  • Underline Cell
  
  
  • Align Text
  
  
  • Center Text
  
  
  • Change Font
  
  
  • Change Background Color
  
  
  • Change Text Color
  
  
  • Display Negative Sign
  
  
  • Copy Cell Formatting
  
  
  • Format Automatically
  
  
  
  


• Scrolling and Splitting
  
  
  
  • Stop Row Scrolling
  
  
  • Resume Scrolling
  
  
  • Split Screen
  
  
  • Widen Column
  
  
  • Auto Widen Column
  
  
  
  


• Borders
  
  
  
  • Create Border
  
  
  • Draw Border
  
  
  • Erase Borde
  
  
  
  


• Hiding
  
  
  
  • Hide Column
  
  
  • Unhide Column
  
  
  • Unhide All Columns
  
  
  • Hide Row
  
  
  • Unhide Row
  
  
  • Unhide All Rows
  
  
  
  


• Comments
  
  
  
  • Add Comment
  
  
  • Edit Comment
  
  
  • Display Comment
  
  
  • Display All Comments
  
  
  
  


• Formulas
  
  
  
  • Make Formula Manually
  
  
  • Make Formula by Pointing
  
  
  • Copy Formula
  
  
  • Absolute and Relative
  
  
  
  


• Functions
  
  
  
  • Add Numbers
  
  
  • Average numbers
  
  
  • Count entries
  
  
  • Insert Date and Time
  
  
  • Highest Number
  
  
  
  


• Worksheets


• Columns
  
  
  
  • Insert a Column
  
  
  • Move a Column
  
  
  • Delete a Column
  
  
  
  


• Rows
  
  
  
  • Insert a Row
  
  
  • Move a Row
  
  
  • Delete a Row
  
  
  
  


• Worksheet Tabs
  
  
  
  • Name Worksheet Tab
  
  
  • Color Worksheet Tab
  
  
  
  


• Printing
  
  
  
  • Set Margins
  
  
  • Print Lengthwise
  
  
  • Print Headers and Footers
  
  
  • Print Column Headings
  
  
  • Print Part of Worksheet
  
  
  • Print Formulas
  
  
  
  


• Miscellaneous
  
  
  
  • Search for Data
  
  
  • Sort Cell Data
  
  
  • Protect Cell