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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
