WPS Highlight Rows and Columns on Windows FAQ

Common questions about WPS Highlight Rows and Columns usually focus on display behavior, printing, and collaboration; this FAQ includes 4 common questions and a short glossary.

FAQ

Does Highlight Rows and Columns affect printing?

1. No. Highlight Rows and Columns is mainly an on-screen visual aid.
2. Printing or exporting does not rewrite worksheet data because this feature is turned on.
3. If needed, open Print Preview to confirm the output before printing.

Why do I not see an obvious highlight after I change cells?

1. Make sure Highlight Rows and Columns is turned on.
2. Check whether the current highlight color is too close to the worksheet background color.
3. If needed, open the Highlight Rows and Columns menu under View and choose a clearer color.

Does Highlight Rows and Columns change the original cell formatting?

1. No. This feature is used to help you locate the active row and column.
2. It does not directly change text, formulas, or the original fill formatting in cells.
3. After you turn the feature off, the worksheet continues to display its original content and formatting.

Does Highlight Rows and Columns affect what other people see in a shared worksheet?

1. This feature mainly supports reading and navigation in the current interface.
2. You can turn it on or off based on your own viewing needs.
3. If you need to confirm the display in a shared workflow, ask collaborators to check whether the feature is turned on in their own interface.

Glossary