WPS Column Type on Windows FAQ

Last updated:July 20, 2026

When using Column Type, common questions usually focus on existing data, dropdown setup, and starting-row control; this FAQ includes 3 common questions and a glossary.

FAQ

What happens to existing data after I set a column type?

  1. Existing data is displayed and checked according to the new column type rules.
  2. For example, if you change a text column to a date type, values that can be recognized as dates are shown in a date format.
  3. Content that does not match the preset restriction stays in place and is marked as not matching the preset rule.

Where do I set the options for a dropdown list type?

  1. Right-click the target column header and open the Column Type submenu.
  2. Select the Dropdown List type.
  3. In the settings panel that opens, add or adjust the option values and complete the setup.

What is the purpose of setting the starting row?

  1. Setting the starting row controls which row the column type starts from.
  2. When the default is row 2, row 1 can usually stay as the header row.
  3. If the first few rows are used for titles, notes, or data that should not be formatted, set a later row number.

Glossary

TermDefinition
Column TypeA setting that assigns a consistent data format and input rule to an entire column.
Starting RowThe row number where the selected column type begins to apply.
Dropdown ListA column type that limits input to predefined options.
CheckboxA column type used to record status by checking or clearing a box.
ClearRemoves the current column type and returns the column to plain text.