Hi,

Could anyone help how to remove
the formatting of the entire worksheet?

I try to use ClearContents it only clear the
data, not the formatting.

Thanks you very much.

Regards,
Lian

Are the cells lock/protected ?

Click in the spreadsheet row column area.

Right click

Select "Format Cells"

Click last page tab that says "protection"

is the chdeck box for LOCKED checked ?

If so select the whole spread sheet and redo what is above and uncheck the check for locked and you should be done.,