Inserting new record with existing formulas available

Shezza

New Member
Joined
Sep 8, 2006
Messages
3
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..
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

chicagodiceman

Active Member
Joined
Mar 13, 2004
Messages
371
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.
 

Forum statistics

Threads
1,136,307
Messages
5,674,986
Members
419,541
Latest member
freddyboots

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top