How do I auto-number rows in excel?
Hi
You can use the ROW() function to put a number against each line (row 1 will
get 1, row 2 will get 2 etc) .. and if you move lines around or insert lines
each line will automatically renumber. However, if you do insert lines, the
new line will be blank so you will have to either copy the line above or put
=ROW() in the cell that you want to use to number the rows.
Is this what you're after, or do your invoices have specific numbers and if
you insert rows do you really want you invoice numbers to change. If you'ld
like to provide more details maybe we can come up with a better solution.
Cheers
JulieD
"Edstar1979" wrote in message
...
I am trying to create an invoice log where I need to number the cells. I
have
been told that excel is capable of numbering the log itself. I would be
very
grateful if somebody could inform me how.
|