CARA MEMASUKAN FILE EXCEL KE WORD DI WPS OFFICE

When it comes to creating documents and reports, Microsoft Word is the go-to choice for many professionals. However, sometimes, we may need to include data or tables from Microsoft Excel into our Word documents. In this article, we will learn how to insert Excel tables into Word documents using different methods.

Method 1: Using Copy and Paste

The easiest and simplest way to insert an Excel table into a Word document is by using copy and paste. Here is how you can do it:

1. Open both the Excel file and the Word document.
2. Select the cell(s) or table in Excel that you want to insert into Word.
3. Press Ctrl+C (Windows) or Command+C (Mac) to copy the selected cells or table.
4. Switch to the Word document and place the cursor where you want to insert the Excel table.
5. Press Ctrl+V (Windows) or Command+V (Mac) to paste the Excel table into the Word document.

You can also use the Paste Options button to choose how you want to paste the table. For example, you can choose to keep the source formatting, merge formatting, or just paste the text without formatting.

Method 2: Using the Insert Table Button

If you want more control over how the Excel table is inserted into the Word document, you can use the Insert Table button. Here is how:

1. Open the Word document where you want to insert the Excel table.
2. Click on the Insert tab in the Word ribbon.
3. Click on the Table button and select Insert Table.
4. In the Insert Table dialog box, enter the number of rows and columns you want for the table.
5. Check the box next to “Insert table with headers” if your Excel table has headers.
6. Click OK to insert the empty table into the Word document.
7. Switch to Excel and select the cells or table you want to insert.
8. Press Ctrl+C (Windows) or Command+C (Mac) to copy the selected cells or table.
9. Switch back to Word and click on the table to select it.
10. Press Ctrl+V (Windows) or Command+V (Mac) to paste the Excel table into the Word table.

Once you have inserted the Excel table into the Word document, you can format the table and customize it as per your requirements.

Method 3: Using Excel Object

If you want to keep the Excel table linked to the Word document so that any changes made to the Excel table will automatically update in the Word document, you can use the Excel Object method. Here’s how:

1. Open the Word document where you want to insert the Excel table.
2. Click on the Insert tab in the Word ribbon.
3. Click on the Object button in the Text group.
4. In the Object dialog box, select “Create from file” and click on “Browse” to select the Excel file.
5. Check the box next to “Link to file” to create a linked object, or leave it unchecked to create an embedded object.
6. Click on OK to insert the Excel object into the Word document.
7. Once inserted, you can double-click on the Excel object to open the Excel file in the original program and make any changes.
8. Save and close the Excel file.
9. The changes made to the Excel object will be updated in the Word document.

FAQ

Q. Can I edit the Excel table in Word after inserting it?

A. Yes, you can edit the Excel table in Word after inserting it. However, if you have pasted the table using the first method, the table will not be linked to the original Excel file, and the changes made in Word will not be updated in Excel. If you have used the second or third method, the table is linked to the original Excel file, and any changes made in Word will be updated in Excel.

Q. Can I insert multiple Excel tables in one Word document?

A. Yes, you can insert multiple Excel tables in one Word document. Simply repeat the steps for each table you want to insert.

Conclusion

Inserting Excel tables into Word documents is a common task for many professionals. With the above methods, you can easily insert Excel tables into Word and customize them as per your requirements. If you want to keep the tables linked to the original Excel files, make sure to use the Excel Object method.