Microsoft Office Tutorials and References
In Depth Information
Let’s Be Clear about Deleting Stuff
Let’s Be Clear about Deleting Stuff
No discussion about editing in Excel would be complete without a section on
getting rid of the stuff you put into cells. You can perform two kinds of
deletions in a worksheet:
Clearing a cell: Clearing just deletes or empties the cell’s contents
without removing the cell from the worksheet, which would alter the layout
of the surrounding cells.
Deleting a cell: Deleting gets rid of the whole kit and caboodle — cell
structure along with all its contents and formatting. When you delete a
cell, Excel has to shuffle the position of entries in the surrounding cells
to plug up any gaps made by the action.
Sounding the all clear!
To get rid of just the contents of a cell selection rather than delete the cells
and their contents, select the range of cells to clear and then simply press
the Delete key.
If you want to get rid of more than just the contents of a cell selection,
click the Clear button (the one with the eraser) in the Editing group on the
Ribbon’s Home tab and then click one of the following options on its
dropdown menu:
Clear All: Gets rid of all formatting and notes, as well as entries in the
cell selection (Alt+HEA).
Clear Formats: Deletes only the formatting from the cell selection
without touching anything else (Alt+HEF).
Clear Contents: Deletes only the entries in the cell selection just like
pressing the Delete key (Alt+HEC).
Clear Comments: Removes the notes in the cell selection but leaves
everything else behind (Alt+HEM).
Clear Hyperlinks: Removes the active hyperlinks (see Chapter 12) in the
cell selection but leaves its descriptive text (Alt+HEL).
Remove Hyperlinks: Removes the active hyperlinks in the cell selection
along with all the formatting (Alt+HER).
Search JabSto ::




Custom Search