Questions tagged [cross-reference]
References within a document (most commonly a Word document) to other parts of the document, such as a heading, table, or image.
116
questions
0
votes
1
answer
31
views
Microsoft Word: how to cross-reference an autonum field?
I'm writing a survey questionnaire and use autonum fields for the question numbers. Say the 12th question is "Q{autonum}. Cats or dogs?", which Word shows as
Q12. Cats or dogs?
Later on I ...
- 26
0
votes
0
answers
25
views
Invalid source error when trying to add citations in Word
I am uploading an XML file produced by Mendeley to an MS word file. Even though I have all the information correctly saved including authors names and journal details, the Word disregard the authors ...
- 101
0
votes
0
answers
17
views
Cross reference to external file
I use cross references inside the same LibreOffice document a lot and find it nice and easy to use.
But I now have a document that is so big, that I want to split it into two files: One with my text (...
- 4,454
0
votes
1
answer
23
views
Creating List in MS word with numbers linked to heading number
I am creating a document with several sections that each contain a heading number.
Many of the sections contain tables. The first column in the table should contain a list of ID numbers.
The numbers ...
- 1
0
votes
0
answers
53
views
Transform cross-reference table into combination of rows and columns with their respective values
I have a cross-reference table similar to this:
How do I combine both rows and columns to arrange them in 3 columns where their values are in the last column?
Is there any special Excel tool/function ...
- 1
0
votes
0
answers
14
views
For Excel, is there a way to highlight dependent cells for formulas on other tabs to indicate user entry
For Excel:
I am looking to have listed items with property fields listed in tabs that look to the front reference tab for supplying the field data. Is there a way to highlight the dependent cells on ...
- 1
0
votes
2
answers
189
views
Find and Replace strings in a TEXT FILE using values from two columns in an excel sheet, respectively for the FIND and REPLACE string
I have many large "configuration" text files containing IP ADDRESSES on an old network [Router configurations. Switch configurations. Firewall configurations, etc.]
The configuration files ...
1
vote
1
answer
210
views
How to create dynamic sheet references with cell text in Excel
I am working with a large workbook and I want to drag formulas across to reference the title of their column with the corresponding sheet of the same name.
In this example: =VLOOKUP($B3,'04.22 NE'!$B$...
- 11
0
votes
1
answer
143
views
Cross reference format
I have a problem in the cross reference font that is appearing every time I put a cross reference like for e.g. "Table 24" within the text, it appears automatically Bold and Italic like the ...
- 25
1
vote
2
answers
2k
views
How can I get a list of cross-references in Microsoft Word?
I wish to know how to see the list of cross references in Microsoft Word. How can I see the things (tables, figures, etc...) that are cross referenced in one table or in one list?
My end goal is to ...
- 25
0
votes
1
answer
119
views
Is it possible to styleRef a style, which is not legal style numbering, with legal style numbering?
I have made a custom "Heading 1" style, look something like this for example:
Chapter壹 (the 『壹』stands for "one" in Traditional Chinese, selected by the dropdown list, without ...
- 101
0
votes
1
answer
53
views
excel - how to create a "copy" of a worksheet in the same file, that still references to the original worksheet
excel - how to create a "copy" of a worksheet in the same file, that still references to the original worksheet
So I want it to behave like this
worksheet 1
worksheet 2 = copy of worksheet 1
...
- 103
-1
votes
1
answer
306
views
How do I link annexure numbers in a Word document automatically if annexures are added?
in typing legal documents, there are many annexures specified throughout the document. How do I link the annexures to each other to automatically update if annexures are added or deleted, i.e.
...
2
votes
0
answers
256
views
Add hyperlink to hidden bookmark in MS Word
I am manually assembling a list of figures for a large Word document. I originally used the "Table of Figures" feature to generate this automatically from figure captions, but I found that I ...
1
vote
1
answer
403
views
How can I remove the parentheses from equation cross-references in Word?
It is common in mathematical articles to number displayed equations with integers in parentheses: (1), (2), etc., and to cross-reference these equations using numbers without parentheses: Eq. 1, Eq. ...
- 157
0
votes
0
answers
250
views
How to make a cross referenced heading number with a customized numbered outline without first level number?
I've made an "Appendix" heading style using the style Heading 5 as the base style. I want the numbers to show up as "Appendix A" so the "Customized Updated Numbered List"...
0
votes
1
answer
110
views
Reference to a Table from another worksheet messes up the order and leads to data inconsistency
I have a spreadsheet with two worksheets.
The first worksheet (Source Data) contains a Table with 3 columns:
I'd like to show two first columns from that table on the second worksheet (Emails) so I ...
0
votes
1
answer
126
views
Excel Reference another sheet like a dictionary
On a sheet in my excel file, I have rows as shown in the following :
In a second sheet in the same excel file, I have a reference sort of like a dictionary that links each organization to an ...
0
votes
1
answer
775
views
Cross reference text in word
I have a Word document which include several tables for different items.
I would like to refer in the main body text to the items directly (e.g.
See Item 1 for further reference
).
I don't want to ...
- 297
0
votes
1
answer
718
views
How can I add cross references in an existing PDF file?
I have a PDF document that I am reading on my computer running Ubuntu 20.04. The document has over 200 references but, unfortunately, none of the citations of these references are clickable, e.g:
...
1
vote
1
answer
806
views
Cryptic error from Sphinx: "Anonymous hyperlink mismatch"
I'm using Sphinx 2.2.2 to debug a Sphinx document with a large new source file that contains many cross-references. I get this message:
Warning, treated as error:
C:\Users\...\<filename>.rst::...
- 151
0
votes
1
answer
359
views
How to add a dynamic reference in Microsoft Word?
I have a passage of text that references an image further down. If the image is on the same page as the passage, I want the passage to include the string "as pictured below". If the image is ...
- 171
1
vote
2
answers
2k
views
Don't preserve formatting in cross-reference
When I in MS Word 365 create cross-references, a table-of-contents or an index, then any custom formatting I have done on the headlines, bookmarked words etc. appear in the cross-references.
For ...
- 283
0
votes
2
answers
2k
views
Cell referencing change with filter
I am quite new to Excel and just figuring out how to do things. I have a question about cell referencing between sheets.
Say I have on Sheet1 this table:
DIMENSION VALUE
X 0
Y 1
Z ...
- 103
0
votes
1
answer
23
views
Can I insert references to individual slides into a PowerPoint deck that would be updated automatically?
Suppose I am creating a large deck and want to insert a slide at the beginning that would essentially be a table of contents. Something like:
Introduction: slides 1-10
Section on Foo: slides 11-15
...
- 407
0
votes
0
answers
19
views
Ms word paste as reference not plain text
I have a long list of reference that should be entered in MS word. something like this:
[1] Nudo, R. J., Milliken, G. W., and Jenkins, W. M. , “Use-dependent alterations of movement representations in ...
0
votes
1
answer
157
views
Dynamic worksheet name in formular
I have an Excel workbook with 101 worksheets. The 1st worksheet shall provide me with a reference of cell A1 of all following 100 worksheets. Which formula can be used without manually linking each ...
- 1
0
votes
2
answers
739
views
EXCEL; I would like to match two email address from two different worksheets and return a value of 2 cells (phone numbers)
i have two work sheets one contains ALL the information and one is a filtered version with some additional info add, i would like to match an email addresses (column Q)sheet 1 to (column D) sheet 2 ...
- 1
0
votes
4
answers
10k
views
How to modify cross reference text in Microsoft Word?
I use cross references in my Word 2019 documents and I want to change the text of a cross reference and to maintain it during updates.
For instance, I have a figure with the caption: "Fig. 1.1 ...
- 105
1
vote
1
answer
305
views
I don't want word to change certain cross references on update
I'm using a special reference system that no one uses except these people I'm writing for. It uses a system of brackets, for instance "[ABC]" would be a reference. I guess other reference ...
- 11
0
votes
1
answer
551
views
Iterate through document and insert cross references using VBA
I'm using mail merge in Word 2016, and then saving merged results as a PDF. In order not to break the hyperlinked table of contents in the merged document when I save as PDF, I have to build a table ...
0
votes
1
answer
408
views
Make Table of Content link to current document for headings inside tables
I'm creating a document in which I use header styles to create a table of content. These header styles I use inside a table as you can see in the image below
Table used for referencing:
Now if I want ...
0
votes
1
answer
183
views
How to insert same reference multiple times in MS Word 2003?
What I am trying to do is
>
Information-1 1
Information-2 2
Information-3 1
Reference list:
Reference-1
Reference-2
But what I am getting is:
>
Information-1 1
...
- 113
1
vote
1
answer
2k
views
Word cross-reference to only number in figure
Adding a Figure caption to an image in a text, I Include the chapter number in the caption, so it would look something like that:
The problem has been addressed many times before, such as here or ...
- 530
2
votes
1
answer
144
views
MS Word: Proactively assign a specific style to all cross-references?
I found this great question/answer on retroactively applying a specific style to all cross-references in a document, but is there a way to define a cross-reference style proactively so that every time ...
- 187
0
votes
1
answer
2k
views
How to generate a list/table of all headings of a certain level in Word
Is there any automated way in Microsoft word to generate a list or fill a table with cross-references to all headings of a certain style in the document? Right now my only option is to manually click "...
- 1
1
vote
1
answer
666
views
How can I find where a header is referenced in a word document?
I inserted a lot of cross references in my word document.
(in the Insert ribben, the links group, select Cross Reference)
Is there a way to find out where I refered a certain paragraph?
- 245
0
votes
2
answers
367
views
Is it possible to compress PDFs with Ghostscript and keep cross references intact?
I have since quite some time used the following batch file (or similar ones) to compress my pdfs.
C:\"Program Files"\gs\gs9.26\bin\gswin64 -sDEVICE=pdfwrite -dCompatibilityLevel=1.4 -dNOPAUSE -dBATCH ...
- 101
0
votes
2
answers
597
views
Cross-Reference to Heading Text of Heading generates Error! Reference source not found. after source text is updated
TL;DR: Cross-References to the Heading Text of a Heading-styled paragraph are incredibly fragile and don't survive in the real world where users edit text. Terrible workaround: Make all edits to the ...
- 171
2
votes
2
answers
876
views
MS Word: Create cross-reference linking to the top end of a figure, instead of figure labeling text below the image
I've a problem with Microsoft Office Professional Plus 2016:
After I have created a caption text below a figure, and then inside my text set a link to this image, the link will lead me to the labeling ...
- 111
0
votes
1
answer
1k
views
Problems with references and master documents
I have a Master Document with chapter subdocuments. The subdocuments contain references using the Citations and Bibliography tool that Word comes with.
When working on the subdocuments I added many ...
- 101
1
vote
1
answer
49
views
Cross-reference format
I would like to ask how to change the format of references in the main text. The journal asks the authors to use box brackets in the main text but round brackets in the reference section. Such as:
...
- 11
1
vote
1
answer
2k
views
Cross Domain Windows Authentication "Allowed to Authenticate" not working
We have couple of websites which is working on different servers and all are internally connected with the LAN. All websites are using windows authentication.
Now I would like to use Single Sign ON ...
1
vote
1
answer
322
views
Cross reference to an element of a numbered list without the dot and space that follows the number
I have a document with a numbered list where the numbers are followed by a dot and a space.
When I cross reference to an element of the list, I want only the number to appear, without the dot and the ...
- 2,018
0
votes
1
answer
99
views
Cross reference to specific paragraph styles in Word
In order to make a cross reference, I have to choose from some predefined element types, such as Heading, Figure, Table.
Is it possible to make cross references to specific paragraph styles?
- 1
2
votes
1
answer
11k
views
Change referencing style from APA to IEEE in Microsoft Word
I have written a document with APA references. Now I decided to apply IEEE references instead of APA. How can I change the APA references style of my document to the IEEE style.
- 121
0
votes
0
answers
57
views
Cross reference with page number
In LaTeX, there is the possibility of using \vref{...} for a reference, which creates a text like figure 12 on page 15. It has the benefit that it is intelligent enough to do a simple distinction:
Am ...
- 1,375
0
votes
3
answers
215
views
Excel: how can I find a cell being referenced?
Suppose I'm at cell C1, and the code in it is "=A1". Then in cell D1, I want to see that C1 is linking to A1, and then link to B1 instead.
More generally, if a cell X is linking to a cell (a,b), is ...
- 161
1
vote
1
answer
111
views
Excel - using a cell reference on another sheet in a RAND formula
Does anyone know if it's possible to replace the probability reference in a RAND command with a cell reference to another worksheet?
I am using the basic formula below for weighted randomised text ...
- 133
0
votes
1
answer
1k
views
Insert only figure number, without label, via cross reference in word
I have figures with names such as "Figure A-1". I want to insert in the table of content the A-1 part, without the label Figure. In cross-references, there are options including the whole caption, and ...
- 275