vert line

Use Edit->Clear Special to clear various aspects of a cell or range of cells.

Format clears all formatting options from the cell or cell range that you selected, returning it to Base Style 1.

Data clears all data from the cell or cell range that you selected, leaving only the formatting options.

Numeric Input clears all cells containing numeric data in the selected cell range.

  • This is useful for worksheets that are used repeatedly, and must be cleared of all prior numeric content before each use. Formatting options, formulas, and string are not affected by this command.

String Input clears only cells containing string data in the selected cell range.

  • This is useful for reusing a worksheet that needs to have only its captions updated. Formatting options, formulas, and number are not affected by this command.

Reset clears the values of cells containing formulas. This is useful when working with cells containing CURRENTVALUE and CURRENTNUMBER constants.

See also

 

Also go to:

Index help

Contents help