If you're using Excel 2003 or higher, Excel's "List" functionality (under the
Data menu) is great for inserting rows which retain the formulas and
formatting of the row directly above it without needing to copy & paste.

Just highlight your header row and data area and hit Ctrl+L to convert it to
an Excel List.

This function also converts the header row into an Auto Filter.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Riker1074" wrote:

Thanks Luke, but I didn't want to allow users to select locked cells.

Besides, the users of the file wouldn't know how to do what you suggested, I
really need a way to automate the process so it requires no action on the
part of the user. My target audience is office-illiterate
--
Riker1074


"Luke M" wrote:

When you go to insert, copy the row above where you want to insert, then
right click, paste special formulas.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Riker1074" wrote:

I have a protected worksheet that allows any user to insert new rows. Each
row has 2 formulas and 2 validation managed cells. When a user inserts a
row, the validation is copied, but the formulae are not. How can the
formulae be fromated to fill on inserted rows.
--
Riker1074