Clearing Cell contents in Numbers but not deleting formulas?

How do you delete cell contents in Numbers but not delete the formulas?

Posted on Dec 16, 2022 11:56 AM

Reply
2 replies

Dec 17, 2022 06:30 AM in response to Ralf-F

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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Clearing Cell contents in Numbers but not deleting formulas?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.