Upgrade StorageAdding citations in Excel
I am working on a manuscript that will include multiple tables citing other authors' work. When the paper is published, the citations will need to be in numerical order, including the citations in the tables. For example, if my last citation in the text is [5] and the next citations are in the table, the table citations will need to be [6-10], and the next new citation in the text will be [11].
I am using the Zotero add-on in Word for the manuscript, but that numbers my citations that are only in the main text of the manuscript, not ones that are in an Excel spreadsheet. I know Zotero doesn't have an add-on for Excel. Is there any easy way to use Zotero to link to citations in an Excel spreadsheet so that my spreadsheet looks like Author et al [6]? And is there any way to do this so that the citations stay in order when switching back and forth between Word and Excel?
I am using the Zotero add-on in Word for the manuscript, but that numbers my citations that are only in the main text of the manuscript, not ones that are in an Excel spreadsheet. I know Zotero doesn't have an add-on for Excel. Is there any easy way to use Zotero to link to citations in an Excel spreadsheet so that my spreadsheet looks like Author et al [6]? And is there any way to do this so that the citations stay in order when switching back and forth between Word and Excel?
-
adamsmithI'm afraid I see no way of doing this, no. Excel just doesn't have the type of fields Zotero uses to store and generate citations.
-
bwiernikI would suggest making your table in your Word document. You can control the dimensions of table cells from the Ribbon menus, rather than click and drag, for fine grained control like in Excel