macOS Shortcuts and button-like automation in Numbers?

I'm retired after being a programmer with PC operating systems for 40 years though I've always used Macs (at least since 1998) at home. I'm working as kind of a freelancer and I've been asked to help automate a Numbers spreadsheet for an organization. They USED to use MS Office but due to budget reasons they can no longer afford MS Office because of COVID and are trying to replicate some things in Apple Numbers.


I KNOW, I KNOW, I KNOW that you can create programable buttons in Apple Numbers. But can you create something "close enough" using MacOS Shortcuts?


They want a menu where they can have different buttons like a menu where someone clicks on a button and it adds 1 to a total. Can you do that with MacOS shortcuts and Apple Numbers?


I WISH that Apple had more respect for their "office suite" but they don't and Libré Office is just too foreign for me right now. I KNOW that people disagree with that statement but I'm tasked with using what they are using NOW and NOT what someone might want them to be using. So ... can this be done? From what I can tell, you can automate just about anything EXCEPT for Numbers. Is that right?

iMac 27″

Posted on Feb 14, 2026 1:54 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 16, 2026 11:38 AM

> The problem is that I don't see "Numbers" in the programs you can make shortcuts for. Unless I'm just being blind.


It's there, but you have to scroll down the Apps list a bit to find it.

There also aren't many direct commands that you can Shortcut, and none that match your ask of incrementing a cell value.



However, you might be able to get there via Run AppleScript action:


on run {input, parameters}
	tell application "Numbers"
		tell table 1 of active sheet of document 1
			set the_selection to get selection range
			if the_selection is missing value then return
			set target_cell to cell 1 of the_selection
			try
				set current_cell_value to value of target_cell as number
				set value of target_cell to (current_cell_value + 1)
			end try
		end tell
	end tell
	return input
end run


This quick and dirty script will increment the currently selected cell in the first table of the current sheet. It has minimal error checking (e.g. there has to be a cell selected, and it only increments number values), and it should be more robust for production use (especially if other people are using it in ways you don't expect), but it might get you started.

Similar questions

7 replies
Question marked as Top-ranking reply

Feb 16, 2026 11:38 AM in response to OlsonBW

> The problem is that I don't see "Numbers" in the programs you can make shortcuts for. Unless I'm just being blind.


It's there, but you have to scroll down the Apps list a bit to find it.

There also aren't many direct commands that you can Shortcut, and none that match your ask of incrementing a cell value.



However, you might be able to get there via Run AppleScript action:


on run {input, parameters}
	tell application "Numbers"
		tell table 1 of active sheet of document 1
			set the_selection to get selection range
			if the_selection is missing value then return
			set target_cell to cell 1 of the_selection
			try
				set current_cell_value to value of target_cell as number
				set value of target_cell to (current_cell_value + 1)
			end try
		end tell
	end tell
	return input
end run


This quick and dirty script will increment the currently selected cell in the first table of the current sheet. It has minimal error checking (e.g. there has to be a cell selected, and it only increments number values), and it should be more robust for production use (especially if other people are using it in ways you don't expect), but it might get you started.

Feb 17, 2026 10:57 AM in response to OlsonBW

Pretty sure those options match what was in my screenshot, albeit in a slightly different presentation. If you look to the app icon for the 5 options in the middle, you'll see these relate to Numbers.app, specifically, as opposed to the keyword 'numbers' somewhere in the action title.


Ultimately, while there is "support" for Numbers' actions in Automator/Shortcut, it's pretty lightweight. There is no facility for deep integration, calculation, etc. You cannot ask Automator to get or set the value of a specific cell, or perform conditional actions based on data in the spreadsheet, at least not without resorting to Run AppleScript, as noted in my earlier post.

Feb 14, 2026 5:01 PM in response to OlsonBW

If each of these actions can be scripted using AppleScript then I believe it can be done using the Scortcuts app. Create a shortcut for each script. Have the Shortcuts app open so you can see and click on the "play" button of each shortcut. Not an ideal situation, though, unless you have a large/wide monitor to show both apps at once.


If you don't mind having to click something first before clicking on one of your actions, you can put a Shortcuts app icon on the main OS menu. When clicked on it will pop up a window that lists all your shortcuts then you can choose one. Since the release of MacOS 26, though, this is much less useful than it used to be because it won't show more than four shortcuts without scrolling and they are in alphabetical order. I quit using Shortcuts because of this and went back to plain old AppleScripts. You can put an icon for the Script Editor on the main menu and it will list all your user Applescripts (which is what the Shortcuts app used to do but no longer does).

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.

macOS Shortcuts and button-like automation in Numbers?

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