Forum Discussion
How to change number automatically when extending cells
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 aut...
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.
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.
HansVogelaar thank you for the extra tip!
I managed to make it work now, tks!
