How to Add Editable Text to Rows in a WPS Spreadsheets PivotTable
Question details
The user wants to know whether a free-text column can be added directly to an Excel or WPS Spreadsheets PivotTable and remain linked to the same row after the source data is refreshed.
- Product
- WPS Spreadsheets PivotTable
- Device & OS
- not provided
- Scenario
- Working with a PivotTable and needing row-level comments or editable text that stays aligned after refresh.
- Observed behavior
- A native PivotTable does not support independently editable text beside each pivot row; manually entered text can move or be overwritten after refresh.
Open the workbook that contains the PivotTable and locate its source data range or table. Make sure the source data has a stable unique key, such as Order ID or Customer ID, that can link each row to the added text.
Add the Text to the Source Data Table and Include It in the PivotTable
Use this method when the free-text comments belong to the source records and must survive every PivotTable refresh.
A PivotTable reads only from its source data. Any manually typed value inside the pivot area is not part of the data model and can shift or disappear after a refresh. Adding the comment as a new source column keeps it linked through a stable key.
In WPS Spreadsheets, go to the worksheet that contains the source data for the PivotTable and click any cell inside the data range.
On the Insert tab, choose Table if the range is not already a table, and confirm that every row has a stable unique key such as Order ID or Customer ID.
Insert a new column in the source table named Comments or Notes and type the free text on the row for each record.
Click inside the PivotTable, open the PivotTable Fields pane, then drag the new Comments field into the Rows area or Values area so it appears beside the row data.
On the PivotTable tab or PivotTable Analyze tab, click Refresh, then confirm the text stays with the correct row.
Link Editable Comments from a Separate Lookup Table
Use this method when you cannot or prefer not to add comment columns directly to the source data, or when multiple PivotTable layouts need the same comments.
Keep Row Comments Linked in a WPS Spreadsheets PivotTable
Use WPS Spreadsheets to add free-text comments to the source data table and include that field in your PivotTable. This keeps each comment aligned with the correct row after every refresh, without entering text directly into pivot cells.
- 1. Open WPS Spreadsheets: Download and launch WPS Office, then open your Excel workbook in WPS Spreadsheets.
- 2. Prepare the source data: Click the source data worksheet, select the data range, and use Home > Format as Table or Insert > Table to give the data a structured table.
- 3. Add the comment column: Insert a new column in the source table for the free text, enter the row comments, and save the workbook.
- 4. Refresh the PivotTable: Click the PivotTable, go to the PivotTable tab or PivotTable Analyze tab, click Refresh, and confirm the editable text stays aligned.
Frequently Asked Questions
Can I type text directly into a PivotTable row?
No. PivotTable cells are not independent editable data cells. Text typed into the pivot area may be lost or moved after you refresh the PivotTable.
How do I keep comments linked to the correct row after a PivotTable refresh?
Add the comments as a column in the source data using a stable unique key, then include that field in the PivotTable. Refresh uses the source data relationship to keep each comment aligned.
Does WPS Spreadsheets support the same PivotTable field list as Excel?
Yes. WPS Spreadsheets includes a PivotTable Fields pane and PivotTable tools, and it works with Excel .xlsx PivotTables.
What happens if I refresh a PivotTable after entering manual text next to it?
Manual text is not part of the pivot cache, so refresh may overwrite or reposition it. Always store the text in the source table or a linked lookup table.
Can I use VLOOKUP to bring editable comments into a PivotTable?
Yes. Create a separate lookup table keyed by a stable ID and use a helper column in the source data to retrieve the matching comment before it appears in the PivotTable.
