Use Share Partial Worksheet with 2 how-to topics, and both are membership-related; you can start from an open workbook or from the WPS Home file list.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Share Partial Worksheet from an open workbook | WPS Premium required |
| 2 | 2. Share Partial Worksheet from WPS Home | WPS Premium required |
How-to Guide
1. Share Partial Worksheet from an open workbook
Entry: Top menu bar in the spreadsheet > Share > Partial Worksheet
- Open the spreadsheet that you want to share.
- Tap Share in the top menu bar.
- Select Partial Worksheet.
- Set the worksheet range that you want to share, such as Sheet 2 to Sheet 5.
- Confirm the range and tap Extract and Send.
- Choose a sending method and complete the sharing process.
- After the recipient opens it, they can view only the selected worksheets.
Success Criteria
- Interface result: You can open the worksheet range selection screen and see the Extract and Send button.
- Next action available: After sending, you can continue with a sharing channel or return to the workbook.
- Verification result: The recipient can view only the shared worksheets.
Tips While Using
- Permissions or membership: This feature requires WPS Premium.
- Before you share: Check that formulas, references, and displayed content in the selected worksheets are complete.
- Link sharing: If you share by link, confirm that the access settings match your intended audience.
2. Share Partial Worksheet from WPS Home
Entry: Share button for a file on the WPS Home screen > Partial Worksheet
- Find the spreadsheet that you want to share on the WPS Home screen.
- Tap the Share button for that file.
- Select Partial Worksheet.
- Set the worksheet range that you want to share.
- Tap Extract and Send.
- Choose a sending method and complete the sharing process.
Success Criteria
- Interface result: You can enter the Partial Worksheet sharing flow directly from WPS Home.
- Next action available: You can complete sharing without opening the workbook first.
- Verification result: The recipient can view only the extracted worksheet range.
Tips While Using
- Permissions or membership: This feature requires WPS Premium.
- File check: Confirm that you selected the correct workbook before sending.
- Content check: If worksheets contain linked references, review the result before sharing.