Cell names of merged cells

[DLB]

I have a two columns merged together. I have given each merged cell a name.
However, the name appears not only in the name box but also in the cell
itself. How do I get it not to show in the cell?

 

[Gord Dibben]

How did you name the cells?

Insert>Name>Define or Insert>Name>Create?

I find an easy way to create multiple cell names is to have a list of names
in Column A.

Insert>Name>Create>Left Column>OK

Now you can delete the data from column A.

The created names will remain.


Gord Dibben MS Excel MVP