Make cell references change automatically to reflect cell naming?

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?


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.