I have found old questions on named ranges saying that I can delete a range by using Insert > Named Range or Expressions then using the delete button. On my Libre Office version 6.0.7.3 there is no delete button. All I can do is paste using that facility.
How do I delete a range.
I am having trouble with a named range. If I go to the top left of a sheet, Manage names dialog box, selects the whole column for a named range; the range shown in Named Range or Expressions shows the range as $0:$0 yes full column. However if I select from Data > Select Range I get O1:O108 which is what I want. My problem is that on another sheet a formula looks for this named rangeand gives results based on $O:$O.
I have tried deleting the range Data > Define Range (the only delete option I can find) but to no avail.
Any advice please?