How to highlight the found cell?

November 15, 2021
44 Views 0

Graphic skills

1. Use WPS Office to open your spreadsheets.

2. Selecting the areas that contain the data you want to filter, click the Home tab, then select Find and Replace,  you can also use the shortcut Ctrl+H.

3. Click Format before clicking pattern to set the background color as needed. Also, other format changes in Replace Formats, including  Border and Font, are available to change.

How to highlight the found cell1.gif

4. Select Replace All to highlight the searched content.

How to highlight the found cell2.gif

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.