Excel 2007

Resolved · Low Priority · Version Standard

Excel 2007

Penny has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Penny [2 posts] (2008 Mar 10 Mon, 16:48) Reply

Can I insert rows and my formula stay the same?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	3	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	0	FULL
2003	2008 Dec 17 Wed	Bayswater	0	FULL
Full Schedule: See all 94 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel 2007

by - trainer Mark gold contributer [287 posts] (2008 Mar 14 Fri, 09:54) Reply

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