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 rst four methods listed below. The fth method clears the
formatting from the selected cells. To clear a cell or range of cells, you would perform
the following steps:
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 fill handle so that the
pointer changes to a crosshair.
2. Drag the fill handle back into the selected cell or range until a shadow covers
the cell or cells you want to erase.
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. Press and hold or right-click the selection.
3. Tap or click Clear Contents on the shortcut menu.
T O C LEAR C ELL E NTRIES U SING THE D ELETE K EY
1. Select the cell or range of cells to be cleared.
2. Press the 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. Tap or click the Clear button (HOME tab | Editing group).
3. Tap or 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. Tap or click the Cell Styles button (HOME tab | Styles group) and point to
Normal.
3. Tap or click Normal in the Cell Styles gallery.
The Clear All command on the Clear menu 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
enters a blank character. A blank character is text and is different from an
empty cell, even though the cell may appear empty.
BTW
Certication
The Microsoft office
Specialist (MOS) program
provides an opportunity for
you to obtain a valuable
industry credential —
proof that you have the
Excel 2013 skills required
by employers. For more
information, visit the
Certication resource on
the Student Companion
Site located on
www.cengagebrain.com.
For detailed instructions about
accessing available resources,
visit www.cengage.com/
ct/studentdownload or
contact your instructor for
information about accessing
the required les.
Clearing the Entire Worksheet
If the required worksheet edits are extremely extensive or if the requirements
drastically change, 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.
T O C LEAR THE E NTIRE W ORKSHEET
1. Tap or click the Select All button on the worksheet.
2. Tap or click the Clear button (HOME tab | Editing group) and then tap or
click Clear All on the menu to delete both the entries and formats.
Search JabSto ::




Custom Search