How to Open Every Worksheet at the Same Cell and View in WPS Spreadsheets
Question details
The user wants each worksheet in a WPS Spreadsheets workbook to open at the same selected cell, such as B2, and restore a consistent zoom or window view.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- Preparing a multi-sheet workbook for consistent navigation by making all sheets open at the same active cell and view state.
- Observed behavior
- By default, WPS Spreadsheets remembers the last active cell and view for each worksheet, so different sheets may open in different positions unless they are actively set before saving.
Make sure the workbook is saved as an Excel Macro-Enabled Workbook (.xlsm) if you plan to use the VBA method. Enable macros or choose to trust the document when prompted in WPS Spreadsheets.
Manually set the same active cell and view on each sheet
Use this for a small workbook when you prefer not to use macros.
Launch WPS Office, click Menu > Open, and select your workbook.
Click the first sheet tab at the bottom, then click cell B2 or press Ctrl+G, type B2, and press Enter.
Go to the View tab, click Zoom, choose the percentage you want, and adjust the WPS Spreadsheets window size if necessary.
Repeat these settings on each remaining sheet tab, then click Menu > Save or press Ctrl+S to store the active cell and view.
Run a VBA macro to open every worksheet at the same cell and view
Use this when the workbook contains many worksheets and you want a consistent opening position without clicking through each sheet.
Set Every Worksheet to Open at the Same Cell and View in WPS Spreadsheets
Use the built-in VBA editor in WPS Spreadsheets to activate each worksheet, select a consistent cell such as B2, apply zoom and window settings, and save the workbook so the same view appears every time.
- 1. Open your workbook in WPS Spreadsheets: Download and install WPS Office, then open the Excel workbook in WPS Spreadsheets.
- 2. Save in macro-enabled format: Click Menu > Save As, choose Excel Macro-Enabled Workbook (*.xlsm), and save the file.
- 3. Open the VBA editor: Press Alt+F11 or go to Developer > Visual Basic to open the macro editor.
- 4. Add the view-setting macro: Insert a module, paste the macro that activates each sheet, selects B2, and sets zoom, then run it with F5.
- 5. Save and reopen: Click Menu > Save, close and reopen the workbook to confirm every worksheet opens at the same cell and view.
Frequently Asked Questions
Why do my worksheets still open at different cells after I save?
WPS Spreadsheets normally stores the last active cell and view for each worksheet. If you want all sheets to open at the same cell, activate each sheet, select the target cell such as B2, and save, or run a VBA macro that does this before saving.
Can I set the same zoom and window size for every worksheet?
Yes. You can set zoom from View > Zoom on each sheet before saving, or include ActiveWindow.Zoom and WindowState settings in the VBA macro.
Which file format should I use for the VBA macro?
Save the workbook as an Excel Macro-Enabled Workbook (.xlsm). This keeps the macro available and works in both WPS Spreadsheets and Microsoft Excel.
What if Alt+F11 does not open the VBA editor?
Use Developer > Visual Basic instead. If the Developer tab is not visible, enable it from File > Options > Customize Ribbon and make sure the WPS VBA macro component is installed.
Does this method work in Microsoft Excel too?
Yes. The same VBA approach works in Microsoft Excel because WPS Spreadsheets shares the .xlsm format and supports VBA macros.
