98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Adding rows
microsoft excel training - Adding rows
Resolved · Low Priority · Version Standard
Maria has attended:
Excel Intermediate course
Adding rows
How do you add rows and keep them included in formulas?
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.
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:Finding cells that have data restrictionsClick anywhere on the worksheet. |