Selectively Clear Formats

The Selectively Clear Formats tool is a quick way to clear the format options in a range without clearing all the formatting.

Range: Select the range to fill. (This field is preset with the selected range when the form is opened.)
Borders: If checked, all borders will be removed.
Fill color: If checked, cell fill colors will be reverted to "No fill".
Font styles: If checked, the font is reset to the Excel default font and font size. Other styles, such as bold, underline, strike-through, and italic, will also be reset.
Number and date formats: If checked, resets the number format to "General". Warning: Any dates will be displayed as a number.
Text alignment: If checked, text alignment is reverted to its default (left aligned for text and right aligned for numbers).