How to Use WPS Super Table on Windows

Use Super Table through 4 how-to topics, including quick creation, converting existing data, understanding table differences, and maintaining added rows; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Quickly create a Super Table

Feature entry: Insert tab → Table

1. Open WPS Spreadsheet and go to the worksheet you want to edit.
2. Click Table on the Insert tab.
3. Confirm or select the data range in the dialog box.
4. Click OK to finish creating the table.
5. You can also select a range first and press Ctrl+T.

Success Criteria

• Interface result: The selected range is displayed with table styling and a manageable header area.
• What you can do next: You can continue filtering, sorting, or entering new data in the table.

Tips While Using

• Common mistake: If you do not confirm the range first, extra blank rows or columns may be included.
• Environment note: If the worksheet is protected, some editing actions may be limited.

2. Convert existing data into a Super Table

Feature entry: Select a data range → Insert tab → Table

1. Select the existing data range in the worksheet.
2. Click Table on the Insert tab, or press Ctrl+T.
3. Check whether the range in the dialog box is correct.
4. Confirm the selection to complete the conversion.

Success Criteria

• Interface result: The original data stays in place but is shown as a structured table.
• What you can do next: You can continue with table styling, filtering, and structured-reference-related work.

Tips While Using

• Common mistake: If the first row is not used as field names, later filtering and recognition may be less clear, so it helps to organize the header row first.

3. Understand the difference between a Super Table and a normal range

Feature entry: Select a Super Table range and observe its behavior

1. Prepare one normal cell range and one Super Table range in the same worksheet.
2. Try adding data, filtering, and changing styles in both areas.
3. Observe how the Super Table behaves in auto-expansion, filtering, consistent styling, and structured references.
4. Decide whether the table format fits your data maintenance needs.

Success Criteria

• Interface result: The Super Table is easier to manage consistently than a normal range.
• What you can do next: You can choose the more suitable data structure for your worksheet scenario.

Tips While Using

• Common mistake: Converting one-time display-only content into a Super Table may add unnecessary structure to the worksheet.

4. Maintain newly added data in a Super Table

Feature entry: Continue entering data at the end of the Super Table

1. Open a worksheet that already contains a Super Table.
2. Enter a new record at the end of the table.
3. Check whether the new content is included in the table range.
4. Continue using filtering, sorting, or styling to review the full result.

Success Criteria

• Interface result: New records keep the same structure and style as the existing table.
• What you can do next: The added data can continue to be used in later organization and analysis.

Tips While Using

• Common mistake: If you leave blank rows or columns outside the table before entering new data, the new content may not stay connected to the current table range.