Clear all unprotected cells
Protect all cells in a worksheet that contain formulas, leaving cells that contain data unprotected. Then, while the worksheet is protected, have a function that, when selected, will clear all the unprotected cells of their data.
DIVYA VIJOY commented
hi I am troubling to edit the excel sheets ,it's showing the files are protected ,how can I unprotect the files or how can I retrieve the password of my excel
How do retrieve my password to unlock workbook