| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell names of merged cells
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell names of merged cells
How did you name the cells?
InsertNameDefine or InsertNameCreate? I find an easy way to create multiple cell names is to have a list of names in Column A. InsertNameCreateLeft ColumnOK Now you can delete the data from column A. The created names will remain. Gord Dibben MS Excel MVP On Wed, 14 Apr 2010 14:47:01 -0700, DLB wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I transpose cells associated with a merged cell? | Excel Worksheet Functions | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Linear Mode
