


Click the row that will be the top of the second table. Split the table into a separate table for each page.Re-enter zeros that were rounded down in Excel.Re-size the columns of the table, and then use AutoFit Window.Don't use Ctrl + V to paste, which pastes the table in as an image In Word, on the Home ribbon, click the Paste drop down arrow, then Keep Source Formatting. Copy the table in Excel using Ctrl + C.Add in the heading "Page" at the top of the right column.Apply Wrap Text only on the center column.Indent the left column, except the “Article” headings.Left align the left two columns, and right align the right (page number) column.Top align the left two columns, and bottom align the right (page number) column.Adjust vertical and horizontal alignment and indents.Merge the left and center columns for rows that have “Article” headings.Cut and paste page numbers so that they are all in the same column.In Excel, move data into the correct columns and merge cells to get the desired format.Or, you can set up and format the table in Word, using the tips in Word Tables Open a new Excel workbook and use Ctrl+V to paste. Select the text of the table of contents, then use Ctrl+C to copy.Press Alt + F9 to toggle off Show Fields.Press Ctrl + Shift + F9 to convert fields to text.Press Ctrl + A to select all the document text.Press Alt + F9 on your keyboard to toggle on Show Fields.If you have not already converted the fields to text when you Scrub the Report: Use the steps below to bring the content into a table structure. The native Microsoft Word Table of Contents (TOC) is not supported in HTML conversion.
