A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Cross-references



 
 
Thread Tools Display Modes
  #1  
Old February 10th 08, 06:58 PM posted to microsoft.public.word.docmanagement
Dawn Crosier, Word MVP
external usenet poster
 
Posts: 425
Default Cross-references

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.




"Aleksander" wrote 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



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


Ads
  #2  
Old February 11th 08, 04:49 AM posted to microsoft.public.word.docmanagement
Aleksander
external usenet poster
 
Posts: 4
Default Cross-references

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
  #3  
Old February 11th 08, 10:38 AM posted to microsoft.public.word.docmanagement
Stefan Blom
external usenet poster
 
Posts: 8,430
Default Cross-references

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


"Aleksander" wrote 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





  #4  
Old February 11th 08, 10:57 AM posted to microsoft.public.word.docmanagement
macropod
external usenet poster
 
Posts: 1,002
Default Cross-references

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]
-------------------------

"Aleksander" wrote 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

  #5  
Old February 13th 08, 12:53 PM posted to microsoft.public.word.docmanagement
Stefan Blom
external usenet poster
 
Posts: 8,430
Default Cross-references

"Stefan Blom" wrote in message ...
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).

--
Stefan Blom
Microsoft Word MVP




--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote 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









  #6  
Old February 14th 08, 02:11 AM posted to microsoft.public.word.docmanagement
macropod
external usenet poster
 
Posts: 1,002
Default Cross-references

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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Stefan Blom" wrote in message ...
"Stefan Blom" wrote in message ...
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).

--
Stefan Blom
Microsoft Word MVP




--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote 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










  #7  
Old February 14th 08, 09:36 AM posted to microsoft.public.word.docmanagement
Stefan Blom
external usenet poster
 
Posts: 8,430
Default Cross-references

Good point. Thank you.

--
Stefan Blom
Microsoft Word MVP


"macropod" wrote in message ...
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
--
macropod
[MVP - Microsoft Word]
-------------------------

"Stefan Blom" wrote in message
...
"Stefan Blom" wrote in message
...
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).

--
Stefan Blom
Microsoft Word MVP




--
Stefan Blom
Microsoft Word MVP


"Aleksander" wrote 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













 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross References bse3 Microsoft Word Help 1 December 11th 07 11:39 PM
Help With Cross References smita Microsoft Word Help 19 December 14th 06 07:32 PM
Cross References Mike Faulkner Microsoft Word Help 3 November 1st 06 02:20 PM
cross references Pat Microsoft Word Help 1 July 11th 06 05:07 PM
It's all about cross-references... Thommy Microsoft Word Help 3 August 19th 05 03:51 PM


All times are GMT +1. The time now is 03:39 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.