Help Topics

• Spreadspeed Help Introduction
• Range Selector
• Navigation Tools
  • Xplorer
  • Favorites
  • File Operations
  • Quick Navigation Buttons
• Workbook Tools
  • Create Table of Contents
  • Sort Sheet Tabs
  • Add Multiple Worksheets
  • Remove Empty Worksheets
  • Quick Hide / Unhide Sheets
  • Save Worksheets to Separate Files
  • Close and Re-Open Last Save
  • Save a Backup Copy of Workbook
  • Quick Protect
  • Quick Unprotect
  • Hide / Unhide Named Ranges
• Worksheet Tools
  • Delete Blank Rows
  • Delete Blank Columns
  • Autofit Rows and Columns
  • Reset Used Range
• Range Tools
  • Split Single Column into Multiple Columns
  • Split Single Row into Multiple Rows
  • Concatenate Columns
  • Concatenate Rows
  • Transpose in Place
  • Swap Ranges
• Table Tools
  • Filtering Records
  • Join Tables
  • Merge Tables
  • Find Unmatched Rows
  • Extract Columns
  • Extract Filtered Data
  • Extract Duplicate Data
  • Remove Hidden Rows
• Shapes Tools
  • Select Shapes by Type
  • Group All
  • Ungroup All
  • Extract Text
• Trim Text
  • Advanced Trim Tool
  • Trim Selection
  • Clean Text
  • Clear Empty Strings
• Change Case
  • Change Case Tool
  • Change Case on Selection
  • Change Name Case
• Prefix / Suffix
• Number Operations
  • Fill Range with Random Numbers
  • Perform Math Operations in Place
  • Negate Selected Values
  • Remove Non-Numeric Characters
  • Convert Text to Number
  • Convert Formulas to Values
  • Round to X Decimals
• Date Operations
  • Fill Range with Random Dates
  • Convert Text to Date
  • Change Date Formats
  • Date Formats
• Data Operations
  • Subtotals
  • Sum and Percentages
  • Descriptive Statistics
  • Remove Repeating Data
  • Fill Repeating Data
  • Perform Random Sort
  • Create Validation Dropdown List
• Export Operations
  • Save Chart to Image File
  • Save Range to Image File
  • Save Shapes to Image File
  • Save Range to Text File
  • Create HTML Unordered List
  • Create HTML Ordered List
  • Create HTML Table
• Format Operations
  • Reset All Cell Styles
  • Delete Unused Custom Cell Styles
  • Selectively Clear Formats
  • Clear Excess Formatting
  • Merged to Center Across
• Dependency Navigator (Auditor)
• Visual Audit (Auditor)
• Audit Reports (Auditor)
  • Worksheet Comparison Report
  • Master Audit Report
  • Cell Errors Report
  • Circular References Report
  • Comments Report
  • External References Report
  • Hyperlinks Report
  • Formulas Report
  • Named Ranges Report
• Inconsistent Formulas (Auditor)
  • Find Inconsistent Formulas
  • Flag Inconsistent Formulas
• Compare Worksheets (Auditor)
• Hyperlinks Audit (Auditor)
  • Open Hyperlinks Navigator
  • Remove Hyperlinks
  • Convert Hyperlink Formulas
• Comments Audit (Auditor)
  • Delete All Comments
  • Remove User Name
• Restore Formats
• Support
  • Spreadspeed Support
  • Log Files
  • Troubleshooting
  • Uninstalling Spreadspeed
• How to Buy