How to Copy Excel Table into MS Word (that auto updates)
In this video, I will show you how to copy an excel table and paste it into Microsoft Word.
There are multiple ways to do this, and in this video, I'm going to show you three different ways to copy data from excel into Microsoft Word.
00:00 Intro
00:10 Copy Table from Excel to Word using Simple Copy Paste
01:55 Copy data from Excel to Word as a linked table/object
04:35 Embed Excel Table into Word as an Object (opens Excel within Word)
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzread.info...
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 78
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
The last paste option was useful for me. Brilliant tips on Excel. Thanks 🙏
That was really informative, I can't wait to start a free course with you on excel dashboard, I would love to learn from you as I'm willing to put everything I learn into work
Thank you so much!! Makes writing a lot less stressful
Perfectly done. Thank you for your knowledge!
This is perfect for my needs! Thank you!
Very useful, thanks for sharing Sumit! Great to see you back!
Awesome Sumit! Thanks for sharing these techniques :)) Thumbs up!!
Love these tutorial sessions.
Thank you my brother, very useful information and solving my questions!
Thank you for sharing these tips....
Great instructions - thank you!
Very informative. Thank you for the last two options which are very useful in working with both Excel and Word simultaneously.
@trumpexcel
3 жыл бұрын
Thanks for commenting Sekhar... Glad you found it useful :)
Thank you a lot for sharing your thoughts and tips 🙏 I have 3 files (excel, word, pdf) I need a way to update the pdf and the word files when I update the excel and I need it to write today’s date also when updated.. is there anyway I can do that?
Thank you alot! The video is really useful and easy to understand.
Super helpful - thank you!
How to copy large Excel spreadsheet in word Document?
Exactly what I was looking for thank you
Very useful, thank you!
Ma Sha Allah Very informative & useful. Thanks & keep the gud work going.
Thank you, Sir!!
Thanks Sumit... this is an interesting topic in Excel
very helpful. thanks for the tutorial.
Excellent Baba
Good to see you back again uploading video🤩
Excellent Explanation
Great Tutorial!!
Hi, greats tips. Can you save the word document so if you edit the table the word table doesn't change?
Thank you so much!!
Very useful and informative
Excellent tips.
Thank you very much.
Great information thanks you sir😊
THANK YOU!!!
Very very helpful
Amazing video I'm facing an issue in copying data from Excel to Word and vice versa. What would be the solution for this??
Very informative...
Hi Sumit, I have 3 worksheet tabs in 1 excel file. May I know if it is possible to show the 3 worksheets in word using the same embedded excel?
thank you!
very very useful sir
Thats awesome... Great 👍👍
Excellent explanation Sumit Bansal! I appreciated your videos. They are fantastic. Thank you!
@trumpexcel
3 жыл бұрын
Thanks Ivan... Glad you liked it :)
@SAKTHIVEL-cm5ej
3 жыл бұрын
Nice and useful one. Expect more videos like this, frequently. Thanks friend.
What if i want to add few rows? Will the table in word changes too?
Thank you
thanks
❤❤❤ 🙏thanks bro
Fantastic
Can you please show how to copy a process flow chart.. That is made with text box and arrows.. To ms word
Nice sir
Awesome
Hi Sumit. Thanks great video Do you know if it's possible to import a table as a range into word. So when you add rows in excel, the table is Word expands too?
@trumpexcel
3 жыл бұрын
I tried doing it, but it didn't work. In all the cases, it sticks to the original range that was copied
Sir, please make video on how to clean all symbols from a cell
What can you do if the page has Many columns and you want to make them appear in the same page
Sumit thanks worth watching all your videos. Always enlighten me with new things. Can you please also add video on Macro ?
@SyedUsman
3 жыл бұрын
Hi Pls check my videos on VBA. Feedback would be nice. Thanks
Nice
How to make a button that will automatically copy something in execel that will allow me to paste in word?
Sumit, I want to do two condition criteria lookup to get a value, date and text are among these two condition to get a value
@CharlesPandir
3 жыл бұрын
Please help from two days I am using all lookup and index match formula but nothing working....pl help
Grate
In paste option not hear destination style How to use
Well. This method is not dynamic when new rows are added in the table???
@trumpexcel
3 жыл бұрын
Unfortunately not. It only updates changes in the current range.
What i need is to reflect text or number From ms word to ms word only Similar to excell "=" Sign
Very clear. However, around 5:56 in your video, when you go to edit the embedded spreadsheet, Excel opens for you with a reference to the source Word file. When i double-click the embedded spreadsheet, the worksheet opens for editing, but not in Excel. Instead, at this point, the edited spreadsheet I'm trying to close appears distorted and I cannot continue editing the Word file where I need to because an odd, ghosted spreadsheet is covering up part of my Word document and there seem to be two Excel spreadsheets displayed, neither of which is readable. My workaround is to close the Word file, reopen it, and continue where I left off. Any thoughts appreciated.
@mhmtglsn1801
2 жыл бұрын
Have you found a solution to this? Im expriencing the same thing.
@arlenezimmerly718
2 жыл бұрын
@@mhmtglsn1801 This is a workaround, not a solution, but it works: WORKAROUND to edit an embedded Excel Worksheet Object in Word: Right-click the embedded Excel object, click Worksheet Object, Open-the object opens in a separate Excel window; edit the worksheet; close the worksheet with X (top right).
😮
Sir why you are not uploading videos regularly please sir upload the videos regularly
@trumpexcel
3 жыл бұрын
I have the next three videos done and scheduled. Will try and stick to a weekly video schedule
Which version of ms office?
@trumpexcel
3 жыл бұрын
I am using Microsoft 365, but this should also work for all other versions of Excel and Word
@ninihomecooking
Жыл бұрын
In Microsoft 2010 Double click can't open to excel file. How can fix it?
Thank you