How can I insert the same content in every row? How to add the same content in batches in wps

php editor Xigua introduces to you the method of adding the same content in batches in WPS word processing software. When processing documents, sometimes you need to insert the same content in each line. In this case, you can use the shortcut function of WPS to achieve this. With simple operations, you can easily add the same content in batches to each row to improve work efficiency. Next, let’s learn about the specific steps!

Copy data through cell filling

Select the cells to which data needs to be copied.

Hold down the Ctrl key and drag the cell fill handle. As shown below:

Or select the initial value cell and double-click the fill handle to complete automatic copy filling.

Create a sequence by filling cells

Select the cell as the initial value.

Drag the cell fill handle.

Normally, if you drag the fill handle to the right and down, the filled values ​​will be sorted in ascending order; if you drag the fill handle to the left or up, the filled values ​​will be sorted in descending order.

If you need to change the properties of the fill sequence, such as changing the "step value" (the default value is 1), on the "Home" tab, select the sequence in "Fill" under the "Rows and Columns" drop-down list, and in the dialog Make settings in the box.

Double-click to fill the sequence

Double-click filling is a shortcut operation method for data filling, and its filling rules are the same as those of dragging the fill handle.

The operation method is very simple: select a cell area and double-click the fill handle to complete the filling.

For example: If you want to type the number sequence "1, 2, 3...112" in B1:B112, just enter "1" in B1, select B2:B112, and double-click the fill handle. If you need to type the text sequence "1st, 2nd,...97th" in "C1:C97", you only need to type "1st" in C1, select cell C1, and double-click the fill handle. .

Autofill option tag

When the data is automatically filled using the fill handle or double-clicking, an auto-fill label will appear at the target location, and you can choose the format in which to fill it. As shown below.

The above is the detailed content of How can I insert the same content in every row? How to add the same content in batches in wps. For more information, please follow other related articles on the PHP Chinese website!