Insert Multiple Columns or Rows : Column Row « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






Drag to select the column header buttons for a list of columns.
Drag to select the column header buttons for the number of columns.
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.
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.
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.








7.2.Column Row
7.2.1.Select a Column or RowSelect a Column or Row
7.2.2.Hide a Column or RowHide a Column or Row
7.2.3.Unhide a Column or RowUnhide a Column or Row
7.2.4.Insert a Column or RowInsert a Column or Row
7.2.5.Insert Multiple Columns or RowsInsert Multiple Columns or Rows
7.2.6.Delete a Column or RowDelete a Column or Row
7.2.7.Delete Multiple Columns or RowsDelete Multiple Columns or Rows
7.2.8.Adjust Column Width or Row HeightAdjust Column Width or Row Height
7.2.9.Change the default column widthChange the default column width
7.2.10.Adjust Column Width or Row Height Using the MouseAdjust Column Width or Row Height Using the Mouse
7.2.11.Change Column Width or Row Height Using AutoFitChange Column Width or Row Height Using AutoFit