![]() |
How do I number the cells when I am making a list?
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. |
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. |
All times are GMT +1. The time now is 04:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com