Microsoft Office Tutorials and References
In Depth Information
Inserting a Row or Column into a Worksheet
Select a cell where you want to insert the new row or column.
Click Insert on the menu bar, and then click Rows or Columns.
Right-click a cell where you want to insert a new row or column, and then click Insert on
the shortcut menu.
In the Insert dialog box, click the Entire row or Entire column option button, and then
click the OK button.
To insert multiple rows or columns, you select a cell range that contains multiple rows
or columns before applying the Insert command. For example, to insert two new blank
rows, select two rows or any portion of two rows. To insert three blank columns, select
three columns or any portion of three columns.
Sometimes you might need to insert individual cells, rather than an entire row or col-
umn, into a worksheet. To insert cells into a row or column, you must select the number of
cells you want to insert, and then open the Insert dialog box. In this dialog box you indi-
cate how Excel should shift the existing cells to accommodate the cells you want to insert.
Inserting Cells into a Worksheet
Select a cell range equal to the number of cells you want to insert.
Click Insert on the menu bar, and then click Cells; or right-click the selected range, and
then click Insert on the shortcut menu.
Click the Shift cells right option button to insert the new cells into the row, or click the
Shift cells down button to insert the new cells into the column.
Sandra wants the data for the new order to be entered above the TOTAL row, row 10.
You’ll use the right-click method to insert a new row 10, and then you’ll enter the data.
To insert a new row 10:
1. Right-click cell A10 , which is where you want to insert the new row.
2. Click Insert on the shortcut menu. The Insert dialog box opens. See Figure 1-28.
Insert dialog box
3. Click the Entire row option button, and then click the OK button. Excel inserts a new row 10
and shifts the calculations of the total values down one row.
4. Enter the data for Karen Paulson’s order into row 10, as shown in Figure 1-29. Make sure
that you press the Tab key to move from cell to cell and press the Alt + Enter keys to enter
the address on two lines within cell B10.