How to put an EXCEL table into word. Editable Table (2019)

แชร์
ฝัง
  • เผยแพร่เมื่อ 21 ธ.ค. 2024

ความคิดเห็น • 126

  • @robsretrorides796
    @robsretrorides796 3 ปีที่แล้ว +1

    As a user of Ubuntu for 4 years, and now doing a BSc in Computing, requiring the use of majority Microsoft products, which i haven't used since 2013, it is a bit of shock from libre office to MS office. This video is an absolute life saver, thank you!

  • @leonardoz.wongbae9165
    @leonardoz.wongbae9165 2 ปีที่แล้ว +1

    Thanks so kindly. What if the table from the excel sheet is so large, how do you adjust it in word?

    • @LisaDoe
      @LisaDoe  2 ปีที่แล้ว

      You can decrease your margins in word or reduce the font size of your excel table :))

  • @agbe2902
    @agbe2902 ปีที่แล้ว

    Excellent 4 year old news 👏🏾 👍🏾
    This will save me a lot of frustration 😂🤣😂

    • @LisaDoe
      @LisaDoe  ปีที่แล้ว

      Glad to hear it!

  • @Lisa_0519
    @Lisa_0519 4 ปีที่แล้ว +9

    Thank you so much! After a long struggle, you assisted me in saving my Chapter 3!

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว +1

      I'm so glad I was able to help. Have a great day.

  • @abirsarkar7075
    @abirsarkar7075 4 ปีที่แล้ว +2

    Thank you for this.
    I have a question, is it possible that we make changes in word and that change appears in the table in excel?

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Not that I'm aware of.

  • @shawnhopper8253
    @shawnhopper8253 4 ปีที่แล้ว

    In the third example, do you lose the table in Word if you were to delete or lose the excel file that the data was originally in?

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Not if you save the Word Doc. I don't think you can then re-edit the table if you delete the excel document though.

  • @bonolososha8683
    @bonolososha8683 3 ปีที่แล้ว +4

    Thanks alot !!!😭you have no idea how much you've helped me. I've been literally wanting this kind of explanation you made it so easy 😩💃

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว +2

      Really glad you managed to solve the problem and insert the table you needed :)

  • @fallsnative
    @fallsnative 4 ปีที่แล้ว +7

    This was amazing! You saved me so much time, effort and grief just with the few seconds of how to paste as an image, THANK YOU!!

  • @garydeane9783
    @garydeane9783 4 ปีที่แล้ว +1

    Can I copy tables and lose the lines once copied. Currently the text is jumbled up when I use text only .

  • @The_Accountern
    @The_Accountern 2 ปีที่แล้ว

    SIZE OF MY EXCEL TABLE IS SAME BUT I HAVE TO IMPORT IT INTO THE PORTRAIT LAYOUT RATHER THAN LANDSCAPE KINDLY HELP

    • @LisaDoe
      @LisaDoe  2 ปีที่แล้ว

      Go to LAYOUT>ORIENTATION > PORTRAIT :))

  • @shahrukhpervaiz9829
    @shahrukhpervaiz9829 3 หลายเดือนก่อน

    Im trying to remove a grey outline when I paste an excel sheet in word, can anyone advise on how It can be removed? Thanks.

  • @xxsilen9xx
    @xxsilen9xx 3 ปีที่แล้ว

    Do you happen to know why it keeps opening in excel every time I double click to edit inside word.
    Thanks

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว +1

      If you have chosen the FULL EDIT format word will automatically take you back to excel to edit your content.

  •  4 ปีที่แล้ว

    amazing!! but i have a question if the tabel in excel is a little big would it still fit in Microsoft word

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      It depends on the size of page you're using in Word, your margins and which form of excel table you're inserting i.e Image is easy to resize.

  • @tomkearns6830
    @tomkearns6830 9 หลายเดือนก่อน

    I copied and pasted a excel table into a word document as described BUT the text and shading were all dark not balnck & white What did I do incorrectley ? How do I fix it?

  • @jodiebeautycentral1725
    @jodiebeautycentral1725 4 ปีที่แล้ว

    Great video. Thank you for sharing. I have a question. I have a document in word that lets me change the data in excel (your third option). One of the tables has somehow changed and will not open in excel - do you know how to fix it? It appears to be more of an image now.

  • @aiynahhazni5274
    @aiynahhazni5274 4 ปีที่แล้ว

    I'm not sure why but the third way doesn't work for me, as in the numbers don't change accordingly. hope you can assist me with this

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      What method did you use to paste?

  • @egeresamuel.o.c.3210
    @egeresamuel.o.c.3210 ปีที่แล้ว +1

    This is a great video, but you have to check the "Past link" in the last option if you would like to update the table from the Excel file.

  • @monicac2466
    @monicac2466 3 ปีที่แล้ว +1

    Thank you so much for this! I thought that last option was much more complicated, but you explained it so well.
    One question: Does the last option mean that if I add or remove columns/rows on the Excel table, that will be reflected onto the Word document as well? Thank you!

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว +1

      Yes absolutely. Thank you for your comment :)

    • @ktrock77
      @ktrock77 3 ปีที่แล้ว

      @@LisaDoe, sounds like there's a little danger there.

  • @rizwanhaider1879
    @rizwanhaider1879 ปีที่แล้ว

    Hi! If this table is larger than the size of word page, i.e. have more rows that would reasonably fit on a word page, how do you adjust that? my table disappears from bottom

  • @LordDescriptor
    @LordDescriptor 10 หลายเดือนก่อน

    Thank you for sharing this exquisite, useful and user-friendly tutorial followed by thorough explanation.

    • @LisaDoe
      @LisaDoe  10 หลายเดือนก่อน +1

      Glad it was helpful!

  • @JG-to8sp
    @JG-to8sp 4 ปีที่แล้ว

    Hi, thanks for this. If I was putting together a feasibility report and I wanted to include a table that could be modifed by its readers, what is the standard procedure if there is one to do this, or is it not really a practical solution? I imagine they need the original excel table open on their desktop and in their own copy of excel for such a thing to work, unless there is something more elegant?Otherwise do you think I should simply provide the excel table in excel format separately and use an image of the table with a description in the doc. I'm sure I would get extra brownie points if the data changed right in front of their eyes!

  • @karamjitsingh-ik1qy
    @karamjitsingh-ik1qy 4 ปีที่แล้ว

    The data in word is not changing with excel, on double it opens excel but not a new in word file only, not the original. What to do now?

  • @amycordes7633
    @amycordes7633 2 ปีที่แล้ว

    I regularly paste Excel table data as a picture into my Word doc. My problem is that the lines/grids change appearance depending on how much I drag to different sizes. It looks like I'm a rookie formatter. Any suggestions to keep type of lines the same as what's in Excel. I bring it as a picture to keep original appearance/format and don't need data to be editable. When I pasted as "keep source formatting", one of the columns changed to flush right instead of centered. Sigh...

  • @2020rts
    @2020rts 4 ปีที่แล้ว +1

    Thank you for this. Very useful. One question maybe you or another veiwer might help me with. I have an EXEL file that is a mailing list and I need to transfer the data to Word to create address labels. Any Advice?

  • @tommyharris5817
    @tommyharris5817 3 ปีที่แล้ว

    When I import an Excel table into word and convert it back into a table, it doesn't allow rows to be added??

  • @Bing_Bong60
    @Bing_Bong60 5 ปีที่แล้ว +11

    Excellent and so clearly explained, thanks👌

  • @rickerek
    @rickerek 4 ปีที่แล้ว +2

    Lisa, this was so helpful! How did you learn all of this? Thanks for sharing your knowledge!

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว +2

      Thanks Rick. I'm a keen learner and sometimes have to experiment. Glad it helped.

  • @basu.31
    @basu.31 3 ปีที่แล้ว

    I have learned a lot of things from the video....Thank You....

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว

      Glad to hear it :)

  • @jchrisbotz6035
    @jchrisbotz6035 2 ปีที่แล้ว

    word blackbelt. lots of dans! really amazing amount of information and how to. brilliant presentation. thanks again.

    • @LisaDoe
      @LisaDoe  2 ปีที่แล้ว

      Glad you enjoyed it!

  • @julioruata2213
    @julioruata2213 4 ปีที่แล้ว

    This help to start to work from Excel to Word way more easy. Thanks

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Great to hear!

  • @himhimhlondo1190
    @himhimhlondo1190 2 ปีที่แล้ว

    Thanks so much.. been looking for this for so long

    • @LisaDoe
      @LisaDoe  2 ปีที่แล้ว

      Glad I could help :)

  • @Pet-friends6379
    @Pet-friends6379 4 ปีที่แล้ว +1

    Thank you so much. it helps me to complete my thesis.

  • @wildfire278
    @wildfire278 ปีที่แล้ว

    doesn't work for me when i paste my table it pastes without the table cells only the text

  • @baileysnights3479
    @baileysnights3479 4 ปีที่แล้ว +1

    Another brilliant course, I had no idea, now I do, practice makes perfect, i'll keep on repeating so I get it.

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Thank you for your lovely comment Ian. Glad it helped.

  • @jannis01
    @jannis01 10 หลายเดือนก่อน

    it sucks that foot notes and citations dont work in excel. Normal tables in word suck but i need to cite within the excel table. Who programmed this

  • @freeworld4me
    @freeworld4me 4 ปีที่แล้ว +1

    Does it really need 8:20 to explain? It is possible to do it way less time. Thanks for the video anyway.

  • @shayejohn6319
    @shayejohn6319 3 ปีที่แล้ว

    Very helpful even in 2021..Thx much

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว

      Glad it helped!

  • @darrenhatton3550
    @darrenhatton3550 4 ปีที่แล้ว +1

    Thanks Lisa , well explained, will look at your other tutorials for tips

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Thank you. You’re welcome 😊

  • @danielschinagl5960
    @danielschinagl5960 2 ปีที่แล้ว

    my table doesn't fit to the word doc. page, no matter what i do

  • @mariancomarzan7654
    @mariancomarzan7654 2 ปีที่แล้ว +1

    Thank you very much! All the best!

    • @LisaDoe
      @LisaDoe  2 ปีที่แล้ว

      Thank you.....you too!!

  • @shayeikonyak5064
    @shayeikonyak5064 3 ปีที่แล้ว

    Wow great video helped me a lot

  • @theamazingchannel470
    @theamazingchannel470 2 ปีที่แล้ว +1

    THank you . Very informative

  • @visheshkrishnasa1288
    @visheshkrishnasa1288 3 ปีที่แล้ว +1

    Thank you soo much... this was very helpful!

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว

      Glad it was helpful!

  • @cherylb1986
    @cherylb1986 8 หลายเดือนก่อน

    Really helpful!

    • @LisaDoe
      @LisaDoe  8 หลายเดือนก่อน

      Glad it was helpful!

  • @Nothing_to_see_here
    @Nothing_to_see_here 2 ปีที่แล้ว

    Life saver.

  • @Chali1950
    @Chali1950 3 ปีที่แล้ว +1

    Thank you, It is very useful. Keep in touch

  • @hafizasad7389
    @hafizasad7389 3 ปีที่แล้ว +1

    Thankyou so much really helping

  • @phyothiha3816
    @phyothiha3816 7 ชั่วโมงที่ผ่านมา

    Thank you very much

  • @successmaharjan2906
    @successmaharjan2906 4 ปีที่แล้ว +1

    Oh! 😱this is so amazing. It helped me lot. Thank you so much.

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      I'm so glad!

  • @simbarashenindi2233
    @simbarashenindi2233 3 ปีที่แล้ว

    Definitely subscribing. You are my superhero

  • @Vivianne1124
    @Vivianne1124 3 ปีที่แล้ว

    Thank you this was very easy and extremely well-explained.

    • @LisaDoe
      @LisaDoe  3 ปีที่แล้ว

      Glad it was helpful! :)

  • @haruprathap
    @haruprathap 2 ปีที่แล้ว +1

    Very informative

  • @oalala5763
    @oalala5763 3 ปีที่แล้ว

    Thank you so much beautifully explained

  • @aidankiely3951
    @aidankiely3951 4 ปีที่แล้ว +1

    Thank you, wonderfully clear

  • @d.ksharma8962
    @d.ksharma8962 3 ปีที่แล้ว

    Thank you so much, That's A Really Nice Video

  • @Mani-pk5yr
    @Mani-pk5yr 4 ปีที่แล้ว

    it was very helpful, thank you so much

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      You're welcome!

  • @icanpracticetoday
    @icanpracticetoday 4 ปีที่แล้ว

    Thanks for your video Lisa! It was very helpful. : )

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Glad it helped.

  • @SS-qx7nh
    @SS-qx7nh ปีที่แล้ว

    Brilliant! Thank you so mucj!

  • @headquartersnews8728
    @headquartersnews8728 4 ปีที่แล้ว +2

    Thanks

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว +1

      No problem

  • @RowRat
    @RowRat 4 ปีที่แล้ว

    Very nice, I learned a lot!

  • @eliasokafor8410
    @eliasokafor8410 4 ปีที่แล้ว +1

    very helpful

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      Glad it helped

  • @Lingvalentino
    @Lingvalentino 4 ปีที่แล้ว

    Amazing explanation. Thank you

  • @tarekemara4175
    @tarekemara4175 4 ปีที่แล้ว +1

    Thank you!!

  • @davidzhong
    @davidzhong ปีที่แล้ว +1

    so helpful1

  • @khalmohammadsharifi8196
    @khalmohammadsharifi8196 4 ปีที่แล้ว

    it was so excellent thank you very much i wish all the best to you

  • @muhammadzeeshan1752
    @muhammadzeeshan1752 2 ปีที่แล้ว

    Good job

  • @MrNathz001
    @MrNathz001 4 ปีที่แล้ว

    Thank you very much !

  • @kanika6308
    @kanika6308 2 ปีที่แล้ว

    Not visible properly

  • @ZheeVee
    @ZheeVee 4 ปีที่แล้ว

    Omg thank you soooooo much!!

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      No problem!!

  • @monaliza5621
    @monaliza5621 4 ปีที่แล้ว

    Thank you.

  • @someoneprice2371
    @someoneprice2371 3 ปีที่แล้ว +1

    thanks

  • @LeggoMyEggHo_
    @LeggoMyEggHo_ 2 ปีที่แล้ว

    8 minutes and I learned paste and copy...

  • @kariyawasamdonaweerasinghe711
    @kariyawasamdonaweerasinghe711 4 ปีที่แล้ว +1

    thnk you

  • @pedrolinares1833
    @pedrolinares1833 3 ปีที่แล้ว

    Ahora veo que a los gringos tambien se les van las cabras de vez en cuándo.

  • @pawankalyan9105
    @pawankalyan9105 3 ปีที่แล้ว

    3:51

  • @pedrotorrejon4606
    @pedrotorrejon4606 3 ปีที่แล้ว

    Awesome but you should try to condense your content

  • @sahamation
    @sahamation ปีที่แล้ว

    Rather copy pasting, I know you can insert a table from a excel sheet and have it linked together…so you can just edit the excel sheet and the word doc will be automatically updated

  • @topg6792
    @topg6792 5 ปีที่แล้ว +1

    I love u

  • @AbdulRehman-nz4rg
    @AbdulRehman-nz4rg 4 ปีที่แล้ว

    good effort, but very long video

  • @MS-zk3qm
    @MS-zk3qm 5 ปีที่แล้ว +2

    👍👍👍👍👍💟

  • @sithikrahuman837
    @sithikrahuman837 5 หลายเดือนก่อน +1

    👍

  • @vlogtouch5852
    @vlogtouch5852 4 ปีที่แล้ว

    ভালো পারতো অপু

  • @the-world-outdoors
    @the-world-outdoors 5 ปีที่แล้ว +1

    :)))

  • @nikcezar2445
    @nikcezar2445 3 ปีที่แล้ว +1

    british

  • @XdekHckr
    @XdekHckr 2 ปีที่แล้ว

    omg mac user, what a waste of...

  • @akprem92
    @akprem92 3 ปีที่แล้ว +1

    Thanks a lot

  • @christinemarshall447
    @christinemarshall447 4 ปีที่แล้ว

    Thank you so much appreciated

    • @LisaDoe
      @LisaDoe  4 ปีที่แล้ว

      You are so welcome