How to Use WPS Highlight Rows and Columns on Android

Use Highlight Rows and Columns with 4 how-to topics, including turning it on, changing colors, checking automatic highlighting, and turning it off; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Turn on Highlight Rows and Columns

Entry: Bottom View tab → Highlight Rows and Columns switch

1. Open a spreadsheet file in WPS Office.
2. Tap the bottom View tab.
3. Find Highlight Rows and Columns.
4. Tap the switch to turn it on.

Success Criteria

• Interface result: the Highlight Rows and Columns switch is turned on.
• Next action available: you can change the color or tap cells to check the highlight effect.

Tips While Using

• Common mistake: if you are not in the spreadsheet screen, the related View entry may not appear.

2. Change the highlight color

Entry: Bottom View tab → Highlight Rows and Columns → color options

1. Turn on Highlight Rows and Columns first.
2. Select a different highlight color in the feature area.
3. Return to the sheet and check the current color effect.

Success Criteria

• Interface result: the highlight color changes on screen.
• Next action available: you can continue selecting cells to review the new effect.

Tips While Using

• Common mistake: if the feature is not turned on first, the color effect will not appear in the sheet.

3. Check automatic highlighting for the selected cell

Entry: After turning on Highlight Rows and Columns, tap any cell in the sheet

1. Make sure Highlight Rows and Columns is turned on.
2. Tap any cell in the spreadsheet.
3. Check the display change for that cell's row and column.
4. Tap another cell and confirm that the highlight follows the new selection.

Success Criteria

• Interface result: the row and column of the current cell are highlighted together.
• Next action available: you can continue browsing, checking, or editing spreadsheet content.

Tips While Using

• Common mistake: if no cell is selected and you stay in the menu area, you will not see the linked row-and-column highlight.
• Environment note: this effect is for on-screen viewing and does not change the original cell data.

4. Turn off Highlight Rows and Columns

Entry: Bottom View tab → Highlight Rows and Columns switch

1. Tap the bottom View tab.
2. Find the switch next to Highlight Rows and Columns.
3. Tap it again to turn the feature off.

Success Criteria

• Interface result: the sheet no longer shows the current row-and-column highlight effect.
• Next action available: you can continue browsing or editing the spreadsheet in the normal view.

Tips While Using

• Common mistake: changing the selected cell alone does not turn the feature off; the switch must be disabled.