Pasting a huge excel document in a word test script

Question

Hi,

I have a UAT test script for which I need to post some reference tables (excel sheet) in the appendix. The excel sheet has a lot of columns and doesn't fit into the MS Word document even when I paste the table in the landscape page set up. Is there any good way to paste such a huge table without making things too complex. I've tried shortening the table columns and also reduced the font size to 8 too. Anything smaller than this is going to make it too small for the business users.

Thanks, SK

Answer 1

1) You insert a new section in the Word document and change that Page Layout (Page Layout |Breaks|(Section Breaks)) to a larger page size, perhaps 11x17 and landscape.

2) Insert the Excel file as an object (Insert|Text|Object|Create From File), checking Display as Icon to save space.