Ten Minute Guide to Excel 97

Inserting Rows and Columns

Inserting entire rows and columns in your worksheet is easy. Here's what you do:

1. To insert a single row or column, select the cell to the left of which you want to insert a column, or above which you want to insert a row.

   To insert multiple columns or rows, select the number of columns or rows you want to insert. To insert columns, drag over the column letters at the top of the worksheet. To insert rows, drag over the row numbers. For example, select three column letters or row numbers to insert three rows or columns.

2. Open the Insert menu.

3. Select Rows or Columns. Excel inserts the row(s) or column(s) and shifts the adjacent rows down or the adjacent columns right. The inserted rows or columns contain the same formatting ...