How to Scroll Two Excel Tables Independently on One Worksheet in WPS Spreadsheets
Question details
The user wants to know whether two Excel tables on the same worksheet can scroll independently while one table remains stationary.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has two tables on one worksheet and needs to keep one table visible while scrolling the other for comparison or data entry.
- Observed behavior
- Independent vertical scrolling is only possible when the tables are arranged one above the other using split panes; side-by-side tables in the same worksheet window cannot scroll vertically independently.
Make sure the two tables are positioned one above the other, because independent vertical scrolling requires separate horizontal panes. Side-by-side tables cannot scroll independently in the same worksheet window.
Split a Worksheet into Horizontal Panes to Scroll Stacked Excel Tables Independently
Use this method when one table is above the other and you need to scroll each table area separately in WPS Spreadsheets.
This method works only when the tables are arranged vertically. Excel and WPS Spreadsheets do not provide independent vertical scrolling for two tables positioned side by side in the same worksheet window.
Launch WPS Office and open the Excel-compatible workbook that contains the two tables.
If the tables are not already stacked, place the table you want to keep stationary in the upper area and the table you want to scroll in the lower area.
Click the View tab on the ribbon, and then click Split to divide the worksheet into panes.
Drag the horizontal split bar so it separates the upper table from the lower table. If extra panes appear, drag the vertical split bar to the edge to keep only horizontal panes.
Click inside the upper or lower pane, then use the scroll bar or mouse wheel to scroll that pane while the other pane remains stationary.
Use Two Worksheet Windows to Compare Side-by-Side Excel Tables Independently
Use this workaround when the two tables are positioned side by side and you still need to scroll each view independently.
Scroll Stacked Excel Tables Independently with WPS Spreadsheets
Use the built-in Split tool in WPS Spreadsheets to divide the worksheet into horizontal panes and scroll each pane independently, keeping one table stationary while you work in the other.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office and open the Excel-compatible .xlsx workbook that contains the tables.
- 2. Arrange the tables vertically: Place the table you want to keep stationary in the upper area and the table you want to scroll in the lower area.
- 3. Click View > Split: Go to the View tab on the ribbon and click Split to divide the worksheet into panes.
- 4. Drag the split bar into position: Drag the horizontal split bar so it separates the two tables. If needed, drag the vertical split bar to the edge to keep only horizontal panes.
- 5. Scroll each pane independently: Click inside the pane you want to scroll and use the scroll bar or mouse wheel while the other pane remains stationary.
Frequently Asked Questions
Can I scroll two Excel tables independently if they are side by side in the same worksheet?
No, Excel and WPS Spreadsheets do not provide independent vertical scrolling for side-by-side tables in the same worksheet window. Arrange the tables vertically and use View > Split, or use View > New Window and arrange two windows side by side.
How do I keep one table stationary while scrolling another table below it?
Place the tables one above the other, click View > Split, drag the horizontal split bar between them, then click the lower pane and scroll while the upper pane remains stationary.
Does View > Split work the same in WPS Spreadsheets as in Excel?
Yes, WPS Spreadsheets has the same View > Split command and Excel-compatible pane behavior for .xlsx workbooks.
How do I remove the split after I finish comparing tables?
Go to the View tab and click Split again, or double-click the split bar, to remove the panes and return to the normal worksheet view.
Can I use Freeze Panes instead of Split to keep one table stationary?
Freeze Panes locks rows or columns while the whole worksheet scrolls, but it does not create two independently scrollable table areas. Use Split when each table area must scroll independently.
