O'Reilly logo

Master VISUALLY® Excel® 2010 by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. 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 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 is the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required