We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Make cell references change automatically to reflect cell naming?

asked 2019-08-27 10:28:38 +0200

einpoklum gravatar image

updated 2021-05-24 17:45:26 +0200

Alex Kemp gravatar image

In a LibreOffice calc spreadsheet, I have a bunch of cells with formulas referring to other cells, without special (nick)names, e.g. D5 or H3, Now I set some name for my cells, e.g. D5 gets the name FIZZ and H3 the name BAZZ. However, none of the references change from D5 or H3 to FIZZ or BAZZ respectively.

I suppose I could use a regular expression search for each name, but - is there some way to automate this change for all names at once?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-08-27 14:46:29 +0200


It can be done: Select the cells to change and use Edit / Find and Replace.


ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-27 10:28:38 +0200

Seen: 163 times

Last updated: Aug 27 '19