How to fit a large Excel table into a Word document (3 methods)

Поділитися
Вставка
  • Опубліковано 2 сер 2024
  • Let's learn 3 simple ways to fit a big Excel table to Word:
    1. Autofit to Window 0:07
    2. Put the table into a seperate page and make only that page landscape 0:46
    3. Paste as image 2:15
    Don't forget to like, comment and subscribe if you'd like to see more videos like this one!
    For work/training enquiries, email me at: minh@skyaries.com
    Support my work: paypal.me/nguyenthihaminh
    Happy learning
    Nguyen Thi Ha Minh (Sky Aries)

КОМЕНТАРІ • 38

  • @haminh1804
    @haminh1804  2 роки тому

    Hi, I've just published a new course on Skillshare with 20 lessons and lots of helpful tips to help you learn everything you need to know about formatting Microsoft Word tables. Learn with me on SkillShare and click here to get your free one-month trial: www.skillshare.com/r/profile/Minh-Nguyen/657592435?gr_tch_ref=on&gr_trp=on

  • @grahamkutner-simon8272
    @grahamkutner-simon8272 7 місяців тому +1

    This was EXACTLY what I was looking for!!!! Thank you so much Minh! 🙂🙂🙂

  • @mikewaschka1973
    @mikewaschka1973 Рік тому +5

    Great stuff! The Paste as Picture option is perfect and solves a world of ills with putting Excel-created tables in to Word docs that are larger than the page! Thank you so much!

    • @haminh1804
      @haminh1804  Рік тому

      That's great to hear!

    • @annbritton4719
      @annbritton4719 Рік тому

      @@haminh1804 Thank you - so easy when you know how! Appreciate it, Minh😊

  • @alexkajuba7891
    @alexkajuba7891 20 днів тому

    Minh thank you for the save, you are awesome.

  • @8Styfir
    @8Styfir 2 місяці тому

    Thankyou so much @Minh - This really helped me alot - thanks for this video, it was a lifeline for me.

  • @messyhairlife3319
    @messyhairlife3319 Рік тому +1

    Thank you sooo much! My table was huge and pasting it as picture turned out great!

  • @yevonsama
    @yevonsama 10 місяців тому

    you really saved my life. Thank you very much.

  • @racylynvaldez8234
    @racylynvaldez8234 Рік тому +1

    Such a big help. Thank you so much. 🎉

  • @carorod9936
    @carorod9936 Рік тому +1

    Love this!!!!!! Exactly what I needed

  • @suhasjadhav1610
    @suhasjadhav1610 2 роки тому +1

    very insightful video. Thank you.

  • @tonyjcr
    @tonyjcr Рік тому

    Problem solved. Thank you, Minh!

  • @murphthesurf3409
    @murphthesurf3409 7 місяців тому

    Solved my problem. Thank you.

  • @unnitamahato1579
    @unnitamahato1579 Рік тому +1

    Exact video that I was searching for. Thank you so much❤

  • @lasanmanujitha6120
    @lasanmanujitha6120 Рік тому

    Thank you so much, really helpful

  • @daffodilshaw1998
    @daffodilshaw1998 4 місяці тому

    Thanks a lot.😊😊

  • @Alleyman070
    @Alleyman070 2 роки тому

    Thank you so much

  • @AnkitaHataparosa
    @AnkitaHataparosa 2 місяці тому

    Ahh Thank you so much ❤

  • @atawhai6920
    @atawhai6920 9 місяців тому

    Thank you :)

  • @shaireenimran9442
    @shaireenimran9442 11 місяців тому

    Thanks a lot

  • @michaelshampine9306
    @michaelshampine9306 Рік тому

    Perfect... thank you!

  • @mysticmac2125
    @mysticmac2125 5 місяців тому

    Thankkk youuuuu

  • @mindsetting1981
    @mindsetting1981 6 місяців тому

    Thank you

  • @suhabekki5417
    @suhabekki5417 Рік тому

    thank you

  • @castonbinger2043
    @castonbinger2043 Рік тому

    Small chart you are using as an example. What if the chart is taller and extends into page 2. Also, I don't have "Paste as picture" option for some reason.

    • @haminh1804
      @haminh1804  Рік тому +1

      If the chart is taller and extends into 2 pages, then the best way is to paste as picture. If you don't have this option available, you can try screen clipping or print screen instead. Hope this helps. Minh

    • @castonbinger2043
      @castonbinger2043 Рік тому

      @@haminh1804 Thank you

  • @sinkymathibeng6881
    @sinkymathibeng6881 2 роки тому +8

    my table is 3 times bigger than yours

  • @CristianCiupe
    @CristianCiupe 10 місяців тому

    For some reason the autofit brakes all the formulas:( and picture doesnt work when you need the formulas

    • @haminh1804
      @haminh1804  10 місяців тому

      Hi, this is because Word does not support Excel formulas. Word has their own sets of (very limited) formulas following different referencing convention. Your best alternative would be to insert an Excel chart instead.

  • @peterlapic6761
    @peterlapic6761 Рік тому

    This is not Excel table its Word table otherwise you are implying that you are using an embeded Excel object in Word.

  • @8Styfir
    @8Styfir 2 місяці тому

    Thankyou so much @Minh - This really helped me alot - thanks for this video, it was a lifeline for me.