Is there a way to name a range so that it doesn't automatically change when rows are added in between?
Ex: Range1 =
Add a row between rows 6&7 and now this automatically changes to
When i go into the named range sidebar, i've tried to change the formula to say:
but the $ go away immediately upon hitting ok