How to Copy Excel Table into MS Word (that auto updates)

Рет қаралды 222,368

Күн бұрын

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: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 78

@info2satish 2 жыл бұрын

The last paste option was useful for me. Brilliant tips on Excel. Thanks 🙏

@samahsaeed1261 2 жыл бұрын

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

@davia-f2207 2 жыл бұрын

Thank you so much!! Makes writing a lot less stressful

@ReRe-cg5ml 2 жыл бұрын

Perfectly done. Thank you for your knowledge!

@sherrirobinson3853 2 жыл бұрын

This is perfect for my needs! Thank you!

@CoinsTokens 3 жыл бұрын

Thank you for sharing these tips....

@sekhar6106 3 жыл бұрын

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 :)

@tedmoy Жыл бұрын

Love these tutorial sessions.

@YouExcelTutorials 3 жыл бұрын

Very useful, thanks for sharing Sumit! Great to see you back!

@ginacasados63 2 жыл бұрын

Great instructions - thank you!

@wayneedmondson1065 3 жыл бұрын

Awesome Sumit! Thanks for sharing these techniques :)) Thumbs up!!

@Hary_Sumantri Жыл бұрын

Thank you my brother, very useful information and solving my questions!

@InsightfulJourney123 3 жыл бұрын

Thank you, Sir!!

@TaiHuynh.2002 7 ай бұрын

Thank you alot! The video is really useful and easy to understand.

@oddandrerustad4363 Жыл бұрын

Very useful, thank you!

@made4purpose 3 ай бұрын

Super helpful - thank you!

@bjarnisvanurbirgisson4147 Жыл бұрын

Exactly what I was looking for thank you

@kaleemmohammed Жыл бұрын

Ma Sha Allah Very informative & useful. Thanks & keep the gud work going.

@MrHatem55 3 жыл бұрын

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?

@venkatsapsd1615 2 жыл бұрын

Excellent Explanation

@Wucc2caz 2 жыл бұрын

very helpful. thanks for the tutorial.

@hazemali382 2 жыл бұрын

Thank you so much!!

@sohrabali6080 3 жыл бұрын

Thank you very much.

@philipjose8092 8 ай бұрын

Excellent tips.

@tedolshansky286 3 жыл бұрын

Thanks Sumit... this is an interesting topic in Excel

@yuliataushanova4804 2 жыл бұрын

Great Tutorial!!

@Lotus-gl1yl Жыл бұрын

Very useful and informative

@keshavbhushal7389 3 жыл бұрын

Good to see you back again uploading video🤩

@prathameshjoshi3486 Жыл бұрын

Great information thanks you sir😊

@iloveamerica007 2 жыл бұрын

THANK YOU!!!

@papuraja9279 3 жыл бұрын

Excellent Baba

@jamesdowey6943 5 ай бұрын

Thank you

@msabhilash01 3 жыл бұрын

Very informative...

@parulchauhan919 3 жыл бұрын

Very very helpful

@MarilenaMasekCarmen 3 жыл бұрын

thank you!

@chrisbarker5336 2 жыл бұрын

Hi, greats tips. Can you save the word document so if you edit the table the word table doesn't change?

@susenDeshmukh-zt7so Жыл бұрын

Thats awesome... Great 👍👍

@52ramiyer67 Жыл бұрын

very very useful sir

@IvanCortinas_ES 3 жыл бұрын

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.

@jasminecheo5893 2 жыл бұрын

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?

@gangadevichettri1360 Жыл бұрын

How to copy large Excel spreadsheet in word Document?

@pranavsingh5235 Ай бұрын

thanks

@prakasankondipparambil8836 3 ай бұрын

❤❤❤ 🙏thanks bro

@mohammedameerahmed2250 3 жыл бұрын

Amazing video I'm facing an issue in copying data from Excel to Word and vice versa. What would be the solution for this??

@GSS-ex5ky 11 ай бұрын

Fantastic

@DerekMorgan1 3 жыл бұрын

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

@sriveenahariharan6273 Жыл бұрын

Awesome

@pandharinathjoshi6565 Жыл бұрын

Nice sir

@dickyas342 2 жыл бұрын

What if i want to add few rows? Will the table in word changes too?

@AzizRehman0111 2 жыл бұрын

Nice

@ajaypande6749 Жыл бұрын

Grate

@rutujathalkar2630 3 жыл бұрын

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

@atmikasingh443 2 жыл бұрын

Can you please show how to copy a process flow chart.. That is made with text box and arrows.. To ms word

@MosesMaffula 4 ай бұрын

What can you do if the page has Many columns and you want to make them appear in the same page

@CharlesPandir 3 жыл бұрын

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

@babybruce8256 Жыл бұрын

How to make a button that will automatically copy something in execel that will allow me to paste in word?

@deepakmittalofficial 3 жыл бұрын

Sir, please make video on how to clean all symbols from a cell

@infocell-ab 3 жыл бұрын

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.

@puppalamadhulatha5219 Жыл бұрын

In paste option not hear destination style How to use

@arlenezimmerly718 2 жыл бұрын

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).

@BattleSymphony349 2 жыл бұрын

What i need is to reflect text or number From ms word to ms word only Similar to excell "=" Sign

@trumpexcel 3 жыл бұрын

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