Clearing Cell contents in Numbers but not deleting formulas?
How do you delete cell contents in Numbers but not delete the formulas?
How do you delete cell contents in Numbers but not delete the formulas?
You can use this 'Clear Data Keep Formulas' Shortcut that contains AppleScript I wrote a few years ago.
https://www.icloud.com/shortcuts/f1d9a0bef9a1403bb68688fc9c3e5ba1
To set up the Shortcut just click the link above and it should display in the built-in Shortcuts app. You can install it and add it to the menu bar, or attach a keyboard shortcut to it, etc.
To use it you just select the cells with contents and run the Shortcut from the Menu Bar or Services menu or wherever you have put it. You can also just run it from within the Shortcuts app.
You can make full use of the Shortcut without worrying about the code under the hood. But if you are curious it looks like this:
General information on Shortcuts can be found here:
Shortcuts User Guide for Mac - Apple Support
SG
Please have a look at this post, it should help with your task
Want to set up spread sheet for 2023 usin… - Apple Community
Ralf
Clearing Cell contents in Numbers but not deleting formulas?