How Excel-specific data is batch processed

1. Open the Excel table, select the table data you want to work with, and then click "Data" → "filter" on the toolbar.

2. Customize the way of filtering according to your own needs.

3. After the filter is finished, the table will only show the content after the filter. Then copy what you need to add.

4. Select the filtered data and click F5 to eject the positioning box, then click on "Positioning conditions."

5. Then select "Visible cells" to determine.

6. Switch to sticky paste option and click on "Selective sticky paste".

7. Select the "Plus" in the operation.

8. This time the data in a particular cell is added in bulk with replicated data.