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
shaunwinginAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

xtermieCommented:
You could try to:
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
Paul SauvéRetiredCommented:
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
shaunwinginAuthor Commented:
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Paul SauvéRetiredCommented:
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
xtermieCommented:
Take a look at the attached doc
2 pages, Portrait
Hope this is close to what you want :)
TelecareSubscription_Shiur-FORM.docx
shaunwinginAuthor Commented:
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
xtermieCommented:
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 Is there any way to get the formula to work towards the very bottom of the 2nd page?
shaunwinginAuthor Commented:
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...
xtermieCommented:
Let me try to get table functions in Word to do that and get back to you
xtermieCommented:
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
xtermieCommented:
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)
shaunwinginAuthor Commented:
tx - is it possible to make the formula update automatically?
xtermieCommented:
Word fields usually do not update automatically, as Word updates them on opening the document.
If you want to update them manually all you have to do is right click on the field and select Update field or select everything on the document and press F9.  Another option would be to add an onOpen and onClose macro to do this or have a macro that will update your fields when you use it (we can assign a button to it on the quick access toolbar or the ribbon for example).  In the attached document copy paste the following macro, save as docm and then the macro that can be assigned to a button (on the quick access toolbar I'd propose).
The macro is as follows:
Sub UpdMyCalcFields()
    ActiveDocument.Fields.Update
End Sub

Open in new window

To add a button that will do this to the quick access toolbar:
1) Right click the quick access toolbar and select More Commands...
2) In the Choose commands from drop down list, select Macros
3) In the macros list, select the UpdMyCalcFields() macro
4) Click Add
5) Click Modify and give it a symbol and a meaningful display name
6) Click OK to exit the modification of the button
7) Click OK to exit the Options window

Please note that since this is a form specific macro and is from your document the button wont work on any other document.

I've also enabled the option to update fields before printing in the attached document.
1) File, Options
2) Display, Printing Options
3) Check Update fields before printing
TelecareSubscription_Shiur-FORM_v3.docx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shaunwinginAuthor Commented:
Tx for the most helpful replies.
xtermieCommented:
No prob...glad we could help :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.