1. #1
    Unregistered

    Facing Error during importing Excel Sheet into MS Word 2007 in Windows Vista

    I tried to import the Excel Sheet into MS Word on Windows Vista System. I just copied and tried to paste the excel sheet in the word document. It is not as expected. I need to know the solution to import excel sheet into the word document. Please, help me in providing the solution.



  2. #2
    Support Array
    Join Date
    Apr 2012
    Posts
    1,574

    Re: Facing Error during importing Excel Sheet into MS Word 2007 in Windows Vista

    STEP 1: Select the data in the excel sheet you want in the word document.
    STEP 2: Press “CTRL + C” so that the required data on the excel sheet is copied.
    STEP 3: Place the cursor in the word document where you want to paste the copied data.
    STEP 4: Click on the “Paste” Button on the top on the MS Word Document.
    STEP 5: Select “Paste Special” option from the Drop Down Menu.
    STEP 6: Select the Radio Button “Paste Link”.
    STEP 7: Select the option “Microsoft Excel Worksheet Object” from the list.
    STEP 8: Click on the “Ok” Button, your problem is solved.
    ~Support
    Community Manager

  3. #3
    ghanathey swetha Array
    Join Date
    Nov 2012
    Posts
    509

    Re: Facing Error during importing Excel Sheet into MS Word 2007 in Windows Vista

    Hi.
    To Copy worksheet data to a Word document follow the below steps:
    >>In Excel, select the worksheet data that you want to copy to a Word document.
    >>On the
    Home tab, in the Clipboard group, click Copy .(Keyboard shortcut You can also press CTRL+C).
    >>In the Word document, click where you want to paste the copied worksheet data.
    >>On the Home tab, in the Clipboard group, click Paste.(Keyboard shortcut You can also press CTRL+V).
    >>Click Paste Options next to the data, and then do one of the following:

    >To paste the data as a Word table, click Keep Source Formatting if you want to use the original format of the copied data, or click Match Destination Table Style if you want to use the document theme that is applied to the Word document.

    >To paste the data as a static picture, click Paste as Picture.

    >To paste a link to the Excel data so that the data in the Word document is updated when you change the original data in the Excel workbook, click Keep Source Formatting and Link to Excel or click Match Destination Table Style and Link to Excel.

    >To paste the data as text, with each row in a separate paragraph and with tab spaces separating the cell values, click Keep Text Only.

    Note:
    <<If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button, and then click Word Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box>>.
    <<If you paste the data into a Word table, the Paste Options button displays different paste options. You can insert the copied data as a nested table, merge it with the existing table, insert it as new rows in the existing table, overwrite the cells in the existing table, or paste it as a static picture>>.


    Thank you.

  4. #4
    aditya807 Array
    Join Date
    Dec 2012
    Posts
    279

    Re: Facing Error during importing Excel Sheet into MS Word 2007 in Windows Vista

    Hello

    To import Excel Sheet into MS word 2007 you need to follow some instruction..

    >>Open Excel sheet and than select data that you want to put in MS office.
    >>Press Ctrl + C key combination from keyboard.
    >>Click Home tab of the word document here you will see the Paste option just click on it.
    >>After clicking you will see the three option like Paste, Paste Special and Paste as Hyperlink.
    >>Click on Paste Special.
    >>After clicking the Paste special dialog box will open. Here choose paste as Microsoft Office Excel Worksheet Object option.
    >>The data will visible in word document as view as Excel sheet.

    Thank you try this.......

+ Reply to Thread

Similar Threads

  1. Replies: 16
    Last Post: 20-05-2013, 02:05 PM
  2. Replies: 1
    Last Post: 24-12-2012, 05:37 PM
  3. Replies: 4
    Last Post: 12-09-2012, 03:22 PM
  4. Replies: 10
    Last Post: 15-07-2012, 04:27 PM
  5. Replies: 4
    Last Post: 10-06-2012, 04:03 PM