Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Adding rows
|
|
|
The UK's most regular 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. |
microsoft excel training - Adding rows
Resolved · Low Priority · Version Standard
Reply Fri 27 Jul 2007, 09:49Delegate Maria said...
Maria has attended:
Excel Intermediate course
Adding rows
How do you add rows and keep them included in formulas?
For upcoming training course dates see: Pricing & availability
RE: Adding rows
Hi Maria, Thanks for the post, to add rows to a range of cells and have them included in the formula, you need to select the row or rows immediately below the point at which you wish to insert (Excel will insert as many rows as you select). Right click on the selected area and choose Insert, You will be prompted to choose Shift Rows Down, Left etc choose Down and click OK. Row/s will be inserted that will accept new data and should also have the formulas included, if the formula is not included you might have to copy it down the appropriate column.
|
|