Repository navigation
Named cells
#1007
Replies: 1 comment
|
I'm not completely sure, but this may be tracked by #16. |
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Is there any way to assign a name to a cell that can later be used in formulas, similar to Excel's named cells or Google Sheets's named ranges?
This could make formulas easier to read and write, and I think it might also help with an issue that I've had when referencing a cell in multiple formulas in a different sheet. For example:
Pricingwith a cell E5 that contains a computed value that I want to use elsewhere.{"Pricing"}!E5*B1/1000.yy.vand thenP.D2 now contains
{"Pricing"}!E6*B2/1000, i.e. the reference to E5 was changed to E6. I'd prefer for the pasted formula to continue referencing E5, and wonder if it'd be possible for references to named cells to remain unchanged when pasting.(If there's some other way to prevent a specific cell's coordinates from being updated when pasting a formula, that would work too, although I think that named cells could still make formulas more readable.)
All reactions