Shaun Wingrin

asked on

# Paste in Word

Say, I've tried pasting the attached in word 2013 and experienced an issue where the right margin is cropped and the document spans much more than 2 pages. Please can you assist with how to achieve this.

TelecareSubcription2016-Shiur-On-Sa.xlsx

TelecareSubcription2016-Shiur-On-Sa.xlsx

The size of your table is too big for a standard letter sized page (or A4 page)

In fact, it requires 2 pages...

Copy-of-TelecareSubcription2016-Shiu.pdf

In fact, it requires 2 pages...

Copy-of-TelecareSubcription2016-Shiu.pdf

ASKER

I need this as a 2 page form but editable in word. Excel is not as user friendly to edit this form.

How can I achieve this?

PS I've tried this but have same issue as described in question:

1) Insert this as a spreadsheet document into word

Insert --> Table --> Excel Spreadsheet, then copy paste your excel file in word and manipulate directly in word

How can I achieve this?

PS I've tried this but have same issue as described in question:

1) Insert this as a spreadsheet document into word

Insert --> Table --> Excel Spreadsheet, then copy paste your excel file in word and manipulate directly in word

I don't think it is possible without changing the size of the table since it is 9" wide.

Here is the table in docx format, A4 size, landscape orientation (on 4 pages).

TelecareSubcription2016-Shiur-On-Sa.docx

Here is the table in docx format, A4 size, landscape orientation (on 4 pages).

TelecareSubcription2016-Shiur-On-Sa.docx

Take a look at the attached doc

2 pages, Portrait

Hope this is close to what you want :)

TelecareSubscription_Shiur-FORM.docx

2 pages, Portrait

Hope this is close to what you want :)

TelecareSubscription_Shiur-FORM.docx

ASKER

amazing xtermie

How did you achieve this - in broad terms...

PS Is there any way to get the formula to work towards the very bottom of the 2nd page?

Tx

Shaun

How did you achieve this - in broad terms...

PS Is there any way to get the formula to work towards the very bottom of the 2nd page?

Tx

Shaun

Glad it looks like what you want :)

FYI, I did it manually as I initially had inserted your spreadsheet as and Excel spreadsheets in Word (as per my suggestion), then manipulated in the spreadsheet, copied it as a Word table and changed size to Arial 9, which made the rows a bit narrower and it fitted in two pages

Sorry I do not understand what you mean when you write

FYI, I did it manually as I initially had inserted your spreadsheet as and Excel spreadsheets in Word (as per my suggestion), then manipulated in the spreadsheet, copied it as a Word table and changed size to Arial 9, which made the rows a bit narrower and it fitted in two pages

Sorry I do not understand what you mean when you write

*Is there any way to get the formula to work towards the very bottom of the 2nd page?*ASKER

Tx. If you look in the excel sheet page two there are prices and a formula to calculate the subtotal. Its the subtotal formula that needs to work...

Let me try to get table functions in Word to do that and get back to you

check the attached file

Just note that you need to add a value in all columns you want added, even if that is a zero (0)

TelecareSubscription_Shiur-FORM_v2.docx

Just note that you need to add a value in all columns you want added, even if that is a zero (0)

TelecareSubscription_Shiur-FORM_v2.docx

let us know if that works for you :)

If there are any more calculated fields let me know (didn't spot any other ones though)

If there are any more calculated fields let me know (didn't spot any other ones though)

ASKER

tx - is it possible to make the formula update automatically?

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Tx for the most helpful replies.

No prob...glad we could help :)

1) Insert this as a spreadsheet document into word

Insert --> Table --> Excel Spreadsheet, then copy paste your excel file in word and manipulate directly in word

2) Save as PDF (if to be used as a paper form - see attachment)

3) Clip an image of the application and paste onto Word (if to be used in paper format and not electronically)

In any case you have many rows and I do not think it would fit in 1 page, unless you made smaller fonts, which may not be readable...2 page form printed front and back would look good

TelecareSubcription2016-Shiur-On-Sa.pdf