Section 6 - Inserting a Row or a Column
Inserting a Row:
Excel will insert a new row in the row you have selected
and move the rest of the spreadsheet down without deleting
any data.
- To insert a row, select the row by clicking the Row
Heading where the row number appears.
- In Excel XP, click on the Insert menu and choose rows.
- In Excel 2007, under the Home tab, click on Insert in the Cells group.
- A new row will appear in the place of the selected row.
All other rows will move down.
Excel XP
Excel 2007
Inserting a Column:
Excel will insert a new column in front of the column you have selected and move the rest of the spreadsheet to the right without deleting any data.
- To insert a new column, select the column where you want the new column to appear by clicking on the Column Heading.
- In Excel XP, click on the Insert menu and choose Column.
- In Excel 2007, under the Home tab, click on Insert in the Cells group.
Excel 2007
- The new column will appear to the left of the selected column. The remaining columns will move over to the right.
Excel XP
Excel 2007
|
