How can I delete cell values in Excel

I have identical sheets, where I wan to delete the cell values, so that the report is clean and ready for the next month (see below).

Imagine row 5 and 6 were filled out and I want to delete them when I create the next monthly report.


We can simply use the write cell activity when you are filling for new month report
It will overwrite the value on it

It won’t require to delete if you are refilling the same cell with Write cell activity

Or if you are not writing again in same cell then try deleting with this custom component

Cheers @maria.mitova

1 Like

Try with Delete Range


I am using StudioX


Can you try Fill Range activity as the following?

Please set "" at What to write property using Advanced Editor.