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)
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
This was EXACTLY what I was looking for!!!! Thank you so much Minh! 🙂🙂🙂
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!
That's great to hear!
@@haminh1804 Thank you - so easy when you know how! Appreciate it, Minh😊
Minh thank you for the save, you are awesome.
Thankyou so much @Minh - This really helped me alot - thanks for this video, it was a lifeline for me.
Thank you sooo much! My table was huge and pasting it as picture turned out great!
Wonderful!
you really saved my life. Thank you very much.
Such a big help. Thank you so much. 🎉
Love this!!!!!! Exactly what I needed
very insightful video. Thank you.
Problem solved. Thank you, Minh!
Solved my problem. Thank you.
Exact video that I was searching for. Thank you so much❤
Glad it was helpful!
Thank you so much, really helpful
Thanks a lot.😊😊
Thank you so much
Ahh Thank you so much ❤
Thank you :)
Thanks a lot
Perfect... thank you!
You're welcome!
Thankkk youuuuu
Thank you
thank you
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.
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
@@haminh1804 Thank you
my table is 3 times bigger than yours
same here
For some reason the autofit brakes all the formulas:( and picture doesnt work when you need the formulas
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.
This is not Excel table its Word table otherwise you are implying that you are using an embeded Excel object in Word.
pby
Thankyou so much @Minh - This really helped me alot - thanks for this video, it was a lifeline for me.