Thread: How do i add new rows to worksheet & all the forumlas follow suit

Hi

When I add new rows to my worksheet i then have to then copy & paste or drag down all the formulas as well , is there a quicker way ? so the formulas are dragged down as well

cheers
az

Copy the cells u have the formula in and then click on insert... you will get an option to insert a new row with the formula already pasted