Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Create hyperlink with VLOOKUP in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel MMULT Function
  • How to retrieve first match between two ranges in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • Conditional Formatting Rules in Excel
  • Number and Text Filters Examples in Excel
  • Subtotal function in Excel
  • How to Create Area Chart in Excel
  • Reverse List in Excel

Data Validation Examples

  • Excel Data validation allow weekday only
  • Excel Data validation only dates between
  • Prevent invalid data entering in specific cells
  • Excel Data validation must begin with
  • Excel Data validation must contain specific text

How to share Excel data with Word documents and other files

by

Why do you need to share to data in another file format?

Most of the time, you’ll simply need to paste static Excel data in a Word document

Other times you may want to paste data and then click Linked to Worksheet Object.

1. Select the Excel data.

2. Right click, and then click Copy (or press CTRL + c).

3. Open a Word document.

Worked Example:   How to import data from Access database into Excel

4. Press CTRL + v.

5. Click the icon in the upper left corner of the table and add borders.

Result.

Note: To delete the table, right click the icon in the upper left corner, and then click Delete Table.

Paste Link

You can also link the source data in Excel with the destination data in Word. If you change the data in Excel, the data in Word is updated automatically.

Worked Example:   Excel Import/Export Text Files

1. Repeat steps 1 to 3 above.

2. In Word, on the Home tab, in the Clipboard group, click Paste.

3. Click Paste Special.

 The Paste Special dialog box appears.

4. Click Paste link, HTML Format.

5. Click OK.

6. Click the icon in the upper left corner of the table and add borders.

Worked Example:   Convert an Excel File to PDF

Result.

7. Change the Excel data.

Result.

Note: In Word, right click the icon in the upper left corner of the table, and then click Linked Worksheet Object, Links to launch the Links dialog box. Here, you can break the link, change the location of the Excel file, etc.

Post navigation

Previous Post:

Excel Custom Number Format with Leading Zeros, Add Text, Colors Example

Next Post:

How to set or clear a print area in Excel Worksheet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Find function vs Search function in Excel
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • How to strip numeric characters from cell in Excel
  • Replace one character with another in Excel
  • How to find and replace multiple values at same time in Excel
  • Sum through n months in Excel
  • How to calculate percent of year complete in Excel
  • Display the current date and time in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Get month from date in Excel
  • ODDFYIELD function: Description, Usage, Syntax, Examples and Explanation
  • PMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate payment periods for loan in Excel
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan principal payments in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles