Current location - Health Preservation Learning Network - Slimming men and women - How to create a button in the EXCEL table of wps software and click it once to add 1 to the number in the corresponding cell?
How to create a button in the EXCEL table of wps software and click it once to add 1 to the number in the corresponding cell?
You can use its own features to fine-tune the project. Let's share the operation steps briefly.

Computer: MacBook Air

System: macOS 12

Software: WPS20 19

1. First, we open the Excel form. I will fill in a numerical value, such as 88.

2. Then we click Insert at the top.

3. Then click the table on the right, and a pop-up list will pop up. Click to select a fine-tuning project.

4. Then press and hold the left mouse button beside the numerical value to draw a fine-tuning item button, as shown in the figure.

5. Then right-click the button and select Format Object.

6. Then we can set the current value to 88 or other values, then select 88 in the cell link and click OK in the lower right corner to complete the setting.

7. Then we can click the button to realize+1.

I hope it helps you. If you have any questions, please leave a message. Thank you.