Numbered Line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I want a numbered line to begin on line 14 of a worksheet & I want the list to automatically re-number when I delete a line, I'm using the formula +ROW()-ROW($13:$13). What formula do I use if I want to start on line 14 & add or delete a line & have the list automatically re-number? Your help is appreciated!
 
What you have should work. What is the problem?

--

Vasant

Sue said:
When I want a numbered line to begin on line 14 of a worksheet & I want
Click to expand...
the list to automatically re-number when I delete a line, I'm using the
formula +ROW()-ROW($13:$13). What formula do I use if I want to start on
line 14 & add or delete a line & have the list automatically re-number? Your
help is appreciated!
 
If I'm on line 3 & I insert a row, my list reads 1, 2, 4 and line 3 is blank. My list is not automatically re-numbering when I insert a row only when I delete a row. What formula do I use? Your help is appreciated

----- Vasant Nanavati wrote: ----

What you have should work. What is the problem

--

Vasan

Sue said:
When I want a numbered line to begin on line 14 of a worksheet & I wan
Click to expand...
the list to automatically re-number when I delete a line, I'm using th
formula +ROW()-ROW($13:$13). What formula do I use if I want to start o
line 14 & add or delete a line & have the list automatically re-number? You
help is appreciated
 
You can't, the new row will obviously be without a formula
That is why you have the row headers, they will always have the right number
You would need a macro for that

http://www.mvps.org/dmcritchie/excel/insrtrow.htm

--

Regards,

Peo Sjoblom


Sue said:
If I'm on line 3 & I insert a row, my list reads 1, 2, 4 and line 3 is
Click to expand...
blank. My list is not automatically re-numbering when I insert a row only
when I delete a row. What formula do I use? Your help is appreciated.
 
Back
Top