How to Use WPS Insert Spreadsheet on Windows

Use WPS Insert Spreadsheet through 5 task topics, with 5 available without membership and 0 membership-related items; start from the How-to Index to jump to the task you need.

How-to Index

How-to Guide

1. Insert a spreadsheet from the ribbon

Entry path: Insert → Spreadsheet

1. Place the cursor where you want to insert the spreadsheet.
2. Click the Insert tab at the top of the window.
3. Select Spreadsheet.
4. Choose the row and column size to finish insertion.

Success Check

• What you should see: a new spreadsheet area appears in the document.
• What you can do next: start entering data in cells or continue adjusting the table.

Notes

• Common mistake: if the cursor is not placed first, the spreadsheet may be inserted in an unexpected location.

2. Insert a spreadsheet with slash commands

Entry path: Paragraph input → / → Spreadsheet

1. Type / in a paragraph to open the quick insert menu.
2. Type Spreadsheet or sheet to search.
3. Select the spreadsheet option to insert it.
4. You can also use /dzbg, /et, or /sheet directly.

Success Check

• What you should see: the spreadsheet option appears in the quick menu, and a spreadsheet is inserted after selection.
• What you can do next: start entering data right away.

Notes

• Common mistake: typing the command without confirming the menu option may not complete the insertion.

3. Edit the spreadsheet inside the document

Entry path: Double-click the spreadsheet → Enter edit mode

1. Select a cell, or double-click a cell to enter editing.
2. Enter or change the content in the cell.
3. After selecting a cell, use the floating toolbar or the right-click menu to adjust formatting and content.
4. Click outside the spreadsheet area to finish the current edit.

Success Check

• What you should see: cells can be selected and show an editable state.
• What you can do next: continue editing other cells or return to the document body.

Notes

• Common mistake: clicking only the outer frame instead of a cell may not let you edit the content directly.

4. Use formulas and data tools

Entry path: Select spreadsheet cells or a range, then apply the needed tool

1. Select the data range that you want to calculate or process.
2. Enter the formula you need, or use the available spreadsheet tools.
3. Apply filtering, sorting, or a drop-down list as needed.
4. Check whether the result matches your expectation.

Success Check

• What you should see: formula results display correctly, and filtering or sorting changes the data state.
• What you can do next: add more data, adjust conditions, or save the document.

Notes

• Common mistake: if the wrong range is selected first, filtering, sorting, or drop-down lists may apply to the wrong area.

5. Save the spreadsheet as a separate file

Entry path: Spreadsheet floating toolbar → More → Save as spreadsheet

1. Click the spreadsheet in the document to open the floating editing bar.
2. Click More.
3. Select Save as spreadsheet.
4. Follow the prompts to save it as a new smart spreadsheet file.

Success Check

• What you should see: a save or export window appears.
• What you can do next: open the new spreadsheet file separately for further work.

Notes

• Common mistake: if the target spreadsheet is not selected first, the floating toolbar may not appear.