SOLVED

number cells in increasing order

Copper Contributor

How can i place numbers in the cells increasing in order from a column numbering such as 1,2,3,4,5 ???

4 Replies

@fclusters If you are on a modern Excel version the formula below will generate a number sequence from 1 to 25 (just an example) from left to right, starting in the cell where you enter it.

 

=SEQUENCE(,25)

 

If you have an older Excel version that does not support the SEQUENCE function enter 1 in the first cell, let's say A1. Then enter in B1, =A1+1 , and copy it to the right as far as needed.

@Riny_van_Eekelen  

 

thank you.  that formula works great to number the cells right to left in a row.  what formula to use to number a column top to bottom ?? 

 

 

best response confirmed by Hans Vogelaar (MVP)
Thank you so much. i have been struggling with this using the old method with the new version of excel.
+
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)