Ask Your Question

How to delete a range name? [closed]

asked 2014-01-01 20:58:43 +0100

wsanders gravatar image

updated 2015-11-17 01:46:09 +0100

Alex Kemp gravatar image

I cannot find a menu item or any help regarding how to delete a range name (the name, not the cell contents). How does one do this?

This is: Version: Build ID:

This is in a LibreOffice calc spreadsheet that was created in OpenOffice. AFAIK I used to be able to use the backspace or delete key in the Navigator to do this in OO.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-17 01:46:26.284069

1 Answer

Sort by » oldest newest most voted

answered 2014-01-02 00:38:35 +0100

Regina gravatar image

Ctrl+F3 or Insert > Names > Manage... opens the dialog. Select the range name from the list and click "Delete" button.

edit flag offensive delete link more



Found it - thanks very much. (Can't upvote you just yet.)

wsanders gravatar imagewsanders ( 2014-01-02 00:47:21 +0100 )edit

@wsanders can you mark the answer as 'correct' by clicking the check mark?

bencomp gravatar imagebencomp ( 2014-01-03 11:13:04 +0100 )edit

On my sheet that deletes it from the list in the box that opens but it still appears in the menu box top left.

Paul_UK_Libre gravatar imagePaul_UK_Libre ( 2015-06-19 10:02:04 +0100 )edit

There is no "Delete" button on my Insert > Names > Manage dialog... Is there a new way to do this since 2014? Am I looking in the wrong place?

Gwalior gravatar imageGwalior ( 2018-05-28 03:35:10 +0100 )edit

Yes, the dialog has been moved to the menu Sheet > Named Ranges and Expressions. You can open the dialog from the name field left of the input bar or with shortcut Ctrl+F3 too.

Regina gravatar imageRegina ( 2018-05-28 09:19:11 +0100 )edit

The shortcut described earlier still works, but this feature has moved to: Sheet > Named Ranges and Expressions > Manage

Michael Szczepaniak gravatar imageMichael Szczepaniak ( 2018-08-11 17:02:09 +0100 )edit

Question Tools

1 follower


Asked: 2014-01-01 20:58:43 +0100

Seen: 4,150 times

Last updated: Jan 02 '14