How do I name a single cell in Calc? [closed]

asked 2017-11-02 20:32:58 +0100

markroth gravatar image

Not a range of cells. Just a single cell.

Could someone please confirm these four steps?

  1. Click cell.
  2. Click Name Box.
  3. Replace Name Box content with desired cell name.
  4. Press Enter

That seems to work, but I haven't been able to find simple instructions online, so I'm suspicious. :)

Thank you, Mark

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by LeroyG
close date 2020-10-18 21:14:13.270799

Comments

1

You are doing that right. Your named range consists of a single cell. And you may continue managing it using Sheet-Named Ranges and Expressions-Manage (Ctrl+F3).

Mike Kaganski gravatar imageMike Kaganski ( 2017-11-02 20:36:46 +0100 )edit

A belated thanks, Mike!

markroth gravatar imagemarkroth ( 2019-12-27 16:13:29 +0100 )edit

Also, see answer at https://ask.libreoffice.org/en/questi....

LeroyG gravatar imageLeroyG ( 2020-10-18 21:14:01 +0100 )edit
add a comment