How to add 1 to numbers in excel table

How to add 1 to the numbers in excel table

1. Open Excel2010 and enter the options and questions as shown in the figure

Recommended "excel tutorial"

2. Press and hold alt F11, the following window will appear

3. Open the code window and copy the following code into itPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)Target = Target 1End Sub

4 , save, and then make a cross in the upper right corner

##5. Finally, click like this, and the number will be increased by one. After you are done, press alt F11 to delete the code and save it. Can

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