• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 9. Using Excel 2002 > Clearing Data

Clearing Data

Because of the nature of worksheets, erasing worksheet data differs from erasing word-processed data. Other information on the worksheet can heavily depend on the erased data, as you saw in the previous hour's lesson. When you want to erase a cell's or selection's contents, first decide which of the following kinds of erasure you want to perform:

  • Erase the selection and send the contents to the Clipboard (as you learned in the previous section).

  • Clear only a portion of the selection, such as its formatting, comment, or contents.

  • Completely erase the selection and all formatting and notes attached to the selection.

  • Erase the selected cells and their position so that other cells in the row move left or cells below move up.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint