I know enough to be dangerous, thanks to lots of great help:
Have lots of spreadsheets with formulas that let users see lots of helpful data calculated to deliver eye-opening averages, predictions, etc.
So, they want to use my spreadsheets to enter their own data and see the results for their own systems...
So I send them to them and the first thing they do is delete the data, which deletes the formulas,
...and I KNOW I shoud KNOW how to do this but I don't - how can you clear cell values without clearing the formulas?
Thanks,
Synthia
Bookmarks