How to Add More Worksheets or Tabs to an Excel Workbook in WPS Office
Question details
The user wants to add one or more worksheet tabs to an existing Excel workbook and locate the correct Excel support area for product questions.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- Working in an Excel workbook that needs additional sheets for organizing data or reports.
- Observed behavior
- The workbook currently has a limited number of sheet tabs, and the user needs to insert more worksheets.
Open the workbook in WPS Office Spreadsheet and confirm that the sheet tab bar is visible at the bottom of the window so you can select, insert, and manage worksheets.
Add a Single Worksheet with the Plus Button or Shift+F11
Use this quick method when you only need to insert one new worksheet at the end of the existing tabs.
The plus button is the fastest way to add a blank worksheet in WPS Office Spreadsheet, and Shift+F11 works as an equivalent keyboard shortcut.
In WPS Office Spreadsheet, go to the bottom of the workbook window and click the + (plus) button immediately to the right of the existing sheet tabs. A new blank worksheet is added.
Alternatively, click any sheet tab to make the workbook active, then press Shift+F11 on your keyboard. WPS Office inserts a new worksheet after the active sheet.
Insert Multiple Worksheets Using the Right-Click Insert Dialog
Use this method when you need to add several sheets at once or control where they are inserted.
Add Worksheets or Tabs in WPS Office Spreadsheet
Use WPS Office Spreadsheet to quickly insert, rename, move, and copy worksheet tabs in Excel-compatible workbooks. The familiar ribbon and sheet-tab controls make it easy to manage multi-sheet files without changing your workflow.
- 1. Open your Excel workbook: Launch WPS Office Spreadsheet and open the .xlsx or .xls workbook you want to edit.
- 2. Go to the sheet tab bar: Scroll to the bottom of the workbook window and locate the existing worksheet tabs.
- 3. Add one or more sheets: Click the plus button to add one sheet, or right-click a selected tab and choose Insert to add multiple sheets.
- 4. Save the workbook: Press Ctrl+S or go to Menu > Save to keep the added worksheets in the Excel-compatible file.
Frequently Asked Questions
How do I add a new worksheet in WPS Office Spreadsheet?
Click the plus button next to the sheet tabs at the bottom of the workbook window, or press Shift+F11 on your keyboard.
Can I add multiple worksheets at once?
Yes. Select one or more existing sheet tabs, right-click the selected tab, choose Insert, and specify the number of worksheets you want to add.
What is the shortcut for inserting a worksheet in WPS Office?
Shift+F11 inserts a new worksheet quickly. You can also use the plus button next to the existing sheet tabs.
How do I copy or move a worksheet tab?
Right-click the sheet tab, choose Move or Copy, and select whether to create a copy or move the sheet to another location.
Where should I post Excel product questions in the community?
Post Excel product questions in the Excel space rather than the Tech Community Discussion space. This question was moved to the Excel space for product support.
