Mar 17 2021 09:14 PM
Hi,
may i ask how do you set a number in a series of 10000 in excel?
For example, i have a number 360000, and i want it to continuously increment in 10000. Say 370000, 380000, 390000.. etc in a column.
If I have some alphabet in the numbers, will excel able to increment the numbers like below as well?
Thank you!
Mar 17 2021 10:49 PM - edited Mar 17 2021 10:59 PM
Hi there,
There are different ways:
1 - Sequence
2- Simple Sum Function
3 - Fill Command
4 - Row Function
5 - Rows Function etc.
Please note attached file:
Good look.
P.S. If you find this answer as your best one, please mention:)
Youtube link: https://www.youtube.com/watch?v=fBo-6_9IKlA
Mar 17 2021 11:49 PM
SolutionTo do that, select the cell with number, right click and hold the bottom right corner of that cell and drag it down for few cells and drag back to the original cell and release the right mouse button. Choose Series from the options and in the next popped window, select Columns and then specify the Step Value and Stop Value and then click ok to finish.
Refer to the following short demo video (without audio but I guess it's easy to follow).
Mar 17 2021 11:49 PM
SolutionTo do that, select the cell with number, right click and hold the bottom right corner of that cell and drag it down for few cells and drag back to the original cell and release the right mouse button. Choose Series from the options and in the next popped window, select Columns and then specify the Step Value and Stop Value and then click ok to finish.
Refer to the following short demo video (without audio but I guess it's easy to follow).