Forum Discussion
Once Block in Numerical Order
I hope someone can help me because I know this is possible, I just can't find the solution. I have an Excel PO form that I use, and I need the PO# to automatically populate in numerical order e...
One way to do this is by using the ROW function.
Here’s an example:
- In the first cell of the range that you want to number (e.g., cell A1), type =ROW(A1).
- This will return the number of the row that you reference (in this case, 1).
- Drag the fill handle across the range that you want to fill.
As you drag the fill handle, Excel will automatically fill in the cells with sequential numbers.
This method will automatically number the rows in the range that you specify.
I hope this helps!