How do I number the cells when I am making a list?
In the column next to the column you are entering the names you could put the
formula...
=ROW()-X (where X is 1 minus the row # of where your list starts). Example
if you begin your list in row 20 you would put the formula =ROW()-19. That
way your list would start with 1 (20 - 19).
Hope that helps.
"Marybeth" wrote:
I am needing to number a list of names that I am typing, so that I know how
many I have. However, I have been unsuccessful in finding how to number the
cells as I go. Does any one have any ideas? Thank you.
|