Chapter 10. Working with Worksheets

Insert a Row or Column

When you want to insert additional data into your worksheet, you can add a row or column to the worksheet.

When you insert a row, the selected row and the rows that follow shift downward. When you insert a column, the selected column and the columns that follow shift to the right. Excel automatically adjusts the row numbers and column letters in your worksheet for you.

The row that you insert is the same height as the row above it. The column that you insert is the same width as the column to its left.

When you insert a row or column, Excel automatically updates any formulas or cell references that are affected by the insertion. For information on formulas, see Chapter 11.

After Excel inserts ...

Get Master Visually®: Microsoft® Office 2007 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.