Excel Spreadsheets in MS Word

Excel spreadsheets in Word refer to tables, charts, or data ranges from Microsoft Excel that are inserted into a Word document, either as embedded objects (independent copies) or linked objects (connected to the original Excel file).

Key Features

• Embedding: Insert a copy of an Excel spreadsheet or chart that remains static unless edited in Word.
• Linking: Connect to an Excel file so changes in the source file update in Word.
• Editable Data: Modify spreadsheet data or charts directly in Word (for embedded objects).
• Formatting Options: Apply Word’s formatting to enhance the appearance of inserted spreadsheets.

Example: Embed an Excel sales table in a Word report to display quarterly results.

Steps to Insert and Manage Excel Spreadsheets in Word

Step 1: Insert an Excel Spreadsheet

Create a New Spreadsheet:

• Place the cursor in the Word document where you want the spreadsheet.
• Go to Insert > Table > Excel Spreadsheet.

• A blank Excel spreadsheet appears in Word, with Excel’s ribbon active for editing.

• Enter data, formulas, or formatting as you would in Excel, then click outside the spreadsheet to return to Word.

Insert an Existing Excel File:

• Go to Insert > Object > Object > Create from File tab.

• Click Browse, select the Excel file (e.g., “Sales_Data.xlsx”), and choose:
  • Insert: Embeds a static copy of the spreadsheet.
  • Link to File: Links to the original Excel file for automatic updates.

  

• Click OK to insert the spreadsheet.

Step 2: Insert an Excel Chart

Copy from Excel:

• In Excel, create or open a chart (e.g., a pie chart of expenses).

• Select the chart, copy it (Ctrl+C or Command+C), and paste it into Word (Ctrl+V or Command+V).
• Choose a paste option (right-click > Paste Options):
  • Keep Source Formatting: Retains Excel’s chart style.
  • Match Destination Formatting: Adapts to Word’s document style.
  • Link Data: Links the chart to the Excel file for updates.

  

Insert via Object:

• Go to Insert > Object > Object > Create from File.
• Select the Excel file containing the chart and choose Link to File (optional).
• Click OK to insert the chart.

Step 3: Edit Spreadsheets in Word

Edit Embedded Spreadsheet:

• Double-click the spreadsheet in Word to activate Excel’s editing tools.
• Modify data, formulas, or formatting (e.g., adjust cell values or apply borders).

• Click outside the spreadsheet to save changes within Word.

Edit Linked Spreadsheet:

• Open the original Excel file, make changes, and save; the Word document updates automatically if linked.

• Alternatively, right-click the spreadsheet in Word, select Linked Worksheet Object > Links, and click Open Source to edit the Excel file.

Step 4: Format and Manage Spreadsheets

Format in Word:

• Select the spreadsheet or chart, then use Word’s tools (Home > Font, Paragraph, or Picture Format) to adjust size, alignment, or borders.
• Wrap text around the object (Picture Format > Wrap Text > e.g., Tight or Square).

Update Linked Data:

• Right-click the linked spreadsheet, select Linked Worksheet Object > Links, and click Update Now to refresh data.

Resize or Move:

• Drag the object’s handles to resize or drag to reposition in the document.