Joke Collection Website - News headlines - How does Excel mark when in every sentence of a table?

How does Excel mark when in every sentence of a table?

Excel marks when in every sentence in the table. It is not easy to operate directly with Excel, but it can be done with the help of Word. The specific operation steps are as follows:

Step 1: Copy and paste the data in the Excel table into the Word document;

Step 2: Press Ctrl+H to open the Find Replace dialog box;

Step 3: Enter: when in the Find What text box.

Step 4: Enter: when in the Replace With text box.

Step 5: Click the Format button-Font Options-Color drop-down list-Select Color-OK button in turn.

Step 6: Click the Replace All button, and then copy and paste the data in the Word document back into the Excel table.