Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Deleting Columns and Rows
The Delete button on the Ribbon 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, which was described earlier in Chapter 1
on page EX 66, 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. It 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
inserting, and moving
ranges of cells have
the potential to render
a worksheet useless.
Carefully review these
actions before continuing
on to the next task. If you
are not sure the action
is correct, click the Undo
button on the Quick
Deleting Individual Cells or a Range of Cells
Although Excel allows you to delete an individual cell or range of cells, you should
be aware that if you shift a cell or range of cells on the worksheet, it no longer may be
lined up with its associated cells. For this reason, it is recommended that you delete only
entire rows or entire columns.
Entering Numbers with Format Symbols
The next step in creating the Semiannual Financial Projection worksheet is to enter the what-if
assumptions values in the range B19:B25. 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 decimal places.
Table 3–5 Numbers Entered with Format Symbols
Typed in Formula Bar
Displays in Cell