BreezeTree Home Spreadspeed Product Page
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

Compare Worksheets (Auditor)

The Compare Worksheets tool is an auditing tool that highlights the differences between one worksheet and another. The differences are highlighted in the second sheet selected, which is treated as the audit sheet. The difference highlighting is prioritized by formulas, values, number and date formats, and then cell formats.

 

Compare Worksheets Form Fields

Worksheet 1: Select the workbook and worksheet names that the other sheet will be compared to.
Worksheet 2: Select the workbook and worksheet that will be audited. This is the sheet that will be color coded to highlight the differences.
Comparison options: Check the boxes for the types of information to compare.
Color code: Optional, change the color code for each type of cell difference.
Save workbook: See Close and Re-Open Workbook for details.

 

When you click OK, the differences between the sheets are analyzed, the audit sheet is color coded, the two workbooks are displayed side by side, and the Compare Navigator dialog opens on the right-hand side of Excel.

 

Compare Navigator Form Fields

Change List: Lists the cell differences, including the cell address and the type of change formula, value, number / date format, or cell format.
Baseline and Audit cell values / formulas: These two read-only fields show the baseline and audit cell formula for the item selected in the Change List. No values are displayed for number or cell format differences.
Copy: You can choose to copy all the cells or just the selected cells from sheet 1 to sheet 2 or sheet 2 to sheet 1. Note however, that since sheet 2 has had the auditing formatting applied to cell differences, copying from sheet 2 to sheet 1 will copy the formulas, values, and number formats, but styles are not copied.
Restore formats and view upon closing: Restores the full worksheet view from side by side, and automatically applies Restore Format. If you uncheck this option, you can manually reset the view by clicking the Excel View tab and un-toggling the "View Side by Side" and "Synchronous Scrolling" options, and then clicking the Restore Format button on the Spreadspeed ribbon tab.

 

Comparing Worksheets in the Same Workbook

The Compare Worksheets tool uses the Excel view side by side option, which only works with separate workbooks. If you want to compare two sheets in the same workbook, you can make a copy of one worksheet to use as the baseline sheet by following these steps:

Right-click on the baseline worksheet tab.
Select "Move or Copy ..." from the context menu.
On the Move or Copy dialog, under "To book:" select "(new book)", and then check the "Create a copy" option.
When you click OK, a copy of the sheet is created in a new workbook, which you can use for the Compare Worksheets baseline.

 

 

 



©2014 BreezeTree Software, LLC. All Rights Reserved.