How to Insert or Delete Worksheets in WPS on Windows

Use Insert/Delete Worksheet in WPS on Windows through 5 how-to topics, including 5 free topics and 0 membership-related topics, with direct links in the How-to Index.

How-to Index

How-to Guide

1. Insert a new worksheet from the ribbon

Entry point: Home tab → Sheet drop-down menu → Insert Sheet

1. Open the workbook that you want to edit.
2. Click the Home tab.
3. Open the Sheet drop-down menu.
4. Click Insert Sheet.

Success Criteria

• Interface result: A new worksheet tab appears at the bottom of the current workbook.
• What you can do next: You can start entering or organizing data in the new worksheet immediately.

Tips While Using

• Common mistake: If the current file is read-only, you may not be able to add a new worksheet.

2. Insert a new worksheet from the sheet tab bar

Entry point: Sheet tab bar → New Sheet button (+)

1. Open the workbook and locate the sheet tab bar at the bottom.
2. Click the New Sheet button to the right of the existing sheet tabs.

Success Criteria

• Interface result: A new worksheet appears at the end of the tab bar.
• What you can do next: You can keep clicking to create multiple worksheets in sequence.

Tips While Using

• Common mistake: If the window is too narrow, expand the bottom tab area before you continue.

3. Insert a new worksheet by right-clicking a sheet tab

Entry point: Sheet tab bar → Right-click an existing sheet tab → Insert Sheet

1. Find any existing worksheet tab at the bottom of the workbook.
2. Right-click the tab.
3. Click Insert Sheet on the shortcut menu.

Success Criteria

• Interface result: A new worksheet is added near the current tab.
• What you can do next: You can rename the new worksheet or adjust its order.

Tips While Using

• Common mistake: Make sure you right-click the sheet tab, not a cell area in the worksheet.

4. Delete a worksheet from the ribbon

Entry point: Home tab → Sheet drop-down menu → Delete Sheet

1. Select the worksheet that you want to delete.
2. Click the Home tab.
3. Open the Sheet drop-down menu.
4. Click Delete Sheet.
5. If a confirmation prompt appears, confirm the deletion.

Success Criteria

• Interface result: The target worksheet tab disappears from the bottom tab bar.
• What you can do next: The workbook switches to another remaining worksheet automatically.

Tips While Using

• Common mistake: Check that the worksheet does not contain data you still need before deleting it.
• Environment limit: A workbook must keep at least one worksheet.

5. Delete a worksheet by right-clicking a sheet tab

Entry point: Right-click a sheet tab → Delete

1. Find the worksheet tab that you want to remove.
2. Right-click the tab.
3. Select Delete.
4. If a confirmation prompt appears, confirm the action.

Success Criteria

• Interface result: The deleted worksheet tab is no longer shown.
• What you can do next: You can continue organizing the remaining worksheets and their content.

Tips While Using

• Common mistake: Avoid deleting a worksheet that is still in use.
• Environment limit: If only one worksheet remains, you cannot delete another one.