7.2.5.Insert Multiple Columns or Rows |
|
Drag to select the column header buttons for a list of columns.
|
|
![Drag to select the column header buttons for the number of columns.](../../Microsoft-Office-Excel-2007Images/Insert_Multiple_Columns_Or_Rows___Drag_To_Select_Column_Header_Button.PNG) |
To insert multiple rows,
drag to select the row header buttons for the number of rows.
|
|
![To insert multiple rows, drag to select the row header buttons for the number of rows.](../../Microsoft-Office-Excel-2007Images/Insert_Multiple_Columns_Or_Rows___To_Insert_Multiple_Rows_Drag_To_Sel.PNG) |
Click the Home tab.
Click the Insert Cells button.
Then click Insert Sheet Columns or Insert Sheet Rows.
|
|
![Click the Home tab. Click the Insert Cells button. Then click Insert Sheet Columns or Insert Sheet Rows.](../../Microsoft-Office-Excel-2007Images/Insert_Multiple_Columns_Or_Rows___Click_Home_Tab_Click_Insert_Cells_B.PNG) |
To adjust formatting,
click the Insert Options button,
and then click a formatting option.
|
|
![To adjust formatting, click the Insert Options button, and then click a formatting option.](../../Microsoft-Office-Excel-2007Images/Insert_Multiple_Columns_Or_Rows___To_Adjust_Formatting_Click_Insert_O.PNG) |