Excel drop down numbers cannot be incremented

Method 1: Pull down and hold the CTRL key at the same time;

Method 2: After pulling down, there is a button in the lower right corner of the drop-down area, click on it and select "Fill Sequence";

Oh, after pulling down, the cell will have a small square dot, and it can choose the way to pull down, there are about three ways.

1.Fill in sequence.

2.Copy only.

3.Fill format.

You choose 1 and he goes down.

If you can't find the small square, use the fill in the menu and select Down.

If you don't understand anything, you can hi me.

Cannot be incremented. Just manually enter 2 consecutive numbers, e.g. A1.

A2 input. Then check A1

A2 point and hold the lower right corner and drag it down.

Since you don't know exactly what form you pull down, if you don't understand.

Just hi me!

The materials that need to be prepared are computers, and the steps for Excel documents are as follows:

1. First of all, we open the excel on our computer, and then we enter 1 in any cell;

2. After that, we select the cell, and then we put the mouse in the lower right corner of the cell, and after the cross symbol appears, we pull down;

3. After that, a button will pop up, we click the button, and the interface that pops up, we click to copy the cell;

Excel refers to Microsoft Office Excel electronic software.

Microsoft Office is an office software suite developed by Microsoft Corporation, which can run on Microsoft Windows, Windows Phone, Mac family, iOS and Android.

Like other office applications, it includes federated servers and internet-based services. From 2007 versions of Office are called "Office System" instead of "Office Suite", reflecting the fact that they include servers.

Excel** drop-down number increment is as follows:

1. First open Excel**select any** input number, put the cursor in the lower right corner of the cell, and wait for the cursor to become a solid "+" symbol;

2. When the cursor of the placed cell becomes a solid "+" symbol, pull down, and the number will not change at this time;

3. After the drop-down operation is completed, click on the "Autofill option at the red box position" in the lower right corner;

4. Click "Autofill Options at the Red Frame Position", the option box will pop up, and select and click "Fill Sequence";

5. After selecting the filling sequence, the numbers will be automatically sorted by size after the operation is completed, and this is done.

One click. Then tap Fill by serial number.

Question: No this.

A plus sign appeared.

Pull all the way down.

That's it.

Question: I'm away from the computer, I'll take a look at it later.

Set the format of the pull-down to fill the sequence, and the pull-down number will be incremented.

1. Take Excel2010 version as an example, as shown in the figure below, the number 1 of cell A1 should be pulled down to show an increasing state;

2. Put the mouse in the lower right corner of cell A1, and then pull down to fill in, and see that the numbers are all 1;

3. There is an inverted triangle in the lower right corner of this column of numbers, click on this inverted triangle to set it;

4. Select "Fill Sequence" in the pop-up setting box, and click the circle in front of it to select this format;

5. Then you will see that the number in this column is incremented when you pull it down, and the filling format is successful.

The system does not determine that you want to get a set of increasing sequences, there are two ways: the first is to hold down the Ctrl key and pull down at the same time, and you will get a set of increasing numbers; The second way is that you enter another number, for example, if you enter 1 can not be incremented, enter 2 in the next row, select the cell where 1 and 2 are located at the same time, and then drop down in the lower right corner of 2, you will get a set of increasing numbers.

First of all, determine whether your cell is textual, if it is text, select a cell to pull down, if it is regular, select a cell and then hold down the Ctrl key to pull down, you can also select two cells and then pull down. There is also a filter state that cannot be filled.

Excel** drop-down numbers do not increment in four steps, here are the steps:

Tools Raw materials: Lenovo Xiaoxin, windows7,

1. Open Excel

First, we open Excel on our computer, and then we enter 1 in any cell;

2. Select the cell.

After that we select the cell, then we put the mouse on the lower right corner of the cell, after the cross symbol appears, we pull down;

3. Click Copy Cell.

After that a button will pop up, we click on the button, and the interface that pops up, we click on copy cell;

4. Done. <>

Excel drop-down number increment setting method:Tools Raw materials: ASUS vivobook, Windows 11, Excel 2016

1. First of all, we are in excel**.

Enter a number "1" in .

2. Then select this number, click "Fill" under "Start", and select "Sequence".

3. In the pop-up sequence window, select the equal difference series.

Or something else, set the step value again, and finally click OK.

4. Let's pull down the input number, so that it is incremental.

Cause: Down-autofill is not set in **.

Solution: Method 1:

1. While dragging the cursor down to fill in the value, press the "Ctrl" button on the keyboard.

2. The number of drop-down fills can be incrementally filled.

Method 2: 1. Fill in the number "1" in cell A1 and select the cell that needs to be filled with increments.

2. Then click "Rows & Columns" in the toolbar and select "Fill" in the drop-down menu.

3. Then click on the "Sequence" option in "Fill".

4. In the pop-up "Sequence" dialog box, select "Type" as "Equal Difference Sequence" and click OK.

5. You can fill the selected cells into the incrementing value of the equal difference sequence.

Excel still has a lot of features. Bian Xiao uses excel in his daily office, but yesterday, Bian Xiao did not increment when he pulled down the numbers, only copied the numbers. I believe that many friends will encounter the same troubles as Bian Xiao.

After trying some methods on the Internet, Bian Xiao found that he only needed to change the mode of operation. Let's take a look at how Bian Xiao manipulates the drop-down numbers of excel** to achieve increments!

Excel drop-down numbers are not incremental, but copied.

1.Open the excel document, place the mouse in the lower right corner of the cell that needs to be pulled down, and wait until it becomes a cross to start the drop-down;

2.Then we click on "Filling Order" to achieve incremental filling;

3.Enter two data, select and pull down;

4.When you drop it, the delta data will appear.

Excel drop-down numbers do not increment, only copy, do not invert triangles.

In the filtering state, when Excel pulls down the number, no triangle will appear, and you need to cancel the filter before you can operate. To do this, select the row or column you want to work on, then click the "Filter" triangle at the bottom of the start, and then click "Unfilter".

If the conventional method can't solve the problem, you can check whether you have opened the filter or something else in your **, and it's good to cancel it.

Excel** drop-down numbers do not increment in four steps, here are the steps:

Tools Raw materials: Lenovo Xiaoxin, windows7,

1. Open Excel

First, we open Excel on our computer, and then we enter 1 in any cell;

2. Select the cell.

After that, we select the cell, lift the mill and then we put the mouse in the lower right corner of the cell, after the cross symbol appears, we pull down;

3. Click Copy Cell.

After that, a button will pop up, we click on the sensitive matching button, and the interface that pops up, we click on copy cell;

4. Done. The result is as shown in the positive bucket chart, so that the drop-down number does not increase.