Why are all 1 in excel input 1 dropdowns?Excel is a very easy to use data processing software, which can intelligently help users to process data. excel with the function of filling, there are many ways to fill after pulling down, but many friends report that they will not increase after pulling down, so what's going on?Today, I will bring you the excel input 1 drop-down why it is all 1 related content, let's take a look. Excel skills
excel input 1 pulldown why is it all 1 method one
1. First open the folder that we need to operate
2. Enter the number 1 in cell A2, then select cell A2, pull the mouse to the lower right corner of cell A2, and drag down
3. At this time, we see that the numbers filled in when dropping down are all 1, and we click the icon of "Autofill Options" in the lower right corner;
4. Then check "Fill Sequence";
5. At this time, the filled 1 has become an increasing number.
excel input 1 pull-down why is it all 1 method two
1. Enter the numbers 1 and 2 in A1 and A2 respectively
2. Then select these two units, click the small square in the lower right corner, and pull down after the mouse becomes a + sign
3. In this case, it is also filled in incrementally.
The above is all the content of the excel input 1 pulldown brought to you today why it is all 1 and the excel pulldown number is not incremented but only copied, I hope it can help you.