How to Use WPS Alternate Row Marking on macOS

Last updated:July 20, 2026

Use Alternate Row Marking with 3 how-to topics, including turning it on, turning it off, and changing the color scheme; choose a topic from the index and follow the entry point and steps.

How-to Index

#TopicMembership
11. Turn On Alternate Row MarkingFree
22. Turn Off Alternate Row MarkingFree
33. Change the Color SchemeFree

How-to Guide

1. Turn On Alternate Row Marking

Entry point: View tab → Alternate Row Marking

  1. Open the spreadsheet file you want to review.
  2. Click the View tab at the top of the window.
  3. Find Alternate Row Marking on the toolbar.
  4. Click Alternate Row Marking to show alternating row colors.

Success Criteria

  • UI state: Nearby rows display alternating background colors.
  • Next actions: You can continue reviewing, editing, or checking the table.
  • No side effects: The actual cell data remains unchanged.

Tips While Using

  • Common mistakes: If no spreadsheet is open, the visual change may not be obvious.
  • Environment limits: This is an on-screen display aid and does not print by default.

2. Turn Off Alternate Row Marking

Entry point: View tab → Alternate Row Marking

  1. Keep the spreadsheet file open.
  2. Click the View tab.
  3. Click Alternate Row Marking again.
  4. The table returns to its normal display without alternating row colors.

Success Criteria

  • UI state: The alternating row colors disappear.
  • Next actions: You can continue editing, saving, or changing other view settings.
  • No side effects: Cell values and data content stay the same.

Tips While Using

  • Common mistakes: If the table already has manual fill colors, distinguish them from the display aid effect.

3. Change the Color Scheme

Entry point: View tab → Alternate Row Marking drop-down menu

  1. Open the spreadsheet and make sure Alternate Row Marking is already visible.
  2. Click the drop-down menu next to Alternate Row Marking.
  3. Select the color scheme you want.
  4. Check whether the alternating row colors update in the table.

Success Criteria

  • UI state: The alternate row colors update to the selected scheme.
  • Next actions: You can keep reviewing the table or switch to another scheme.
  • No side effects: Only the display style changes, not the data.

Tips While Using

  • Common mistakes: If the color contrast is subtle, switch to a more visible scheme.