How to Rename Worksheet in WPS on Windows

This how-to guide includes 3 topics for renaming worksheet tabs in WPS on Windows, covering double-click renaming, right-click menu renaming, and Home tab renaming.

How-to Index

How-to Guide

1. Rename by Double-Clicking a Tab

Entry: Double-click the worksheet tab

1. Double-click the worksheet tab you want to rename.
2. Type the new worksheet name.
3. Press Enter, or click another area in the spreadsheet to confirm the change.

Success Criteria

• Visual result: The worksheet tab shows the new name.
• What you can do next: You can continue switching sheets, editing content, or saving the workbook.

Tips While Using

• Common mistake: A single click does not enter rename mode. Double-click the tab name instead.
• Limitation: If the name duplicates another worksheet name in the same workbook, the rename action usually cannot be completed.

2. Rename from the Right-Click Menu

Entry: Right-click the worksheet tab → Rename

1. Right-click the worksheet tab you want to rename.
2. Select Rename from the menu.
3. Type the new worksheet name.
4. Press Enter to confirm.

Success Criteria

• Visual result: After the menu closes, the tab name updates to the new text.
• What you can do next: You can continue with other worksheet management actions such as moving, copying, or deleting sheets.

Tips While Using

• Common mistake: If you click another menu command by mistake, open the right-click menu again and repeat the action.
• Limitation: Use a clear and non-duplicate worksheet name for easier identification.

3. Rename from the Home Tab

Entry: Home tab → Worksheet drop-down menu → Rename

1. Click the Home tab.
2. Open the Worksheet drop-down menu.
3. Click Rename.
4. Type the new worksheet name.
5. Press Enter to confirm.

Success Criteria

• Visual result: The current worksheet tab shows the new name.
• What you can do next: You can continue using other worksheet-related commands from the Home tab.

Tips While Using

• Common mistake: Select the target worksheet first before starting the rename action from the ribbon.
• Limitation: If no spreadsheet file is open, you cannot start the worksheet renaming flow.