Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Ivar-1

macrumors newbie
Original poster
Feb 18, 2021
1
0
Hi, does anyone know how I can see if a cell in Numbers is linked to a formula in another cell. The other way around is obvious, but I would like cells to be highlighted or smth like that so I know that they're referenced to from another well (and I do not accidentally change them).
Thanks for any solution!
 
As far as I know, you can only double-click the cell to see the formula. If any value is taken from another sheet or table, it will be highlighted and shows with a name like SHEET::TABLE::CELL.
I am not aware how can one highlight all the cells that contain such formulas, if that's what you're looking for...
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.