If you've ever built a navigation system in a spreadsheet only to watch it slowly break, you already know the frustration. This reader's problem is familiar, and the root cause is not a mystery: the links they created are static references, not dynamic ones. When rows are added or removed, the spreadsheet does not automatically update the cell references inside a right-click link the way it updates formulas. That is why the jump drifts over time. The solution is not to abandon links altogether, but to use a method that actually adapts to change.
The reader tried the `HYPERLINK` formula with a direct reference like `=HYPERLINK(A730, "Category1")` and found it didn't work. That is expected, because the formula expects a URL or a file path as its first argument, not a cell reference. The correct approach is to use the cell reference itself as the link target, but in a way that the spreadsheet recognizes as dynamic. For example, `=HYPERLINK("#"&CELL("address",A730), "Category1")` tells the spreadsheet to build a link to wherever A730 currently is, and if rows are inserted above it, the reference updates automatically. This is not a workaround; it is the intended use of the formula. It gives you the same clickable jump, but with the resilience that a static link lacks.
The deeper issue here is that many users treat spreadsheet navigation as an afterthought. They build a quick link, it works for a while, and then they assume the tool is failing them. In reality, the tool is doing exactly what it was told. The reader's instinct to avoid `$` signs was correct, but they applied that logic to the wrong feature. The `$` locks a reference, and they do not want that. What they want is a reference that moves with the data, and the `HYPERLINK` formula, when constructed properly, does exactly that. It is a small shift in thinking, but it turns a fragile shortcut into a durable system.
For anyone managing a workbook with dozens of category links, the takeaway is straightforward: stop relying on right-click links for anything that might shift. Use formulas that reference cells, not fixed addresses. If you are adding rows, moving blocks, or reorganizing data, a formula-based link will follow the data. A static link will not. That is not a limitation of the spreadsheet; it is a design choice. The fix is not to spend hours updating links after every edit. The fix is to build them the right way from the start.