Ask Your Question

Delete a named range or at least set its proper range

asked 2019-03-03 16:51:38 +0100

athegn gravatar image

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 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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-03-03 17:09:15 +0100

ebot gravatar image

Select Data>Set Range from the menu. In the "Set Database Area" dialog box, mark the name of the area to be deleted and click on "Delete".

edit flag offensive delete link more


My version of Libre Office does not have Data>Set Range. I have Data > Define Range but there is not "Set Database Area" dialog box there.

I have used the "Define range" to delete the named range. Yes it is deleted from Data but the range still exists in Managed Names and shows in "Named Range or Expressions" How do I delete the range in these dialogs?

athegn gravatar imageathegn ( 2019-03-03 18:29:07 +0100 )edit

OK may have answer to delete range. In Menu > Sheet > Named Range or Expressions I can delete a named range. There are TWO places where Named Range or Expressions appears! Data and Sheet.

Now delete Range Name in Sheet then recreated in Data. Now formula works.

athegn gravatar imageathegn ( 2019-03-03 19:24:56 +0100 )edit

answered 2019-03-03 17:30:46 +0100

athegn gravatar image

My version of Libre Office ( does not have Data > Set Range . What version of Libre Office does have that facility?

edit flag offensive delete link more


With me Windows 10, Version 1809, 64-Bit | LibreOffice, Version: (x64). Sorry, it is a translation from a German UI. It should be similar.

ebot gravatar imageebot ( 2019-03-03 17:37:12 +0100 )edit

If I want to update Libre Office I am offered 6.1.5 not the later you have.How I will update to 6.1.5 to see if that makes a difference. I see I can download but for power users only?? Will try BTW mine is a 32bit setup.

athegn gravatar imageathegn ( 2019-03-03 18:39:53 +0100 )edit

Now updated to but still no Data > Set Range

athegn gravatar imageathegn ( 2019-03-03 19:12:22 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-03 16:51:38 +0100

Seen: 174 times

Last updated: Mar 03 '19