Assist Pro+ / Audit and Analysis

Toggle Extra Window

Opens or closes an additional view of this workbook for side-by-side work or cross-referencing.

Where to find it

Follow the ribbon path.

Assist Pro + → Audit and Analysis → Data Compare → Toggle Extra Window

Part of Assist Pro+. Eligible tools can also be selected through Assist Pro’s 30-tool Vault allowance. Check the Vault for availability.

Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.

Browse all tools
Practical guidance

Use this tool in your workflow.

How to use

Prepare both datasets or source files, retaining consistent headers and the matching keys. On Assist Pro + › Audit and Analysis › Data Compare, choose Toggle Extra Window to opens or closes an additional view of this workbook for side-by-side work or cross-referencing. Verify that the intended files and keys were used, then investigate material or unexplained differences.

Best use case

Reviewing separate areas of the same workbook side by side.

Everyday Excel

Avoids checking two spreadsheets row by row when you need to open or closes an additional view of this workbook for side-by-side work or cross-referencing.

Accounting and audit

Speeds comparisons of prior-year data, client records and testing schedules by helping open or closes an additional view of this workbook for side-by-side work or cross-referencing.