SOLVED

# WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

Copper Contributor

# WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

So I have a table, and when I fill out one column,

I would like the column to the left of it to automatically show a number

starting with 1, then 2, then 3, then 4, etc.

so every time I fill a row in that one column,

the column to the left will automatically show the number of that row that was filled

So Row one column one will say 1 when I fill out Row one column two.

Row two Column one will say 2 when I fill out Row two column two.

Row three column one will say 3 when I fill out Row three column two.

.

2 Replies
best response confirmed by amisav (Copper Contributor)
Solution

# Re: WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

@amisav this is the forum for Microsoft Forms, not Excel. The Excel forum is at https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral

# Re: WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

@Rob_Elliott Oh... thank you!

1 best response

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

# Re: WHEN I FILL ONE ROW, I WANT ANOTHER ROW TO AUTOMATICALLY FILL WITH 1, then 2, then 3, etc.

@amisav this is the forum for Microsoft Forms, not Excel. The Excel forum is at https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral