vert line

Clear Special allows you to clear only certain aspects of the selected cells.

You can clear:

just the formats (e.g. font, color, borders)

just the data (leaving the formatting intact)

Numbers only (leaving all text intact)

Strings only (leaving all numbers intact)

 

Also go to:

Index help

Contents help