How to Use WPS Super Table on macOS

Use Super Table with 4 how-to topics on macOS, all available without membership; choose a topic from the index and follow the steps below.

How-to Index

How-to Guide

1. Insert a Super Table quickly

Entry path: Insert → Table

1. Open an existing worksheet or create a new one in WPS Sheets.
2. Select the data range that you want to turn into a table.
3. Click Table on the Insert tab.
4. Confirm the detected range and header option in the dialog box.
5. Click OK to finish creating the table.

Success Criteria

• Interface result: The selected range appears with table formatting and headers.
• What you can do next: You can continue with filtering, sorting, or entering new data.

Tips While Using

• Common mistake: If the full range is not selected, some data may stay outside the table.
• Environment note: A header row is recommended for easier management later.

2. Convert an existing range into a Super Table

Entry path: Insert → Table

1. Open the worksheet that already contains your data.
2. Select the continuous range that you want to convert.
3. Click Table from the Insert tab.
4. Check whether the detected range is correct.
5. Confirm the settings to complete the conversion.

Success Criteria

• Interface result: The original range changes into a unified table style.
• What you can do next: You can use header-based filtering, sorting, and formula references.

Tips While Using

• Common mistake: Blank rows or blank columns inside the range may require you to adjust the detected area manually.

3. Use structured references in formulas

Entry path: Select a Super Table cell and enter a formula in the formula bar

1. Create a Super Table with headers first.
2. Click the target cell in the table and type an equal sign to start the formula.
3. Select a table column instead of typing a regular cell address manually.
4. Let the formula generate a reference based on the table name and column name.
5. Press Enter to complete the formula.

Success Criteria

• Interface result: The formula shows a table name, column name, or current-row style reference.
• What you can do next: Related calculations remain easier to maintain as the table grows.

Tips While Using

• Common mistake: Typing regular cell coordinates directly reduces the readability of the formula.
• Environment note: Structured references require a Super Table first and do not apply to a regular range.

4. Manage data with a Super Table

Entry path: Super Table header area

1. Go to the header row of an existing Super Table.
2. Use the header dropdown controls to filter or sort data.
3. Adjust the table style or continue entering new data as needed.
4. Check whether newly added data is included in the table range.

Success Criteria

• Interface result: The header row supports filtering or sorting, and new data stays within the table structure.
• What you can do next: You can continue analyzing, filtering, and maintaining the full table.

Tips While Using

• Common mistake: Data entered too far outside the current table range may not be included automatically.