Numbers: Find & Replace changes sheet names globally

Question

Level 2

415 points

Numbers: Find & Replace changes sheet names globally

I have a table with 3,712 cells with Sheet 1::Table 1::$D$6 through Sheet 1::Table 1::$IZ$121 which is part of a table which goes from ... well it doesn't matter how many total cells are in that table. The problem is that I need to change it from "Sheet 1" to "Rank2" and if I try to Find & Replace it doesn't just change the cells that I could highlight, but no matter what I've done it changes every cell in the whole file.

I've tried to copy the cells to another file but the connections to the cells that they point to are lost. And I don't want to change 3,712 cells one by one or two by two or ... well you get the idea.

So since I can't use "Find & Replace", how do I change only the cells that I want to change and none of the other cells in all the other sheets (about 30 sheets each with a minimum of 15 tables) so therein lies my dilemma.

I have no idea why Apple doesn't let you have the option to change only the things that are highlighted in Numbers. They do in Pages and other programs and it makes just as much sense for the need in Numbers as in any other program. And it isn't like I haven't been asking for years and multiple versions of Numbers but apparently I'm only a part of a too small number of people that want this feature. Or it just lies on deaf ears.

I'm also apparently too small of a crowd for Apple to find it profitable or worth the effort to make a 27" (hint, hint, hint or LARGER) iMac. Apple is pushing me away from them. I'm not the customer they care about anymore even though I helped in a tiny, tiny, tiny way of keeping them from going bankrupt by buying an iMac in 1998. Sigh!

Thanks for your time and your help.

iMac 27″

Posted on Mar 7, 2026 10:32 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,930 points

Mar 8, 2026 12:39 AM in response to OlsonBW

OlsonBW wrote:

Apple doesn't let you have the option to change only the things that are highlighted in Numbers.

Numbers doesn't let you do that natively, but you can perform a find-replace in selected cells by using a script in shortcut that you can trigger by making a pick from your menu.

To Find-Replace in values:

https://www.icloud.com/shortcuts/79ba7b10d82d404c9e29f8d47292c19d

To Find-Replace in formulas:

https://www.icloud.com/shortcuts/6e5fc396b14e4843945c3df560b59cd7

Click the link in Safari, inspect, and install if you like these.

To use, select the range of cells in Numbers and then run the shortcut by going in the menu to Numbers > Services > Find Replace in Selection or Find Replace in Formulas.

SG

Reply

Answer 2

Camelot

Level 9

60,873 points

Mar 7, 2026 12:27 PM in response to OlsonBW

Despite the display format of "Sheet Name::Table Name::A1", that's there purely for human benefit. Internally it's stored as a direct pointer to the cell, and Numbers just adds the 'Sheet Name' and 'Table Name' components when it shows the cell reference to you.

> I've tried to copy the cells to another file but the connections to the cells that they point to are lost

Numbers does not support linking to cells across files - every cell reference has to exist in the same document (can be on a different sheet, but it cannot be in another document),

As you've found, there's no trivial way to update a mass of cell references to point to a different table.

If your goal is to do this often, then you might want to reorganize your data to use INDIRECT() lookups rather than hard references. These let you build references 'on the fly' by doing things like having a cell on the sheet indicate which sheet name and table name you want, then the references update to reflect those choices. For example:

Here, the 'References' table holds a couple of strings representing a Sheet Name and a Table Name.

Then, cel B2 in Table 1 uses INDIRECT() to construct a reference to another cell based on the contents of the Reference cells. Changing the 'Sheet Name' or 'Table Name' in the References table will update cell B2 to point to the respective target cell.

It might be a huge uplift, though, to change a mass of cells to use this kind of format.

If it's an intermittent thing, then you could use an AppleScript to update the cell formulas to point to the new table. Here's an example I threw together - paste it into a new Script Editor document and click Run to try it (on a copy of your spreadsheet! just in case :) )

You can set the 'FROM' and 'TO' sheet names at the top of the script, the script then iterates through each cell in the named table on the current sheet looking for references to the source sheet. If found, it updates the cell to point to the destination sheet.

use AppleScript version "2.4" -- Yosemite (10.10) or later
use scripting additions

set changeFROMSheet to "Sheet 1"
set changeTOSheet to "Sheet 3"

tell application "Numbers Creator Studio"
	try
		tell document 1
			-- simple error checking to catch the obvious errors
			if not (exists sheet changeFROMSheet) then error "Source sheet not found"
			if not (exists sheet changeTOSheet) then error "Destination sheet not found"
			if changeFROMSheet = changeTOSheet then error "Source and Destination sheets cannot be the same"
			
			-- target the active sheet
			tell active sheet
				-- change this line to match the name of the table on this sheet
				-- You can also use 'tell table 1' if there's only one table
				tell table "Table 1"
					-- iterate through the cells
					repeat with c in its cells
						-- get each cell's formula
						set f to get formula of c
						-- does it contain a reference to the FROM sheet?
						if f contains changeFROMSheet then
							-- strip the current sheet name from the formula
							set tableRef to characters (offset of ":" in f) through -1 of f as text
							-- and rebuild the formula using the TO sheet name
							set value of c to "=" & changeTOSheet & tableRef --'::'Table 1'::A2"
						end if
					end repeat
				end tell
			end tell
		end tell
	on error errMsg
		display dialog errMsg buttons {"Ooops!"} default button 1
	end try
end tell

Note, the script is dumb -it doesn't differentiate between a cell reference that points to 'Sheet 1', and a cell that has the text string 'Sheet 1' in it. If this is a problem, the script can be made more tolerant... it's just a matter of providing the boundaries. Same thing with which cells it updates - right now it sweeps the entire table, but could be changed to sweep a subset, or the selected cells, or anything else... just need to be specific.

Reply

Answer 3

OlsonBW Author

Level 2

415 points

Mar 7, 2026 12:49 PM in response to OlsonBW

Now for some reason I can't do Find & Replace. The window opens and it lets me type "Sheet 1" and then "Working2" which is the new sheet it needs to point to, but won't let me replace anything either one by one or all of them. For some reason all those buttons are greyed out and I have no idea why but I can see that it still has 3,711 left to go after I did fix ONE cell.

Reply

Answer 4

OlsonBW Author

Level 2

415 points

Mar 9, 2026 10:00 AM in response to OlsonBW

This website is asking me to say what is on my mind. That is a VERY dangerous thing to ask and I won't go into what I'm thinking. Mostly it's about the limitations of my memory now compared to what it was back in the 1990s when I was in my 30s and at my peak. I've come a long ways down off the top of my memory's mountain. Sometimes it is seriously depressing how far I've come down. But we struggle to do our best every day and today is another day.

Reply

Answer 5

OlsonBW Author

Level 2

415 points

Mar 9, 2026 10:07 AM in response to OlsonBW

It might be a huge uplift, though, to change a mass of cells to use this kind of format.

If it's an intermittent thing,

I WISH it was an intermittent thing but I'm not the only one that is using these spreadsheets. I'm at the mercy of both experienced and very inexperienced people that are also using it and unfortunately there isn't granular security in Numbers where I can either give or take away rights to sheets, to tables or to cells or charts. If I could my job would be a LOT easier and by job I mean volunteering to help them keep their busy insanity down to something manageable. At least in the small part that I play in the organization that I volunteer my time for.

By that I mean I have no control over whether or not people change the names of sheets or tables or really anything because there are no granular rights inside of Numbers.

You are probably thinking this SHOULD be in a database and yes and no. If it was just the data then ABSOLUTELY but the problem is that the charts included in the file go a long ways to helping the volunteers AND the people they help.

Reply

Answer 6

OlsonBW Author

Level 2

415 points

Mar 9, 2026 10:16 AM in response to SGIII

Thank you SGIII. I will try that out too. I LOVE all the different ways that people can think of to do the same things. That's probably the second most thing I love about computers.

The first one being that I can write (about 10,000 words a day in stories) and be able to go back and redo/replace anything that I've written which you can't do when writing on paper (or any other surface) or when using a typewriter. I'm 66 years old so I started with chisels and stone ... I mean pen and paper back BEFORE I was a teenager when I was really lonely and I would create stories to pass the time and often the characters that I created became my best friends which has continued throughout my life. After all, isn't the "people" you spend the most time with usually your best friends?

And for anyone that sees this, Scrivener (I have no financial interest in ANY way with the company nor do I know anyone that works there or even anyone's name) is THE BEST writing tool I've ever come across and I've used literally over two hundred didn't programs to write in.

Reply

Answer 7

OlsonBW Author

Level 2

415 points

Mar 9, 2026 10:49 AM in response to OlsonBW

My wife is already frustrated by the number of things that I pay for monthly and while Creator Studio would be a very good tool if I used it all the time for multiple Apple products, I'm not going to start financial fights that I don't want to and NEED to finish. And so far this is the only reason why I would be paying a monthly charge for Creator Studio so I going to pass on anything that uses it.

I've got plenty of notes in the Numbers files (more than a few) that I help them with letting them know that they CANNOT change any of the table or sheet names and in the past when they did it wasn't that big of a deal so they didn't believe me.

However, I put my foot down this time and told them it wasn't my fault that someone else changed the cheese, I mean table or sheet name and they will have to go back to a version before they were changed and do whatever they need to get the updated data into the spreadsheet. I've also told this that THIS is the reason why all this data SHOULD be in a database where we can granularly limit what rights people have to everything. If they don't want to do that, fine, but it isn't my fault if people change things where there are notes in LARGE fonts with capitalized, bolded and italicized text telling them NOT to change sheet names or table names or any kind of scripting without checking with someone that is an expert with these files to VERIFY that any changes they want to make will not adversely create very costly mistakes/changes.

And yes, they could pay me to use Creator Studio to cover my costs. But it is better for them to realize NOW that there are costs to letting people make changes unless they are approved ahead and time by experts with the files.

Reply

Answer 8

Camelot

Level 9

60,873 points

Mar 9, 2026 11:46 AM in response to OlsonBW

I'm completely confused by this post...

Your original post talked about find and replace to update cell references to point to a different sheet.

Now you're going on about having to pay for Creator Studio. Nothing in my earlier post requires a paid subscription to Numbers Creator Studio - granted, my script targets Numbers Creator Studio but that's only because I have Numbers 15.x installed on my machine. The script a) does not require paid Creator Studio license (it does not rely on or require the AI-focussed, 'Creator Studio' features), and b) will work just as well in ANY version of Numbers going back to Numbers '09 - it's just a generic script.

Reply

Answer 9

OlsonBW Author

Level 2

415 points

Mar 9, 2026 12:10 PM in response to OlsonBW

But Apple is pushing me away. They don't know it but they are. They stopped creating and selling 27" (or larger) iMacs which I've been been using since I bought my first Apple computer, a 1998 Bondi Blue iMac until I potentially bought my last Apple computer, a late 2019 27" iMac after which they stopped making and selling them because they have never made a 27" M series iMac and the OS design and the quality (bugginess) of the software has been getting worse and worse especially over the last five years and I am at my rope's end with Apple.

Because of that I'm going back to my first and only love of an operating system which is OS/2. Yes, that OS from the 1980s and '90s which IBM stopped developing. However, they did start licensing it to Indelible Blue and now to Arca Noae to keep the drivers up to date so that you can install it and run it on new computers because there are MANY businesses who don't talk about it but they run mission critical software on OS/2 computers which MUST keep running 24 hours a day, seven days a week without all the many redundant and expensive Windows servers or Linux servers, both of which they use too but for less missional critical programs.

There are OS/2 servers that have been running since the eighties without having been rebooted or shut down because they are afraid they won't turn on anymore. And while there are backup servers just in case, and normally they would have upgraded the hardware but the things that OS/2 server is running is a heavy work load for that old computer. It is literally just to see how long that computer will keep doing its job before it finally fails. And since it is never shutdown and restarted or rebooted there is no cooling down and warming back up which, if you look at roads where the temperature is very even throughout the year and never gets too hot or too cold, well the road lasts a LOT longer than similar roads where it is either really hot, really cold, or goes between the extremes. And the same is true of that OS/2 computer.

But for me, it is the software that I LOVED which no longer is maintained or sold or not with the scripting language which made it so great (I'm talking specifically about WordPerfect which had its own scripting language until idiots abandoned it and went to VisualBasic for the scripting language which requires a MUCH higher level or programmer to create and maintain scripting for WordPerfect compared to its own scripting language. I'll leave it at that.

I'm not just going back to OS/2 but also to Lotus 1-2-3 and WordPerfect before VisualBasic and to R:Base and to all of the DOS and 16 bit Windows games that I loved and still love playing but haven't played for almost 30 years but just started playing and loving them again.

I would say at the most I have been infatuated with Mac OS X. Notice that I didn't say "MacOS" because that wouldn't be true. By the time Mac OS X became MacOS I lost my infatuation with the OS. The reason that I stick with Apple was because I was working but then I was able to retire in 2023 and I no longer had to be Excel compatible (I was a programmer but I also was a systems analyst supporting Mac, Linux and Windows) or Microsoft compatible at all. HHHHHHHHUUUUGGGGGEEEEEEE SSSSSMMMMMMIIIIIIILLLLLLLEEEEEE!!!!!!!!

Yes, I will keep my iMac for as long as it keeps running and use it along with my iPhone to keep in touch with people. I'll be setting up my email on OS/2 for that too and if it was possible I would create a Message app for OS/2 that is compatible with Messages but that actually is a good thing when I'm trying to get my own personal stuff done that I've wanted to do since the 1990s including making an adventure game with my own game mechanics with magic based off of radiation (which modifies DNA which caused groups of humans to become other types like giants, trolls, gnomes, etc., etc., etc., and imagine a fireball spell based on radiation with radiation poisoning being as much of the destruction as heat!

Anyway, I'm moving all my spreadsheets to Lotus 1-2-3 and the organizations that I've been helping understand that I will no longer be helping them when my Apple computer dies and to start looking for someone else to take over for me. They want to keep it very local and the only people they trust are those that have been named by a core group in the organization.

So I'm helping them as long as I can which depends on how long my iMac keeps running an my versions of Numbers stays compatible with theirs, another thing they realize could stop me from helping them. And no, I don't want another Apple computer until it is a 27" iMac (or larger). I've got my own life and this actually gives me an excuse to break away so I can work on my own stuff and there are only 24 hours in a day and I don't have time enough for my own programming let alone anything for them.

In the meantime, without taking on yet another monthly expense...

Reply

Answer 10

OlsonBW Author

Level 2

415 points

Mar 9, 2026 1:00 PM in response to Camelot

You are correct about everything you said. When I looked at the script it showed "Numbers Creator Studio" so what am I to believe? That Apple would let me use it without subscribing to it?

Yes, I also have version 15.x installed and that is what I am using. I was hoping that just maybe one of the features that I've requested over the last half life span of numbers that I've been asking for would finally be included in this version. None of them have been and each of them would have made my life easier. Apparently nobody else works the way that I do or tries to do the same thing that I do. Or they are just smarter than I am and/or spend more time working with just Mac OS and maybe mostly with Numbers and figured out things that I didn't as I spending more time writing stories (anything from 20 pages to hundreds of pages long, for my own and nobody else's enjoyment.

Note that I just "***" "u" "med" that you had to have and pay for Numbers Creator Studio just because it was in the script. Bad on me. But you have to admit that most anytime a new product is introduced and the name of the product shows up in documentation or scripts, you have to strongly expect that if that new product requires a paid subscription that I would have to pay to use that script/feature.

Reply

Answer 11

Badunit

Level 7

31,331 points

Mar 9, 2026 3:54 PM in response to OlsonBW

Ahh. OS/2. If only it had come out a little sooner it might have been able to take over from Windows. It was one of my favorite PC operating systems but it didn't have time to gain a strong foothold. And I have fond memories of Lotus 1-2-3 also. I remember how idiotic and confusing and non-user-friendly Excel was when I had to switch to it.

I am with you on the discontinuation of the 27" iMac. I don't know if Apple has lost its way or just changed its way to a direction that doesn't suit me. I liked that it was innovative and intuitive and simple and things worked as designed. It didn't try to do everthing and have every feature under the sun, it had what it needed and it worked. Now I feel most changes are about how it looks, everything is more complicated for no good reason, things change for no good reason, and nothing works right. Apple has become Microsoft.

Reply

Answer 12

OlsonBW Author

Level 2

415 points

Mar 10, 2026 2:17 PM in response to Badunit

It didn't really need to come out too soon. It is just that the ads had to make [bleep]ing sense. Instead of showing nuns walking down a hallway speaking Italian, how about show how OS/2 looked and what it could do that DOS and Win 3.1 could NOT do OR show them how much MORE they could do with DOS and Win 3.1 let alone native OS/2 programs!

I didn't use any bad words but Apple is stopping me from posting my views about the clueless management at Apple and how they have no idea about design or functionality.

If you too hate where Apple is now heading, and you are a nerd, how about checking out Arca Noae's version of OS/2 at https://www.arcanoae.com/.

I NEVER thought I would be going back to OS/2 after IBM abandoned us LOVERS of OS/2 but I am doing that lock stock and barrel (maybe an old person's comment).

I'm in the process of weaning people off of having me support them with spreadsheets using Numbers. I'm not telling them to stop but just that I'm moving on from Apple until I see that someone has changed course in a direction that is appealing to me. Thankfully I've been working with someone at that organization to teach them how to learn and experiment and I told them to come here for help when they need it.

Reply

Numbers: Find & Replace changes sheet names globally

Similar questions