Cross-references

[Dawn Crosier, Word MVP]

Hi Aleksander -

You can cross-reference to any existing element (bookmarks, numbered
lists, headings, footnote, endnote, equation, figure or table) as many
times as you need to do so. However, multiple bookmarks need to have
unique names in the document.

Does that help?

--
Dawn Crosier
Microsoft MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions
to the newsgroup so that others can learn as well.

Hello,

If to make bookmark on the cell of the table and then to use Insert | Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.2/1270 - Release Date:
2/10/2008 12:21 PM

 

[Aleksander]

Hello,

If to make bookmark on the cell of the table and then to use Insert | Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander

 

[Stefan Blom]

I can think of two methods which would omit the cell formatting (such as
borders) and just reference the contents of the bookmarked cell.

One method is to copy the cell and then use the Paste Special dialog box to
paste "Unformatted Text" as a link (click the "Paste link" radio button).
This inserts a LINK field that references the contents of the cell.

Alternatively, if the cell contents are numeric, you can create an ordinary
cross-reference and then add a formatting switch to the field code; this
suppresses the cell formatting. For example: After you've inserted the
cross-reference, press Alt+F9 to show the field code. You will see something
like this: { REF bookmarkname }. Add \# "#" to the end of the field code and
press F9 to update. Press Alt+F9 again to hide the field code.

--
Stefan Blom
Microsoft Word MVP


in message
Hello,

If to make bookmark on the cell of the table and then to use Insert |
Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create
cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander

 

[macropod]

Hi Aleksander,

Are you trying to cross-reference another cell from the same table? If the answer is yes AND the cells that you want to
cross-reference contain only numbers, then bookmarking the whole table will allow you to use the one bookmark for each
cross-reference. For example, suppose you want to cross-reference the values in cells A1 and B4. If you bookmark the table 'Tbl1',
then formula fields coded as:
{=SUM(Tbl1 A1)} and {=SUM(Tbl1 B4)} will retrieve the required values.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

Hello,

If to make bookmark on the cell of the table and then to use Insert | Reference | Cross-reference the result
will be cross-referenced cell of the table. Is it possible to create cross-reference link with existing cell of the
table, not creating new one?

Sincrerly,
Aleksander

 

[Stefan Blom]

I can think of two methods which would omit the cell formatting (such as
borders) and just reference the contents of the bookmarked cell.

One method is to copy the cell and then use the Paste Special dialog box
to
paste "Unformatted Text" as a link (click the "Paste link" radio button).
This inserts a LINK field that references the contents of the cell.

Alternatively, if the cell contents are numeric, you can create an
ordinary
cross-reference and then add a formatting switch to the field code; this
suppresses the cell formatting. For example: After you've inserted the
cross-reference, press Alt+F9 to show the field code. You will see
something
like this: { REF bookmarkname }. Add \# "#" to the end of the field code
and
press F9 to update. Press Alt+F9 again to hide the field code.

Clarification: If your numbers include decimals, you will have to use
something like this instead (for two decimals): \# "#.##" (be sure to use
the decimal sign specified on your system).

 

[macropod]

Hi Stefan,

Coding the switch as:
\# 0
or
\# 0.00
or
\# ,0.00
will give more consistent results. Using a # can result in leading and trailing 0s being displayed as spaces (eg instead of getting
'0' or '0.10' you might get ' ' or ' .1 ').

Cheers

 

[Stefan Blom]

Good point. Thank you.

--
Stefan Blom
Microsoft Word MVP

Hi Stefan,

Coding the switch as:
\# 0
or
\# 0.00
or
\# ,0.00
will give more consistent results. Using a # can result in leading and
trailing 0s being displayed as spaces (eg instead of getting '0' or '0.10'
you might get ' ' or ' .1 ').

Cheers