The solution to keep the filling numbers in excel: First, enter the starting number at the starting position of the excel cell sequence; then select the cell, move the mouse to the lower right corner of the cell, and when the mouse turns into a filling handle That is, pull down the " " icon; finally click the fill bottom check box and change the filling method to "sequential filling".
Solution to keep the filled numbers in excel:
1. Enter at the starting position of the excel cell sequence Starting number, such as starting with "1" here to quickly fill in the number sequence from 1 to 10.
#2. Select the cell, move the mouse to the lower right corner of the cell, and pull down when the mouse turns into a fill handle or " " icon.
#3. The default copy and fill effect is that the selected cells display the same number.
#4. Click the Fill bottom check box and change the filling method to "Sequential filling".
#5. Completed the fast filling of incrementing numbers.
Related learning recommendations:excel tutorial
The above is the detailed content of What should I do if the filled numbers in Excel remain unchanged?. For more information, please follow other related articles on the PHP Chinese website!