route217
asked on
add reference numbers in column a tricky
Hi Experts excel 2007
I want to to add in cell a3 =a2+1 and scroll all the way down so I increment the numbers by 1. However, if I delete a8 row the formula below cell a8 come with #ref errors how do you get around this.
I want to to add in cell a3 =a2+1 and scroll all the way down so I increment the numbers by 1. However, if I delete a8 row the formula below cell a8 come with #ref errors how do you get around this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER