98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007
Excel 2007
Resolved · Low Priority · Version Standard
Mon 10 Mar 2008, 16:48Delegate Penny said...
Penny has attended:
Excel Introduction course
Excel Intermediate course
Excel 2007
Can I insert rows and my formula stay the same?
Fri 14 Mar 2008, 09:54Trainer Mark said...
RE: 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:The Easiest Way to See a Sum or Average in Excel 2010Did you know the quickest and most simple way of working out the average or sum of a set of numbers? |
