When using Side-by-Side Comparison, 3 common issue types come up most often: unavailable entry points, scrolling that does not stay in sync, and unusual window layouts. This FAQ covers 3 common questions.
FAQ
Why is the Side-by-Side Comparison button grayed out?
- Confirm that at least two workbook windows are currently open.
- Return to either workbook and click the View tab to check the option again.
- If it is still unavailable, close and reopen the workbooks, then try again.
Why are the two windows not scrolling together?
- First confirm that Side-by-Side Comparison is enabled.
- Check whether Synchronous Scrolling is turned on.
- If it is on but the effect is not obvious, manually move both workbooks to similar areas and review again.
How to compare two spreadsheets side by side in WPS if the layout still looks uneven after Reset Position?
- Confirm that both workbook windows are in a normal visible state rather than minimized.
- Click Reset Position and check whether the windows return to a left-and-right layout.
- If screen space is limited, maximize the WPS window first and then reset the layout again.
Glossary
| Term | Definition |
|---|---|
| Side-by-Side Comparison | A feature that displays two workbook windows in the same screen area so you can compare content directly. |
| Synchronous Scrolling | A viewing mode in which scrolling one workbook moves the other workbook to a similar position during side-by-side review. |
| Reset Position | A command that restores a moved or disordered two-window layout to the default side-by-side arrangement. |