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 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.
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.
JKPieterse thank you for answering.
Indeed, changing it for text and selecting 2 or more cells did the trick 🙂