Home  >  Article  >  Software Tutorial  >  Wps2019 tutorial on adding numbers to 5 in batches

Wps2019 tutorial on adding numbers to 5 in batches

WBOY
WBOYforward
2024-04-26 13:25:061098browse

Confused about how to efficiently add numbers to 5 in batches? PHP editor Yuzai has hereby prepared a detailed WPS 2019 operation tutorial to guide you step by step to easily complete this task. Through this article, you will learn: How to add 5 in batches in WPS tables. Use formulas and functions to perform batch operations. Combine with macro commands to achieve automated processing. Please continue reading the following details to master the skills of adding 5 in batches and improve your work efficiency!

Use wps2019 to open the table to be edited, and click the [Featured Application] menu item in the menu bar.

Wps2019 tutorial on adding numbers to 5 in batches

Click the [Smart Toolbox] icon on the featured application toolbar.

Wps2019 tutorial on adding numbers to 5 in batches

In this way, you can see the menu item of [Smart Toolbox] in the wps2019 menu bar.

Wps2019 tutorial on adding numbers to 5 in batches

Next select the entire column of data you want to operate on.

Wps2019 tutorial on adding numbers to 5 in batches

Click the [Cell Processing] drop-down button on the smart toolbox toolbar.

Wps2019 tutorial on adding numbers to 5 in batches

Click on the pop-up cell to process the [Addition, Subtraction, Multiplication, Division/Plus] menu item in the drop-down menu.

Wps2019 tutorial on adding numbers to 5 in batches

The [Unified Calculation] window will pop up. Enter the number 5 to be added in the window, and finally click OK.

Wps2019 tutorial on adding numbers to 5 in batches

At this time, you can see that 5 has been added to the entire selected column.

Wps2019 tutorial on adding numbers to 5 in batches

The above is the detailed content of Wps2019 tutorial on adding numbers to 5 in batches. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete