microsoft excel training - 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.