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

  • @trumpexcel
    @trumpexcel3 жыл бұрын

    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

  • @info2satish
    @info2satish2 жыл бұрын

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

  • @samahsaeed1261
    @samahsaeed12612 жыл бұрын

    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
    @davia-f22072 жыл бұрын

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

  • @ReRe-cg5ml
    @ReRe-cg5ml2 жыл бұрын

    Perfectly done. Thank you for your knowledge!

  • @sherrirobinson3853
    @sherrirobinson38532 жыл бұрын

    This is perfect for my needs! Thank you!

  • @YouExcelTutorials
    @YouExcelTutorials3 жыл бұрын

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

  • @wayneedmondson1065
    @wayneedmondson10653 жыл бұрын

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

  • @tedmoy
    @tedmoy Жыл бұрын

    Love these tutorial sessions.

  • @Hary_Sumantri
    @Hary_Sumantri Жыл бұрын

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

  • @CoinsTokens
    @CoinsTokens3 жыл бұрын

    Thank you for sharing these tips....

  • @ginacasados63
    @ginacasados632 жыл бұрын

    Great instructions - thank you!

  • @sekhar6106
    @sekhar61063 жыл бұрын

    Very informative. Thank you for the last two options which are very useful in working with both Excel and Word simultaneously.

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Thanks for commenting Sekhar... Glad you found it useful :)

  • @MrHatem55
    @MrHatem553 жыл бұрын

    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?

  • @TaiHuynh.2002
    @TaiHuynh.20027 ай бұрын

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

  • @made4purpose
    @made4purpose3 ай бұрын

    Super helpful - thank you!

  • @gangadevichettri1360
    @gangadevichettri1360 Жыл бұрын

    How to copy large Excel spreadsheet in word Document?

  • @bjarnisvanurbirgisson4147
    @bjarnisvanurbirgisson4147 Жыл бұрын

    Exactly what I was looking for thank you

  • @oddandrerustad4363
    @oddandrerustad4363 Жыл бұрын

    Very useful, thank you!

  • @kaleemmohammed
    @kaleemmohammed Жыл бұрын

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

  • @InsightfulJourney123
    @InsightfulJourney1233 жыл бұрын

    Thank you, Sir!!

  • @tedolshansky286
    @tedolshansky2863 жыл бұрын

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

  • @Wucc2caz
    @Wucc2caz2 жыл бұрын

    very helpful. thanks for the tutorial.

  • @papuraja9279
    @papuraja92793 жыл бұрын

    Excellent Baba

  • @keshavbhushal7389
    @keshavbhushal73893 жыл бұрын

    Good to see you back again uploading video🤩

  • @venkatsapsd1615
    @venkatsapsd16152 жыл бұрын

    Excellent Explanation

  • @yuliataushanova4804
    @yuliataushanova48042 жыл бұрын

    Great Tutorial!!

  • @chrisbarker5336
    @chrisbarker53362 жыл бұрын

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

  • @hazemali382
    @hazemali3822 жыл бұрын

    Thank you so much!!

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

    Very useful and informative

  • @philipjose8092
    @philipjose80927 ай бұрын

    Excellent tips.

  • @sohrabali6080
    @sohrabali60803 жыл бұрын

    Thank you very much.

  • @prathameshjoshi3486
    @prathameshjoshi3486 Жыл бұрын

    Great information thanks you sir😊

  • @iloveamerica007
    @iloveamerica0072 жыл бұрын

    THANK YOU!!!

  • @parulchauhan919
    @parulchauhan9193 жыл бұрын

    Very very helpful

  • @mohammedameerahmed2250
    @mohammedameerahmed22502 жыл бұрын

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

  • @msabhilash01
    @msabhilash013 жыл бұрын

    Very informative...

  • @jasminecheo5893
    @jasminecheo58932 жыл бұрын

    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?

  • @MarilenaMasekCarmen
    @MarilenaMasekCarmen3 жыл бұрын

    thank you!

  • @52ramiyer67
    @52ramiyer6711 ай бұрын

    very very useful sir

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

    Thats awesome... Great 👍👍

  • @IvanCortinas_ES
    @IvanCortinas_ES3 жыл бұрын

    Excellent explanation Sumit Bansal! I appreciated your videos. They are fantastic. Thank you!

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Thanks Ivan... Glad you liked it :)

  • @SAKTHIVEL-cm5ej

    @SAKTHIVEL-cm5ej

    3 жыл бұрын

    Nice and useful one. Expect more videos like this, frequently. Thanks friend.

  • @dickyas342
    @dickyas3422 жыл бұрын

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

  • @jamesdowey6943
    @jamesdowey69434 ай бұрын

    Thank you

  • @pranavsingh5235
    @pranavsingh523524 күн бұрын

    thanks

  • @prakasankondipparambil8836
    @prakasankondipparambil88363 ай бұрын

    ❤❤❤ 🙏thanks bro

  • @GSS-ex5ky
    @GSS-ex5ky11 ай бұрын

    Fantastic

  • @atmikasingh443
    @atmikasingh4432 жыл бұрын

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

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 Жыл бұрын

    Nice sir

  • @sriveenahariharan6273
    @sriveenahariharan6273 Жыл бұрын

    Awesome

  • @DerekMorgan1
    @DerekMorgan13 жыл бұрын

    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

    @trumpexcel

    3 жыл бұрын

    I tried doing it, but it didn't work. In all the cases, it sticks to the original range that was copied

  • @deepakmittalofficial
    @deepakmittalofficial3 жыл бұрын

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

  • @MosesMaffula
    @MosesMaffula4 ай бұрын

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

  • @rutujathalkar2630
    @rutujathalkar26303 жыл бұрын

    Sumit thanks worth watching all your videos. Always enlighten me with new things. Can you please also add video on Macro ?

  • @SyedUsman

    @SyedUsman

    3 жыл бұрын

    Hi Pls check my videos on VBA. Feedback would be nice. Thanks

  • @AzizRehman0111
    @AzizRehman01112 жыл бұрын

    Nice

  • @babybruce8256
    @babybruce8256 Жыл бұрын

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

  • @CharlesPandir
    @CharlesPandir3 жыл бұрын

    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

    @CharlesPandir

    3 жыл бұрын

    Please help from two days I am using all lookup and index match formula but nothing working....pl help

  • @ajaypande6749
    @ajaypande6749 Жыл бұрын

    Grate

  • @puppalamadhulatha5219
    @puppalamadhulatha5219 Жыл бұрын

    In paste option not hear destination style How to use

  • @infocell-ab
    @infocell-ab3 жыл бұрын

    Well. This method is not dynamic when new rows are added in the table???

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    Unfortunately not. It only updates changes in the current range.

  • @BattleSymphony349
    @BattleSymphony3492 жыл бұрын

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

  • @arlenezimmerly718
    @arlenezimmerly7182 жыл бұрын

    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

    @mhmtglsn1801

    2 жыл бұрын

    Have you found a solution to this? Im expriencing the same thing.

  • @arlenezimmerly718

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

  • @HsaiLeng2023
    @HsaiLeng2023 Жыл бұрын

    😮

  • @fayazmuhammad5983
    @fayazmuhammad59833 жыл бұрын

    Sir why you are not uploading videos regularly please sir upload the videos regularly

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    I have the next three videos done and scheduled. Will try and stick to a weekly video schedule

  • @shouryaaSomani01
    @shouryaaSomani013 жыл бұрын

    Which version of ms office?

  • @trumpexcel

    @trumpexcel

    3 жыл бұрын

    I am using Microsoft 365, but this should also work for all other versions of Excel and Word

  • @ninihomecooking

    @ninihomecooking

    Жыл бұрын

    In Microsoft 2010 Double click can't open to excel file. How can fix it?

  • @thebiodunoduwole
    @thebiodunoduwole7 ай бұрын

    Thank you