How to change number automatically when extending cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2210588%22%20slang%3D%22en-US%22%3EHow%20to%20change%20number%20automatically%20when%20extending%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2210588%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20(what%20I%20think%20it%20is)%20a%20simple%20question.%3C%2FP%3E%3CP%3EWhen%20copying%20a%20cell%20with%20a%20number%20by%20selecting%20it%20and%20pulling%20it%20with%20the%20mouse%20to%20the%20next%20empty%20cell%2C%20the%20number%20usually%20increases%20automatically.%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20where%20this%20doesn't%20happen%20and%20I%20don't%20know%20why.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%3CBR%20%2F%3E8015194%3C%2FP%3E%3CP%3E*select%20and%20extends%20to%20the%20following%2C%20the%20numbers%20become*%3C%2FP%3E%3CP%3E8015195%3C%2FP%3E%3CP%3E8015196%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20my%20spreadheet%2C%20it%20continues%3C%2FP%3E%3CP%3E8015194%3C%2FP%3E%3CP%3E8015194%3C%2FP%3E%3CP%3E8015194%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20column%20is%20formatted%20as%20Number%2C%20Decimal%20places%20as%200.%3C%2FP%3E%3CP%3EAny%20idea%20why%20this%20is%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2210588%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello all,

 

I have (what I think it is) a simple question.

When copying a cell with a number by selecting it and pulling it with the mouse to the next empty cell, the number usually increases automatically.

I have a spreadsheet where this doesn't happen and I don't know why.

 

For instance
8015194

*select and extends to the following, the numbers become*

8015195

8015196

In my spreadheet, it continues

8015194

8015194

8015194


The column is formatted as Number, Decimal places as 0.

Any idea why this is happening?

 

TIA

4 Replies

@thazardhc 

Excel doesn't work that way - never has.

Excel will increase a date when you fill it down, and also a text value that ends in a number, such as Item1.

If you want to create a series of numbers, enter the first two numbers, then select the two cells and drag the fill handle.

 

S0212.png

Alternatively, enter the first number, then select Fill > Series... on the Home tab of the ribbon.

Specify that you want a series in columns, and enter the stop (last) value, then click OK.

 

S0213.png

Excel only automatically increases numbers when you pull the fill handle on ONE cell, it that cell does not contain a number, but if that cell contains a text which happens to end with a number. This can also be just a number which is formatted as text.

To get what you want, either select TWO cells (with the difference you want to fill) and use the fill handle, or use the RIGHT mouse button while you drag the fill handle. When you release the right mouse button, Excel will show a menu.

@Jan Karel Pieterse thank you for answering.

Indeed, changing it for text and selecting 2 or more cells did the trick

@Hans Vogelaar thank you for the extra tip!

I managed to make it work now, tks!