Ask Your Question
0

Make cell references change automatically to reflect cell naming?

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

einpoklum 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
0

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

@einpoklum,

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

Stats

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

Seen: 68 times

Last updated: Aug 27 '19