WPS Highlight Rows and Columns on macOS FAQ

Last updated:July 20, 2026

When using Highlight Rows and Columns, the most common questions focus on print output, collaborative display, and feature behavior; this section covers 3 frequent questions.

FAQ

Does Highlight Rows and Columns affect print output?

  1. Highlight Rows and Columns is an on-screen visual aid.
  2. When you print or export, the spreadsheet data remains unchanged.
  3. If needed, use print preview to confirm the output result.

Does Highlight Rows and Columns apply to all collaborators at the same time?

  1. This feature is used as a local visual aid while viewing a sheet.
  2. Each collaborator can turn the display effect on or off based on personal needs.
  3. One user’s display setting does not change another collaborator’s viewing state.

Why do I only see a color change instead of data changes when I turn it on?

  1. Highlight Rows and Columns is designed to help you locate the row and column of the current cell.
  2. It does not modify cell content, formulas, or stored formatting data.
  3. If you need to change sheet content, continue with editing, fill, or formatting tools.

Glossary

TermDefinition
Highlight Rows and ColumnsA visual aid that shows a highlight color across the full row and column of the currently selected cell to help with location.
Status barThe area at the bottom of the window that can provide quick toggles or status information.
Custom ColorA user-selected display color used to adjust the visual effect of the highlight.