This question FEELS stupid, but I am at my wits end.
I am trying to insert a hyperlink to a different section of a calc worksheet. If I understand correctly, I need to name the range I want to link to first. Cool. But when I select the target range, and go to the Insert menu, I don’t have an option to NAME >define. I have an option “Named Range or Expression” and there is no sub-options. When I click the Named Range I get a box that doesn’t give me the option to DO anything. I am just trying to add a button to link to another section in the same spreadsheet and getting nowhere. I have looked at the info for both hyperlinks and defining names and I am just not seeing the options the directions include. Please halp.