When you use WPS Alternate Row Marking on Windows, 3 common question types come up: data impact, print output, and collaboration display; this FAQ covers 3 frequent questions.
FAQ
Does Alternate Row Marking affect worksheet data?
- No. Alternate Row Marking is only a visual display effect.
- It helps you distinguish adjacent rows more easily without changing the actual data in cells.
- After you turn it off, your data and editing results remain unchanged.
Will Alternate Row Marking be printed with the spreadsheet?
- By default, no. This feature is mainly for on-screen viewing.
- If you want a similar striped effect in print, manually apply fill colors to the cells.
- Before printing, use print preview to confirm the final output.
How to use alternating row colors in WPS on Windows for collaboration without changing other users' views?
- Alternate Row Marking is a local display setting.
- Each collaborator can turn it on or off based on personal viewing preferences.
- This does not change the worksheet data that other collaborators see.
Glossary
| Term | Definition |
|---|---|
| Alternate Row Marking | A visual aid that displays alternating background colors for adjacent rows in a worksheet. |
| View tab | A tab in the top ribbon of WPS Sheets that contains display-related controls. |
| Color scheme | The display color combination used by Alternate Row Marking to adjust reading comfort. |