Show named fields in cell

I

insomniux

Hi,
I have a sheet with >100 named fields. To verify if the fieldnames are
indeed correct, I would like to have the names of the field displayed
in the cell, instead of the cell contents. Is that possible?

Also I would like to know if it is possible to make a list with
fieldnames and cell-references (like the list which is produced by
pasting the namelist) and feed this to Excel in order to define the
named fields.

Thanks

Insomniux
 
D

Dallman Ross

In <[email protected]>,
insomniux said:
I have a sheet with >100 named fields. To verify if the fieldnames are
indeed correct, I would like to have the names of the field displayed
in the cell, instead of the cell contents. Is that possible?
Click to expand...

If by "names of the field" you mean the formulas in each cell
instead of the result:

Tools -> Options -> View pane, find and tick "Formulas" under
"Window options".
Also I would like to know if it is possible to make a list with
fieldnames and cell-references (like the list which is produced by
pasting the namelist) and feed this to Excel in order to define the
named fields.
Click to expand...

dman (annoyed Microsoft doesn't use title case with "Window options")
 
I

insomniux

No, I found that option, but I mean the name of the field which you can
use to refer to instead of using the direct cell reference (like B3).

Dallman Ross schreef:
 
D

Dallman Ross

In <[email protected]>,
insomniux said:
No, I found that option, but I mean the name of the field
which you can use to refer to instead of using the direct cell
reference (like B3).
Click to expand...

Ah, okay. Sorry for misunderstanding. There is a way to do that,
as well! It's also in Options. In fact, I found it two days ago
and turned it on, though I haven't tried it yet.

In Excel 2002, anyway -- under the Calculation tab in the
Options area, tick "Accept labels in formulas", the bottom-
right choice on that tab pane.

---------------------------------------
 
I

insomniux

Mmmm...
Still does not exactly what I need. If that box is checked, the names
_can_ be used and displayed in formula's, But if a cell has no formula,
it still can have a name.

The purpose is to do some validation. I will refer to the cellnames
from another sheet, but I have to make sure the name corresponds with
the text-label of the field.

Dallman Ross schreef:
 
D

Dallman Ross

In <[email protected]>,
insomniux said:
Mmmm... Still does not exactly what I need. If that box is
checked, the names _can_ be used and displayed in formula's, But
if a cell has no formula, it still can have a name.

The purpose is to do some validation. I will refer to the
cellnames from another sheet, but I have to make sure the name
corresponds with the text-label of the field.
Click to expand...

I think I didn't really understand what you were after even
after I thought I did the second time. :) Sorry.
I'm still not entirely sure what the best approach is
for you. However, I wonder if the advanced add-in
Names Manager will help. I have been using it for a
few days now and like it.
http://www.jkp-ads.com/officemarketplacenm-en.asp

You might also find useful the DataRefiner Add-in by
Ron de bruin and Norman Harker:
http://www.rondebruin.nl/datarefiner.htm
I haven't tried it, but it looks promising.

Hmm, this also looks possibly useful:
http://www.contextures.com/excelfiles.html#DataVal

---------------------------
 
I

insomniux

Bingo!!!
Exactly what I need. You can select Highlight names. Then it will
create an overlay on each named cel with the givenname. Brilliant
Thanks for the tip and thanks to JanKarel
Insomniux

Roger Govier schreef:
 
Top