Skip to Main Content

Faculty Citation Reports

Converting the Report from Excel to Word

To convert the spreadsheet into a Word document that can be attached to your annual report, follow these steps:

1. Open the Excel file and sheet containing the citations.

2. Open a blank Word document.

3. Select all of the cells with content and copy them using CTRL-C.

4. Right-click in the Word document, and under "Paste Options" select "Use Destination Styles."

5. Adjust the table columns so that they don't look messy, i.e., minimize the appearance of large rows. The easiest way to do this is to select the "Table Tools -> Layout" tab, click on "Distribute Columns," and then resize the columns as you wish.

6. Make sure that the header row repeats across all of the pages of the citation report. To do this, click to place the cursor in the first row (Citation, Author(s), Title, Work Cited), then in the "Table Tools -> Layout" tab, select "Repeat Header Rows."

6. Make sure that the cells don't break across rows, leaving orphaned information. To do this, on the "Table Tools -> Layout" tab, select the diagonal arrow in the corner of the "Cell Size" box, then select the "Row" tab. Click on the check box next to "Allow row to break across pages" to deselect it.

7. On the "Table Tools -> Design" tab, select "Shading" and change the shading of the top row to black.

8. After you've confirmed that the file looks correct, save the file with the following name "[LastName] - [year] Citation Report.docx".

Disclaimer: The views and opinions of the authors expressed herein do not necessarily state or reflect those of the State of Georgia, and shall not be used for advertising or product endorsement purposes. Georgia State University College of Law and the authors of the works contained on this website do not assume or accept any legal liability or responsibility for the accuracy, currentness, or comprehensiveness of the content on this website. The content on this website does not in any manner constitute the issuance of legal advice or counsel. The information on this website is intended to provide resources that may aid the research of the topics presented, and are in no way a comprehensive list of sources one should consult on the topics presented. Please note that case law, statutory law, and administrative law may be modified and/or overturned. Additionally, because the laws vary between jurisdictions, the laws referred to herein may or may not be applicable to the law within the reader’s jurisdiction.