Ask Your Question

Calc: Defined cell names not displaying in the name box

asked 2019-08-07 04:20:14 +0100

Bubbe gravatar image

updated 2019-08-07 04:27:13 +0100

I have created a worksheet in which I have defined names for a lot of the cells. Until recently, the names would always appear in the Name Box instead of the location. I have no idea why, but most are no longer displaying, though working. I find it quite helpful to have them display and was wondering if something had changed to cause this problem. Is there a way to restore it the way it was?

Name box contains "B4" instead of the defined name, "mCovWid"

image description

Manage Names shows

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-07 05:11:31 +0100

Bubbe gravatar image

I have figured out part of the problem. When I changed the "Scope" to the current worksheet (named "Spiral") is when the defined cell names stopped displaying in the Name Box. I figured this out when I changed the Scope back to the entire document.

The question now is, how can I have the scope for the defined cell names be just for the current sheet and still show in the Name Box?

Notice the change in scope fixed the problem:

image description

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-07 04:20:14 +0100

Seen: 146 times

Last updated: Aug 07 '19