Microsoft Office Tutorials and References
In Depth Information
Correcting Errors
Clearing a Cell or Range of Cells
If you enter data into the wrong cell or range of cells, you can erase, or clear,
the data using one of the i rst four methods listed below. The i fth method clears the
formatting from the selected cells.
T O C LEAR C ELL E NTRIES U SING THE F ILL H ANDLE
1. Select the cell or range of cells and then point to the i ll handle so the mouse pointer
changes to a crosshair.
2. Drag the i ll handle back into the selected cell or range until a shadow covers the cell
or cells you want to erase. Release the mouse button.
T O C LEAR C ELL E NTRIES U SING THE S HORTCUT M ENU
1. Select the cell or range of cells to be cleared.
2. Right-click the selection.
3. Click Clear Contents on the shortcut menu.
T O C LEAR C ELL E NTRIES U SING THE DELETE K EY
1. Select the cell or range of cells to be cleared.
2. Press the delete key.
T O C LEAR C ELL E NTRIES AND F ORMATTING U SING THE C LEAR B UTTON
1. Select the cell or range of cells to be cleared.
2. Click the Clear button (Home tab | Editing group) (Figure 1– 75 on the previous page).
3. Click Clear Contents on the menu.
T O C LEAR F ORMATTING U SING THE C ELL S TYLES B UTTON
1. Select the cell or range of cells from which you want to remove the formatting.
2. Click the Cell Styles button (Home tab | Styles group) and point to Normal.
3. Click Normal in the Cell Styles Gallery.
Getting Back to Normal
If you accidentally assign
unwanted formats to a
range of cells, you can
use the Normal cell style
selection in the Cell Styles
gallery. Click Cell Styles
(Home tab | Styles group)
and then click Normal
in the Cell Styles gallery.
Doing so changes the
format to Normal style. To
view the characteristics of
the Normal style, right-
click the style in the Cell
Styles gallery and then
click Modify or press
ALT + APOSTROPHE (‘).
The Clear button (Home tab | Editing group) is the only command that clears both
the cell entry and the cell formatting. As you are clearing cell entries, always remember
that you should never press the spacebar to clear a cell . Pressing the spacebar enters a
blank character. A blank character is text and is different from an empty cell, even though
the cell may appear empty.
Clearing the Entire Worksheet
If the required worksheet edits are extremely extensive, you may want to clear the
entire worksheet and start over. To clear the worksheet or delete an embedded chart, you
would use the following steps.
Certii cation
The Microsoft Ofi ce
Specialist (MOS)
program provides an
opportunity for you
to obtain a valuable
industry credential —
proof that you have the
Excel 2010 skills required
by employers. For more
information, visit the
Excel 2010 Certii cation
Web page (scsite.com/
ex2010/cert).
T O C LEAR THE E NTIRE W ORKSHEET
1. Click the Select All button on the worksheet (Figure 1– 75).
2. Click the Clear button (Home tab | Editing group) and then click Clear All on the
Clear menu to delete both the entries and formats.
The Select All button selects the entire worksheet. Instead of clicking the Select All
button, you can press ctrl+a. To clear an unsaved workbook, click the workbook’s Close
Window button or click the Close button in the Backstage view. Click the No button
if the Microsoft Excel dialog box asks if you want to save changes. To start a new, blank
workbook, click the New button in the Backstage view.
 
Search JabSto ::




Custom Search