You can also click on the ro(to hilight the whole thing) and right click->copy. Higlight the row you want the same formulas and right click->paste special and choose formulas. That should give you the same formulas for the other row.
I hope this is what you mean, if not, I didn't understand your question. :-)
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel automatic formula copy to new row
appear in a new row?