Microsoft Office Tutorials and References
In Depth Information
EX 66
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
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 fi rst four methods listed below. The fi fth method clears the
formatting from the selected cells.
Quick Reference
For a table that lists how
to complete the tasks
covered in this topic
using the mouse, Ribbon,
shortcut menu, and
keyboard, see the Quick
Reference Summary at
the back of this topic, or
visit the Excel 2007 Quick
Reference Web page
(scsite.com/ex2007/qr).
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 fi ll handle so the mouse pointer
changes to a cross hair.
2. Drag the fi 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.
Certifi cation
The Microsoft Certifi ed
Application Specialist
(MCAS) program provides
an opportunity for you
to obtain a valuable
industry credential
– proof that you have the
Excel 2007 skills required
by employers. For
more information, see
Appendix F or visit the
Excel 2007 Certifi cation
Web page (scsite.com/
ex2007/cert).
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 on the Home tab (Figure 1–95 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 on the Home tab and point to Normal.
3. Click Normal in the Live Preview Gallery.
The Clear button on the Home tab 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.
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 on the Home tab
on the Ribbon and then
click Normal. 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 (‘).
Clearing the Entire Worksheet
If 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, use the
following steps.
T O C LEAR THE E NTIRE W ORKSHEET
1. Click the Select All button on the worksheet (Figure 1–95).
2. Click the Clear button on the Home tab to delete both the entries and formats.
Search JabSto ::




Custom Search