How to Insert or Delete Worksheets in WPS on macOS

Use Insert/Delete Worksheet in WPS on macOS with 5 how-to topics, all available without membership; choose a topic from the index and follow the steps to complete the task.

How-to Index

How-to Guide

1. Insert a New Worksheet from the Ribbon

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

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

Success Criteria

• A new worksheet is added to the current workbook.
• The new worksheet is ready for editing.

Tips While Using

• The new worksheet is inserted into the current workbook.
• If you need several new sheets, repeat the same steps.

2. Insert a New Worksheet from the Sheet Tab Bar

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

1. Open the workbook and locate the sheet tab bar at the bottom.
2. Click the New Worksheet button, shown as a plus sign, to the right of the sheet tabs.

Success Criteria

• A new sheet tab appears immediately.
• The new worksheet is available for editing.

Tips While Using

• This method is useful for quickly adding worksheets.
• To create several sheets in a row, click the plus button repeatedly.

3. Insert a New Worksheet by Right-Clicking a Sheet Tab

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

1. Find any existing sheet tab in the bottom sheet tab bar.
2. Right-click the sheet tab.
3. Click Insert Worksheet in the menu.

Success Criteria

• A new worksheet is added near the current tab.
• The new worksheet can be edited immediately.

Tips While Using

• This method is useful when you want to add a sheet near the current one.
• The right-click menu is convenient during sheet-by-sheet editing.

4. Delete a Worksheet from the Ribbon

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

1. Select the worksheet you want to remove.
2. Click the Home tab.
3. Open the Worksheet drop-down menu.
4. Click Delete Worksheet.

Success Criteria

• The selected worksheet is removed from the workbook.
• Other worksheets remain available for viewing and editing.

Tips While Using

• Check the worksheet content before deletion if it contains important data.
• A workbook needs to keep at least one worksheet.

5. Delete a Worksheet by Right-Clicking a Sheet Tab

Entry point: Right-click a sheet tab → Delete

1. Right-click the sheet tab you want to remove in the bottom tab bar.
2. Select Delete.
3. Confirm the deletion if the interface asks for confirmation.

Success Criteria

• The specified worksheet is deleted.
• The workbook remains editable.

Tips While Using

• After deletion, the worksheet content usually cannot be restored directly.
• It is a good idea to check whether the data has been backed up before deleting the sheet.