Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
You insert columns into a worksheet in the same way you insert rows. To insert
columns, select one or more columns immediately to the right of where you want Excel
to insert the new column or columns. Select the number of columns you want to insert.
Next, click the Insert button arrow (Home tab | Cells group) and then click Insert Sheet
Columns in the Insert list or right-click the selected column(s), then click Insert on the
shortcut menu. The Insert command on the shortcut menu requires that you select an
entire column (or columns) to insert a column (or columns). Following the insertion
of a column, Excel displays the Insert Options button, which allows you to modify the
insertion in a fashion similar to that discussed earlier when inserting rows.
If you want to insert
multiple rows, you have
two choices. You can insert
a single row by using the
Insert command on the
shortcut menu and then
repeatedly press F4 to
continue inserting rows.
Alternatively, you can select
any number of existing
rows to choose the number
of rows that you want to
insert. For instance, if you
want to insert i ve rows,
select i ve existing rows in
the worksheet, right-click
the rows, and then click
Insert on the shortcut menu.
Inserting Single Cells or a Range of Cells
The Insert command on the shortcut menu or the Insert Cells command on the
Insert list of the Insert button (Home tab | Cells group) allows you to insert a single cell
or a range of cells. You should be aware that if you shift a single cell or a range of cells,
however, it no longer lines up with its associated cells. To ensure that the values in the
worksheet do not get out of order, spreadsheet experts recommend that you insert only
entire rows or entire columns. When you insert a single cell or a range of cells, Excel
displays the Insert Options button so that you can change the format of the inserted cell,
using options similar to those for inserting rows and columns.
You can move and insert
a selected cell or range
between existing cells by
holding down the SHIFT
key while you drag the
selection to the gridline
where you want to insert
the selected cell or range.
You also can copy and
insert by holding down
the CTRL + SHIFT keys while
you drag the selection to
the desired gridline.
Deleting Columns and Rows
The Delete button (Home tab | Cells group) or the Delete command on the
shortcut menu removes cells (including the data and format) from the worksheet. Deleting
cells is not the same as clearing cells. The Clear command, described in Chapter 1 on page
EX 52, clears the data from the cells, but the cells remain in the worksheet. The Delete
command removes the cells from the worksheet and shifts the remaining rows up (when
you delete rows) or shifts the remaining columns to the left (when you delete columns).
If formulas located in other cells reference cells in the deleted row or column, Excel does
not adjust these cell references. Excel displays the error message #REF! in those cells to
indicate a cell reference error. For example, if cell A7 contains the formula =A4+A5 and
you delete row 5, Excel assigns the formula =A4+#REF! to cell A6 (originally cell A7) and
displays the error message #REF! in cell A6. Excel also displays an Error Options button
when you select the cell containing the error message #REF!, which allows you to select
options to determine the nature of the problem.
Ranges and Undo
The incorrect use of
inserting, and moving
ranges of cells have
the potential to render
a worksheet useless.
Carefully review the
results of these actions
before continuing on to
the next task. If you are
not sure the result of the
action is correct, click the
Undo button on the Quick
To Enter Numbers with Format Symbols
The next step in creating the Six-Month Financial Projection worksheet is to enter the what-if assumptions
values in the range B2:B8. The numbers in the table can be entered and then formatted as in Chapters 1 and 2, or each
one can be entered with format symbols. When a number is entered with a format symbol , Excel immediately displays
it with the assigned format. Valid format symbols include the dollar sign ($), comma (,), and percent sign (%).
If you enter a whole number, it appears without any decimal places. If you enter a number with one or more
decimal places and a format symbol, Excel displays the number with two decimal places. Table 3 – 5 illustrates several
examples of numbers entered with format symbols. The number in parentheses in column 4 indicates the number of