Copying Excel data with Format into Word

    Hi,


    Please please please help me with this....


    I need to copy a specific range of cells (a report) with the same formatting and view as in Excel onto Word


    I am doing an insert Object but the problem is half of the columns to the right are truncated(I need A4:AZ63). If I am doing an insert file with the Range specified the whole formatting is lost.


    I need to fit the entire range on one Word page with the exact formatting and view as in Excel. Please help me with a fix for this. I am putting my hands together for help... please please please.


    THANKS in Anticipation.


    Regards
    Vk Pilla

    Re: Copying Excel data with Format into Word


    I don't think you'll ever get Word to see so many columns.
    However, if you format it in Excel to fit to one page width, and the print preview looks good in Excel, then you should be able to copy it over to Word and paste as link.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login