| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
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
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cross References | Microsoft Word Help | |||
| Help With Cross References | Microsoft Word Help | |||
| Cross References | Microsoft Word Help | |||
| cross references | Microsoft Word Help | |||
| It's all about cross-references... | Microsoft Word Help | |||
Linear Mode
