Setting default value or clearing cells without VBA/macros

[welderi]

Hello!

I have been fighting and trying to find a way to set multiple cells to 0 value without VBA/macros but no luck yet. Reason why it needs to be done without VBA/macros is because worksheet will be used with mobile or tablet so excel version on those don't support for VBA . Worksheet has lots of cells with data validated drop boxes and normal cells which has to reset after every use so it would be nice to have fast way to reset them. If someone knows how to that with checkbox or any other easy and fast way i would appreciate that a lot!

 

[jondavis1987]

Can you do button controls from the mobile versions?

 

[welderi]

Can you do button controls from the mobile versions?

Nope. I checked that mobile version don't even support simple True/False check boxes.

I think i have to start looking towards google sheets because it's crucial for mobile version to have fast way to clear all needed cells for smooth usage if i don't find a way to work around this.