Common questions about Super Table usually focus on creation, structured references, and converting regular ranges; this FAQ includes 4 common questions and a glossary.
FAQ
What is the difference between a Super Table and a regular cell range?
- A Super Table organizes a data range into a unified table structure.
- After creation, it supports filtering, sorting, styles, and structured references.
- A regular range is more flexible, but it is less clear for long-term maintenance and formula readability.
How do I quickly convert existing data into a Super Table?
- Select the existing data range first.
- Click Table on the Insert tab.
- Confirm the range and header settings to complete the conversion.
Why does my formula not show structured references?
- Make sure the current data range has already been created as a Super Table.
- In the formula, select table columns instead of typing regular cell addresses manually.
- If regular references still appear, re-enter the formula by selecting the table columns again.
Why is new data not added to the Super Table automatically?
- Check whether the new content is entered next to the current table range.
- If the data is inserted too far outside the table, the range may not expand to include it.
- You can adjust the table range again or continue entering data at the end of the table.
Glossary
| Term | Definition |
|---|---|
| Super Table | A table-based data range in WPS Sheets for maintaining structured data over time. |
| Structured reference | A formula reference method that uses table names and column names for better readability and maintenance. |
| Header row | The first row of the table that contains field names and supports filtering, sorting, and references. |
| Auto expansion | The behavior where the table range extends as you continue entering data at the end of the table. |