In numbers I want to delete cell content but not formula

How do I delete the cell content without deleting formula


iMac, OS X 10.11

Posted on Dec 29, 2022 5:55 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 29, 2022 7:35 AM

You can use this 'Clear Data Keep Formulas' Shortcut that contains an 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


2 replies
Question marked as Top-ranking reply

Dec 29, 2022 7:35 AM in response to StuartMacpherson

You can use this 'Clear Data Keep Formulas' Shortcut that contains an 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.

In numbers I want to delete cell content but not formula

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