Master Visually®: Excel® 2007

Chapter 6. Adjusting Worksheets

Insert and Delete Rows

You can add and delete rows in your worksheet to add or delete information. For example, you may have typed product names in the rows of a worksheet that shows product sales over a period of time, but you did not include the region in which those products were sold. Now you find that you need to add region designations as row titles to segregate sales by region as well as by product. Or, you may need to delete a row because you do not need the information that it contains.

When you add a row, Excel shifts the rows below the new row down and automatically adjusts the row numbers to accommodate the new row. Excel also automatically updates formulas affected by the row you insert. The new row ...