How to Copy Excel Table into MS Word (that auto updates)
Вставка
- Опубліковано 2 сер 2024
- 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: ua-cam.com/users/trumpexc...
#Excel #ExcelTips #ExcelTutorial
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
The last paste option was useful for me. Brilliant tips on Excel. Thanks 🙏
Perfectly done. Thank you for your knowledge!
Very useful, thanks for sharing Sumit!
Great to see you back!
Very informative.
Thank you for the last two options which are very useful in working with both Excel and Word simultaneously.
Thanks for commenting Sekhar... Glad you found it useful :)
Awesome Sumit! Thanks for sharing these techniques :)) Thumbs up!!
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
This is perfect for my needs! Thank you!
Thank you so much!!
Makes writing a lot less stressful
Thank you for sharing these tips....
Love these tutorial sessions.
Great instructions - thank you!
Ma Sha Allah
Very informative & useful.
Thanks & keep the gud work going.
Thank you my brother, very useful information and solving my questions!
Very useful, thank you!
Thank you alot! The video is really useful and easy to understand.
Good to see you back again uploading video🤩
Super helpful - thank you!
Exactly what I was looking for thank you
very helpful. thanks for the tutorial.
Thank you, Sir!!
Thanks Sumit... this is an interesting topic in Excel
Excellent Explanation
Great Tutorial!!
Very useful and informative
Excellent explanation Sumit Bansal! I appreciated your videos. They are fantastic. Thank you!
Thanks Ivan... Glad you liked it :)
Nice and useful one. Expect more videos like this, frequently. Thanks friend.
Thank you so much!!
Excellent tips.
Thank you very much.
Very informative...
Great information thanks you sir😊
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?
Excellent Baba
Very very helpful
Thats awesome... Great 👍👍
THANK YOU!!!
thank you!
thanks
Thank you
very very useful sir
❤❤❤ 🙏thanks bro
Hi, greats tips. Can you save the word document so if you edit the table the word table doesn't change?
Fantastic
Awesome
How to copy large Excel spreadsheet in word Document?
Amazing video
I'm facing an issue in copying data from Excel to Word and vice versa.
What would be the solution for this??
Sumit thanks worth watching all your videos. Always enlighten me with new things. Can you please also add video on Macro ?
Hi Pls check my videos on VBA. Feedback would be nice. Thanks
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?
I tried doing it, but it didn't work. In all the cases, it sticks to the original range that was copied
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?
Nice
Nice sir
Grate
What if i want to add few rows? Will the table in word changes too?
Can you please show how to copy a process flow chart.. That is made with text box and arrows.. To ms 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
Please help from two days I am using all lookup and index match formula but nothing working....pl help
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
How to make a button that will automatically copy something in execel that will allow me to paste in word?
😮
In paste option not hear destination style
How to use
Well. This method is not dynamic when new rows are added in the table???
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.
Have you found a solution to this? Im expriencing the same thing.
@@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
I have the next three videos done and scheduled. Will try and stick to a weekly video schedule
Which version of ms office?
I am using Microsoft 365, but this should also work for all other versions of Excel and Word
In Microsoft 2010 Double click can't open to excel file. How can fix it?
Thank you