How to start the sheet with null/0 values

[abhi1693r]

Hi,

I have all filter and text boxes with formulas. but whenever I open the sheet it has previous session's values. How do I get rid of them? Want to start with 0.00

Abhishek

[ramasaisaksoft · Accepted solution]

Hi Abhi,

Try to create a Trigger action -->when activate sheet like below ,so that you will get "Clear All Selections" when you open the sheet.

[shiveshsingh]

Add a trigger on Activate Sheet to clear the values.