Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • How to Block/Remove Ads on Chrome, IE and Firefox Computer Tips
  • How Archive in Gmail Works Google Software/Tips
  • How To Convert a PDF To Google Doc Format Google Software/Tips
  • How to reset your AirPods and AirPods Pro Tutorials
  • The male army height weight chart 2018

    The army height weight chart only for male or man in 2018. For more information visit : Army Maximum Body Fat Standards for Men Age 17-20 = 20 %

  • How To Change Your Spotify Username Computer Tips
  • Top 5 Free Online Image Editor Like Photoshop How-To
  • How to Enable Quick Launch Toolbar in Windows XP/7/8.1 Computer Tips

How to Insert an Excel Worksheet into a Word Doc

Posted on October 7, 2020 By bilal 1983 No Comments on How to Insert an Excel Worksheet into a Word Doc

If you have ever wanted to include data from an Excel file in a Word document, perhaps you just copied the data from Excel and pasted it into Word.

While this works, there are a number of limitations. One of the most important is that if the original data file ever changes, your Word document will never reflect those changes.

How to Insert an Excel Worksheet into a Word Doc

If any of these issues are important to you, there are better ways to insert an Excel sheet into a Word document. In this article, you will learn all the possible methods, as well as their pros and cons.

Insert Excel worksheet into Word document by copying / pasting

Of course, the fastest and easiest way to transfer data from an Excel sheet to a Word document is to simply use the Windows copy and paste feature.

To do this, open an Excel file with data, select the cells containing the data you want to add to the document, and press Ctrl-C on your keyboard.

How to Insert an Excel Worksheet into a Word Doc

If you place your cursor in a Word document and press Ctrl-V on your keyboard, you will notice that the cells you selected appear perfectly in the Word document.

– /

How to Insert an Excel Worksheet into a Word Doc

There are a few caveats here.

The imported Excel cells become a Microsoft Word table. Therefore, if you want to format this table after importing the data, you cannot use Excel formulas or other Excel formatting functions.

The second problem is that it only works well for small data tables. If you want to copy and paste data further down the Excel table, you will lose the headers.

How to Insert an Excel Worksheet into a Word Doc

This is actually not very useful. In this case, you will want to try one of the options below to insert the Excel sheet into the Word document instead.

  • Pros: fast and convenient, good for small tables.
  • Cons: the original data is not updated and headers are lost in large tables, the original formatting is not completely preserved.

Insert the Excel worksheet as an embedded object

If you want to be able to use Excel functions and other Excel formatting functions later to update the table, it is better to paste the Excel data as an embedded object.

To do this:

  1. Select the section of the Excel sheet that you want to copy and press Ctrl-C.
  2. In Microsoft Word, place the cursor where you want to insert the data table.
  3. On the main menu, click the down arrow under Paste and select Paste Special.

  1. You will see the Paste Special dialog box. Select the Microsoft Excel worksheet object and click OK.

How to Insert an Excel Worksheet into a Word Doc

How to Insert an Excel Worksheet into a Word Doc

This will paste the copied cells into your Word document. The new object will not behave at all like a Microsoft Word table, and you will not be able to edit data inside the table from Microsoft Word.

How to Insert an Excel Worksheet into a Word Doc

However, you can resize the entire object to fit within the margins of your document.

If you still want to edit the data, just double-click the object and it will open the entire original spreadsheet in Microsoft Excel.

Please be aware that this is a brand new Excel file (not the original). But any changes you make and save in this Excel file will be updated in your Word document.

How it works:

  • When you use an embedded object to paste Excel data, Word creates a copy of the original Excel file.
  • When you double-click an object, Word opens the copied file for editing.
  • You can use all of Excel’s features and formatting capabilities to make any changes.

What’s nice about this approach is that the original formatting is not changed during conversion to a Microsoft Word table. It also provides you with an “attached” Excel data file with the original data file in case you ever want to change the data or add additional data to the inserted Excel object in Word.

  • Pros: Fast and convenient, suitable for large tables and retains original formatting.
  • Cons: not updated with source data and cannot edit the table directly in Word.

Insert an Excel worksheet as a linked object

The best way to insert an Excel sheet into a Word document is to insert it as a linked embedded object

The procedure for this is identical to that described above, except that in the Paste Special window, you must select the Paste Link check box.

How to Insert an Excel Worksheet into a Word Doc

You will see that the pasted Excel data looks the same as in the previous section, but there is a significant difference.

If you go back to the original Excel file and make any changes to the data in any of the inserted cells, you will see that those changes are immediately updated in your Microsoft Word document.

The changes take effect in Word even if you haven’t saved the changes to the Excel file. Basically, it allows you to view, in real time, changes from Word that someone is actively making to any Excel file.

If you want, you can use this feature to create a real-time dashboard in Word to display any important data points that someone might change in the Excel file.

  • Pros: fast and convenient, suitable for large tables, retains original formatting and instantly refreshes with the original data being updated.
  • Cons: Can’t edit table directly in Word.

As you can see, there are several ways to insert an Excel sheet into a Word document. The option you choose depends only on how you are going to use this data and whether you want to see or use changes to the data in the original Excel file.

How did you import Excel data into Word before? Did you have any problems when you tried to do this? Share your experience in the comments section below.

–

Share this:

  • Facebook
  • X
Office Tips

Post navigation

Previous Post: How to Make a Fillable Google Docs Form With Tables
Next Post: Best Video Editing Software for YouTube Videos

Related Posts

  • Change the Default Margins Used in New Word Documents Office Tips
  • How to Delete A Microsoft Word Page Office Tips
  • Sum a Table Column in Word Office Tips
  • How To Set Up Read Receipts In Outlook Office Tips
  • 2 Ways to Use Excel’s Transpose Function Office Tips
  • How to Customize Word’s Paste Function Office Tips

Leave a Reply Cancel reply

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

Archives

  • November 2023
  • October 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • – 436
  • – 939
  • 1xbet Azerbaycan,1xbet az merc saytı, en yaxsi bukmeker 1xbet Azerbaycan merc oyunlari, 1xbet az, Azerbaycan merc saytlari – 280
  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • Calculator
  • Computer Tips
  • Cool Websites
  • Dasinmaz emlak elanlari, ev elanlari, ev alqi satqisi, kiraye evler, torpaq, obyekt, bina, bina ev, mənzil, villa, kreditle satilan evler – 814
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorial
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • бонусы до 250%, официальный сайт в Узбекистане – 69
  • Мостбет Уз Ставки на спорт и казино в букмекерской конторе Mostbet Uz – 527
  • How To Change IP Address in Windows
  • Приложение Mostbet UZ скачать на Андроид APK, Айфон IOS
  • Приложение Mostbet UZ скачать на Андроид APK, Айфон IOS
  • How To Backup Your Android Phone And Tablet (No Root)
  • 6 Useful Tips to Free Up Space on Your Android Device
DMCA.com Protection Status

Recent Posts

  • MostBet AZ Most Bet Casino Qeydiyyat, Yukle Android App
  • Xarici bukmeykerlər azərbaycanlıların pulunu necə oğurlayır? Birinci yazı
  • Sağlamlığın real məkanı
  • Dünyada müasir tendensiya kimi qumar oyunlarının leqallaşdırılması
  • How do I Find Release Date of Any Google Play App

Recent Comments

  1. Instagram stories not working/loading? Try These 9 Fixes on Can’t update PS5 system software? Try These 10 Fixes
  2. How to Link to a Specific Part Of A Webpage & Share it on Best PDF to Word Converter Online (Free Without Email)
  3. See What’s Taking up Space on Your Hard Drive on 7 best 3D scanning apps for Android and iOS
  4. Make your Devices Read Out Text, With Text to Speech on 9 Best 10K Running Apps for 2023
  5. How to Find your Router’s IP Address on How to Fix Apple CarPlay Not Working? 7 Possible ways
  • How to Remove Snap From Ubuntu How-To
  • How to Download Netflix Movies on Mac Tutorials
  • Hide Text and Show Hidden Text in Word MS Office Tips
  • iPod Shuffle Bricked, Not Charging? Help Desk
  • How to Copy Files and Folders in Google Drive How-To
  • How to Troubleshoot Audio Issues in Windows 7 and Vista Windows 7
  • How To Set Up “Do Not Disturb” On iOS iOS
  • The 4 Best Wearable Translators Product Reviews

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version