'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Zoom Worksheets Independently in Excel Side-by-Side View
Question details
The user needs to set independent zoom levels for two separate worksheets while viewing them side-by-side in the same workbook.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Viewing and comparing two different worksheets side-by-side within a single Excel workbook.
- Observed behavior
- Zooming one worksheet automatically changes the zoom level of the other worksheet, even when synchronous scrolling or window synchronization is disabled.
Ensure you have saved any recent edits to your workbook before opening multiple views, so you do not lose track of changes while comparing data across windows.
Use the New Window Feature to Zoom Independently
Since Excel does not support independent zooming for split views within the same instance, opening a new window for the same workbook is the standard workaround.
Excel's native side-by-side feature links the zoom controls of the active window frame. To bypass this limitation, you need to spawn a second window of your active file. This doesn't duplicate the actual document; it simply creates a second visual portal to the exact same data, allowing completely independent window controls.
Open your workbook in Excel. Navigate to the 'View' tab on the top ribbon and click on 'New Window'.
Still on the 'View' tab, click 'Arrange All'. In the dialog box that appears, select the 'Vertical' option.
Check the box that says 'Windows of active workbook' so you only arrange the multiple views of your current file, then click 'OK'.
Click inside the first window and adjust the zoom slider at the bottom right. Then, click inside the second window and set a different zoom level. Because both windows access the same file, edits will sync instantly.
Easily Compare and Zoom Worksheets with WPS Office
WPS Office Spreadsheet provides an intuitive interface for opening multiple windows and viewing worksheets side-by-side. You can easily adjust zoom levels independently for different document views without complex menu configurations.
- 1. Open Your Spreadsheet in WPS Office: Launch WPS Office and open your spreadsheet file. By default, it opens in a single tabbed window.
- 2. Create a New Window: Navigate to the 'View' tab on the ribbon and click 'New Window'. This instantly creates a separate workspace window for the same file.
- 3. Arrange Windows Side-by-Side: Click 'Arrange All' under the View tab, select 'Vertical', and ensure both views are placed side-by-side on your monitor.
- 4. Set Independent Zoom Levels: Use the zoom slider located at the bottom right corner of each respective window to adjust the magnification independently for perfect visibility.
Frequently Asked Questions
Does opening a 'New Window' create a copy of my Excel file?
No, clicking 'New Window' merely opens a second view of the exact same file. It does not duplicate the file on your hard drive. Any modifications made in either window apply directly to the original document.
Why does the standard 'View Side by Side' force the same zoom level?
The standard 'View Side by Side' tool in Excel is primarily designed for synchronous scrolling and comparing data within a single parent instance, which shares the same UI scale and zoom controls by default.
How do I close the extra window when I am done comparing?
Simply click the 'X' in the top right corner of one of the windows to close that specific view. The remaining window will stay open with your file intact, and you can maximize it to continue working normally.
