How to Use WPS Alternate Row Marking on Windows

Use Alternate Row Marking through 4 task topics, all available without membership; choose a topic from the index and follow the entry path and steps below.

How-to Index

How-to Guide

1. Turn on Alternate Row Marking

Entry path: View tab → Alternate Row Marking

1. Open the spreadsheet file that you want to review.
2. Click the View tab at the top of the window.
3. Find and click Alternate Row Marking on the toolbar.
4. Check whether alternating row colors appear in the current worksheet.

Success Criteria

• Interface result: adjacent data rows show alternating background colors.
• You can continue: keep reviewing, editing, or using other view features.

Tips While Using

• Common mistake: if you are not in a spreadsheet editing view, the entry may not be visible.
• Environment note: this effect applies to the current worksheet display.

2. Turn off Alternate Row Marking

Entry path: View tab → Alternate Row Marking

1. Keep the worksheet open with Alternate Row Marking already enabled.
2. Click Alternate Row Marking again on the View tab.
3. Confirm that the alternating row colors disappear.

Success Criteria

• Interface result: the worksheet returns to a standard display without alternating row colors.
• You can continue: keep editing data or switch to another display method.

Tips While Using

• Common mistake: if the worksheet was not using Alternate Row Marking, the visual change may not be obvious.

3. Choose a custom color scheme

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

1. Open the spreadsheet and go to the View tab.
2. Click the drop-down menu next to Alternate Row Marking.
3. Select the color scheme that you want to use.
4. Return to the worksheet and review the updated row display.

Success Criteria

• Interface result: the alternating row colors update to the selected scheme.
• You can continue: switch to another scheme or turn the feature off.

Tips While Using

• Common mistake: clicking only the main button changes the on or off state instead of opening the color options.

4. Use table styles for printed banded rows

Entry path: table style formatting controls

1. Use Alternate Row Marking first to review the table on screen.
2. If you need the banded effect in printed output, apply a formal fill or table style instead.
3. Open print preview and confirm that the banded effect appears in the output layout.

Success Criteria

• Interface result: the print preview shows the row shading that you want to keep.
• You can continue: print or export the file.

Tips While Using

• Common mistake: printing the display aid directly will not keep the visual effect by default.
• Environment note: use formal formatting for print needs instead of relying only on the display aid.