Find similar content quickly

This is relatively simple, just a little trick for searching. First select the range we need to search for. For example, if we want to search for column B, we must first select column B.

Then hold down the Ctrl+F key combination on the keyboard to open the search option. For example, if we are looking for the word Zhao, we enter Zhao in the search field, and then click Search All.

After clicking Find All, an option box will pop up below. At this time, we can see a description at the bottom that 8 cells have been found. Clicking one by one will automatically locate the cell where it is located.

Set the same format

Sometimes in order to make the table more beautiful, we need to set the same format for the same content to make the table clearer. For example, we want the same words in column B to have the same format. Let's select column B first.

After selecting the format, select Start--Conditional Formatting to enter the conditional formatting setting page.

After entering the conditional formatting, for example, if we want to set Zhao as red font and Qian as green font, then we need to select the cell value --- equal to -- and then enter Zhao in it, and then click the format option.

After entering the format options, click the Font tab and set the font to bold and the font size to 36. The color is red, click OK.

Then click the Add button in conditional formatting and repeat steps 3.4. The only downside is choosing another color when choosing a color.

At this time, if our cells are not large enough to fit the 36-point font, we will see something like this. Just reset the cell format.

​

The above is what the editor said aboutI hope it will be helpful to everyone on how to quickly search and format wps tables. For more exciting tutorials, please pay attention to Huajun Software Park.