Folks,

Kindly, answer whichever you can, even if you can't answer all of these:

If I have named a cell, can I later edit that name? If so, will the cells
that depend on it pick up the revised name?

If the answer to the first question is yes, is there a way to change say,
every range name, that currently starts with "project.a" and, say, replace
that beginning with "phase.1"?

Also, if I name an independent cell after another dependent cell's equation
already refers to it, how do I get the dependent cell equation to show the
range name in its equation? If I must edit the equation, is there some
shortcut that would minimize the number of keystrokes involved?

If I go to a range named cell and perform edit-clear-all, will the range
name also be eliminated?

Kindly do not recommend any outside provider add-ins, to do any of the
above, as they tend to freak my bosses out.

Thanks very much!
Dean