Ask Your Question

naming a range - what the devil?

asked 2020-02-26 21:34:38 +0200

tooniebug gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-02-26 23:24:41 +0200

Opaque gravatar image

updated 2020-02-26 23:26:17 +0200


not sure if you are looking for this:

Naming a range - Method 1

  • Select the range (e.g. A1:C10)
  • Type your desired name into the Name Box (e.g. MYDATA)
  • Type ENTER

image description

Naming a range - Method 2

  • Select the range (e.g. A1:C10)
  • Sheet -> Named Ranges and Expressions-> Define ...
  • Add your desired name (e.g. MYDATA)
  • Click button Add

    image description

Using a Named Range

  • Select your target cell (upper left corner of the target range)
  • Set: =MYDATA (as per example above)
  • Type STGR+SHIFT+ENTER (creates an array formula)

image description

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


There is no "Define Name" panel in LibreOffice There's an "Insert>Named Range or Expression..." but that gives you a panel titled "Paste Names" with a table of three columns titled Name, Range or Expression, and Scope, which you can't do anything with. (I started looking into this trying to find a way to reference "the cell above" a specific cell, to create a formula that would work regardless of rows inserted or deleted in between.)

Luke Kendall gravatar imageLuke Kendall ( 2020-03-04 14:08:08 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-26 21:34:38 +0200

Seen: 42 times

Last updated: Feb 26