SOLVED

How do you increment numbers by 10000?

Copper Contributor

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.

 

excel.JPG

If I have some alphabet in the numbers, will excel able to increment the numbers like below as well?

excel1.JPG

 

Thank you!

2 Replies

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

 

 

best response confirmed by joshlabtech (Copper Contributor)
Solution

@joshlabtech 

To 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).

 

1 best response

Accepted Solutions
best response confirmed by joshlabtech (Copper Contributor)
Solution

@joshlabtech 

To 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).

 

View solution in original post