Deleting Data
To delete the data and cell characteristics from a cell or block of cells
To delete only the data in a cell or block of cells
Overview
You can delete both data and cell characteristics from a selected cell or block of cells, or delete only the data, leaving the cell characteristics, such as cell type, intact. For more information about cell characteristics, see Formatted and Unformatted Data and Sheet Element Selection.
Other actions you perform can delete sheet data and cell, column, row, and sheet characteristics. For more information, see Resetting a Sheet to its Default Settings and Deleting Columns and Rows.