Clearing a Range

Applying the clear command to a cell will restore the cell to its pristine condition, devoid of styling or format.

clear  : Clear the contents of a specified range of cells, including formatting and style.

clear range

While useful in specific situations, the clear command is not the same as resetting a cell to a default value. Use the following example script to reset all of the currently selected cells to their default values, while retaining their individual styling and format parameters:

TOP | CONTINUE