Excel 2007

Hi Penny

How are you today hope you enjoyed the course and it was nice to meet you

In relation to your question of inserting rows, and formulas staying the same, the answer is yes, but doing this the right way works, and doing it wrong does not

The right way is to insert rows within the range of the formula e.g. if the formula is =sum(d4:d25) then insert your new rows between row 4 and row 25 if you do things this way then all should be grand

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please click reply or post it as a new question and we should be able to answer that!!

Many Thanks

Mark East
mark@stl-training.co.uk