To keep the title in WPS table when splitting, you need to make sure that the title is not included in the range you specify for splitting. If the title is included in the range, it will be deleted when splitting happens. To avoid this, you can modify the range before splitting so that it does not include the title row.
To split a table in WPS, follow these steps:
1. Select the entire table that you want to split.
2. Go to "Data" tab in the ribbon, and click on "Split Table."
3. In the "Split Table" dialog box, make sure that "Range" is set to "Entire sheet" and not "Selected Rows or Columns" as shown in the screenshot below.
4. Click on "OK" to split the table.
If you want to keep only one row of titles in your table, you can select only one of them before splitting.
Note: If you want to keep all rows of titles in your table, then you can select all rows before splitting.
图示说明:
请确认以下操作:
1. 选择要拆分的整个表。
2. 在菜单栏中选择"数据",然后点击“拆分表”。
3. 在“拆分表”对话框中,确保“范围”设置为整个sheet,而不是“选定的行或列”,如下图所示。
4. 点击“确定”以完成拆分。
如果希望只保留一列标题,请选择其中任意一列进行拆分。
注意:如果希望保留所有标题,请先选择所有标题行。