Hi
not sure i understand the question, but is the "problem" that you have a
formula that says
=SUM(A2:A58)
and now when you go to add information into row 59 you have to edit the
formulas?
in that case, why don't you just make the formulas bigger e.g.
=SUM(A2:A1000) or
or alternatively create a dyanamic range names that resizes itself when you
add new records at the bottom of the data - you can then use that range name
in formulas e.g. =SUM(mynums)
check out
http://www.contextures.com/xlNames01.html#Dynamic
for details on how to do this
Please post back if i've completely missed the point.
Cheers
JulieD
"ukash" wrote in message
...
How can I move last row to second row? When I'm opening excel document
it's last row is for example in 58 row but there is now data in there.
Is there any way to manualy set last row?
--
ukash