How to View Two Sheets from the Same Excel Workbook on Mac in WPS Office
Question details
The user needs to view two worksheets from the same Excel workbook at the same time on a Mac without creating a duplicate file.
- Product
- WPS Office for Mac
- Device & OS
- macOS
- Scenario
- The user has an Excel workbook open and wants to compare or work with two different sheets side by side on a Mac.
- Observed behavior
- Two windows show different worksheets from the same workbook, and changes made in either window are saved to the original file.
Make sure the workbook is saved as an .xlsx or .xls file and is not locked in a read-only preview. Close any protected view or preview window so WPS Spreadsheets can open and edit the workbook normally.
Open the same workbook in multiple windows in WPS Spreadsheets on Mac
Use the View > New Window command to create a second view of the same workbook, then select a different worksheet in each window.
In WPS Spreadsheets, New Window creates another view of the open workbook rather than copying the file. Both windows share the same underlying data, so you can edit or save from either window and the changes are written to the original workbook.
Launch WPS Office on your Mac, click Menu or File > Open, and select the Excel workbook you want to view.
Go to the View menu and choose New Window. WPS Spreadsheets opens a second window for the same workbook, labeled with a suffix such as :2.
In the new window, click the tab of the worksheet you want to compare. In the original window, leave or select the other worksheet tab.
Drag the two WPS Spreadsheets windows to the left and right sides of your Mac screen, or use Window > Arrange to place them next to each other.
View Two Sheets from the Same Workbook in WPS Spreadsheets on Mac
Open the Excel workbook in WPS Office on Mac, create a new window from the View menu, and arrange the windows side by side. Both windows stay connected to the same file, so edits and saves are applied to the original workbook.
- 1. Download and install WPS Office for Mac: Download WPS Office from the official WPS site, install it, and launch WPS Spreadsheets.
- 2. Open the Excel workbook: In WPS Spreadsheets, click Menu > Open or File > Open and select the workbook you want to view.
- 3. Create a second window: Open the View menu and choose New Window to create another view of the same workbook.
- 4. Select and arrange the sheets: In the new window, choose the second worksheet tab. Then arrange the two WPS Spreadsheets windows side by side on your Mac.
Frequently Asked Questions
Do changes made in either window save to the same Excel workbook?
Yes. When you use View > New Window, the windows are views of the same open workbook. Editing and saving in either window writes changes back to the original file.
Why do the window titles show :1 and :2 in WPS Spreadsheets?
The :1 and :2 suffixes indicate separate windows for the same workbook. They do not mean the file was duplicated.
Can I view more than two sheets from the same workbook at once?
Yes. Repeat View > New Window for each additional sheet and arrange the windows manually or with the Arrange command.
Does this work with .xlsx files created in Microsoft Excel for Mac?
Yes. WPS Spreadsheets supports .xlsx, .xls, and other Excel formats, so you can open and arrange sheets from those workbooks on Mac.
How do I arrange the windows side by side on macOS?
Drag each WPS Spreadsheets window to one side, or use the Window menu's Arrange option, then select a different worksheet tab in each window.
