Inserting new record with existing formulas available

[Shezza]

Hi..

This is probably a really simple prob -- but here goes.

I have a worksheet / database with Customer Data. They are sorted alphabetically by last name.

When adding a new record, we are scrolling to the row where the new data would go, select the ROW, right click and INSERT. A new row is added and I can proceed to enter my new data.

Although formatting is copied on the new rew (from the row above I asssume), the formulas are not available on the new record and they need to be copied/dragged to the new row.

Is there a way that the formulas will be present in the new record... and/or is there a better way that I can add new records (which would be sorted to the appropriate row and with formulas attached)??

Hope someone can help..

 

[chicagodiceman]

This is one way although it may not work with formulas as you thought it would. Check your results.

Click on the row number (not an actual cell) and right-click. Select copy. select cell A (whatever row is below copied row) and right-click again.

Click Insert Copied Cells. This will insert a copy of all formats as well as the formulas.

If this isn't exactly what you're looking for, please post again.