Page 2 of 4
Excel Spreadsheet
1. Highlight the data in Excel and select copy.
2. Go to Word and select Paste. The spreadsheet is a table in Word [see next].
Tables
If the table is more than one page each page should include a
header.
1. Select the table to display the Table Tools > Layout menu
2. Highlight the row[s] of text to repeat on every page
3. Select Layout >Repeat Header Rows
Tables may be resized to fit or to fill the width of the document.
Confirm your margins are 1 inch before you begin. Select the table
to display the Table Tools Layout menu. Select AutoFit. Select
an option, starting with Autofit Window.
Create landscape pages to accommodate wide tables
Tables are frequently best displayed on landscape pages; they may be too wide to fit across the
portrait page. Insert section breaks to change the orientation of pages to landscape. Section
breaks separate the pages and then just some of the pages are rotated to landscape mode.
If you have not added page numbers to the document, follow this handout to add page numbers
now: https://library.albany.edu/imc/tutorials_handouts/Dissertationpageformat.pdf
To create landscape pages, apply section breaks
1. Place your cursor at the end of the text [not the footnote] of
the preceding page. Select Layout > Breaks >Next Page.
You may need to press delete to bring the text to the top of
the page.
2. Place your cursor before the text of the next portrait page.
Select Layout > Breaks >Next Page. You may need to press
delete to bring the text to the top of the page.
If you double click in the footer area, and browse through the
pages, you will see different section numbers.
3. To apply landscape orientation, click in the first or only page in the section. Select Layout >
Orientation > Landscape.
4. Review the page numbers. The page numbers should continue and not start at page 1 every
time there is a new section break.