Home  >  Article  >  Topics  >  What should I do if the filled numbers in Excel remain unchanged?

What should I do if the filled numbers in Excel remain unchanged?

coldplay.xixi
coldplay.xixiOriginal
2020-10-12 09:49:0834921browse

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".

What should I do if the filled numbers in Excel remain unchanged?

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.

What should I do if the filled numbers in Excel remain unchanged?

#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.

What should I do if the filled numbers in Excel remain unchanged?

#3. The default copy and fill effect is that the selected cells display the same number.

What should I do if the filled numbers in Excel remain unchanged?

#4. Click the Fill bottom check box and change the filling method to "Sequential filling".

What should I do if the filled numbers in Excel remain unchanged?

#5. Completed the fast filling of incrementing numbers.

What should I do if the filled numbers in Excel remain unchanged?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn