EXCEL: Add, Delete Rows

In Excel, a quick way to add or delete rows is to Right click the gray column to the far left of your worksheet that shows the numbered rows and choose "Add" or "Delete".  In most cases, adding or deleting rows this way will not affect any calculations that are used within those rows. 

For instance, if I have a calculation in Cell D11 that sums cells D1 through D10, and I delete rows 2 and 3 using the instructions above, that "sum" calculation will now just add cell D1 through D8 and will not be adversely affected by deleting those 2 rows.