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
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!