How to batch modify content in excel

Modification method: First open the excel table, select the content that needs to be modified; then press the "ctrl f" key on the keyboard to pop up the "Replace" dialog box; then enter the required content in the "Find Content" input box To replace the value, enter the specified text in the "Replace with" input box, click the OK button,

The operating environment of this tutorial: Windows7 system, WPS Office2016 version, Dell G3 computer.

Select the content that needs to be modified in batches. After pressing the left button of the mouse, drag and drop to select the content.

Use keyboard shortcuts. Press: Ctrl key F key,

Then, the following window pops up,

Click on the item in the search window : Replace P and make batch modifications, for example: Replace all numbers 19 with: Number 20,

Then click the button: Replace all, so the result is as follows,

Of course, you can also batch replace the entire specified Excel table, without selecting the content.

Related learning recommendations: excel tutorial

The above is the detailed content of How to batch modify content in excel. For more information, please follow other related articles on the PHP Chinese website!