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

  Рет қаралды 427,077

Lisa Doe

Lisa Doe

Күн бұрын

Пікірлер: 125
@bonolososha8683
@bonolososha8683 3 жыл бұрын
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 жыл бұрын
Really glad you managed to solve the problem and insert the table you needed :)
@egeresamuel.o.c.3210
@egeresamuel.o.c.3210 Жыл бұрын
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.
@LordDescriptor
@LordDescriptor 7 ай бұрын
Thank you for sharing this exquisite, useful and user-friendly tutorial followed by thorough explanation.
@LisaDoe
@LisaDoe 7 ай бұрын
Glad it was helpful!
@julioruata2213
@julioruata2213 4 жыл бұрын
This help to start to work from Excel to Word way more easy. Thanks
@LisaDoe
@LisaDoe 4 жыл бұрын
Great to hear!
@visheshkrishnasa1288
@visheshkrishnasa1288 3 жыл бұрын
Thank you soo much... this was very helpful!
@LisaDoe
@LisaDoe 3 жыл бұрын
Glad it was helpful!
@d.ksharma8962
@d.ksharma8962 3 жыл бұрын
Thank you so much, That's A Really Nice Video
@Mani-pk5yr
@Mani-pk5yr 3 жыл бұрын
it was very helpful, thank you so much
@LisaDoe
@LisaDoe 3 жыл бұрын
You're welcome!
@Mark_Moore60
@Mark_Moore60 5 жыл бұрын
Excellent and so clearly explained, thanks👌
@icanpracticetoday
@icanpracticetoday 4 жыл бұрын
Thanks for your video Lisa! It was very helpful. : )
@LisaDoe
@LisaDoe 4 жыл бұрын
Glad it helped.
@Lingvalentino
@Lingvalentino 4 жыл бұрын
Amazing explanation. Thank you
@Lisa_0519
@Lisa_0519 4 жыл бұрын
Thank you so much! After a long struggle, you assisted me in saving my Chapter 3!
@LisaDoe
@LisaDoe 4 жыл бұрын
I'm so glad I was able to help. Have a great day.
@headquartersnews8728
@headquartersnews8728 4 жыл бұрын
Thanks
@LisaDoe
@LisaDoe 4 жыл бұрын
No problem
@eliasokafor8410
@eliasokafor8410 4 жыл бұрын
very helpful
@LisaDoe
@LisaDoe 4 жыл бұрын
Glad it helped
@monaliza5621
@monaliza5621 4 жыл бұрын
Thank you.
@leonardoz.wongbae9165
@leonardoz.wongbae9165 Жыл бұрын
Thanks so kindly. What if the table from the excel sheet is so large, how do you adjust it in word?
@LisaDoe
@LisaDoe Жыл бұрын
You can decrease your margins in word or reduce the font size of your excel table :))
@tomkearns6830
@tomkearns6830 6 ай бұрын
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?
@davidzhong
@davidzhong Жыл бұрын
so helpful1
@jannis01
@jannis01 8 ай бұрын
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
@2020rts
@2020rts 4 жыл бұрын
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?
@nikcezar2445
@nikcezar2445 2 жыл бұрын
british
@shahrukhpervaiz9829
@shahrukhpervaiz9829 Ай бұрын
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.
@garydeane9783
@garydeane9783 4 жыл бұрын
Can I copy tables and lose the lines once copied. Currently the text is jumbled up when I use text only .
@pedrolinares1833
@pedrolinares1833 3 жыл бұрын
Ahora veo que a los gringos tambien se les van las cabras de vez en cuándo.
@Chali1950
@Chali1950 3 жыл бұрын
Thank you, It is very useful. Keep in touch
@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.
@wildfire278
@wildfire278 Жыл бұрын
doesn't work for me when i paste my table it pastes without the table cells only the text
@hafizasad7389
@hafizasad7389 3 жыл бұрын
Thankyou so much really helping
@theamazingchannel470
@theamazingchannel470 2 жыл бұрын
THank you . Very informative
@xxsilen9xx
@xxsilen9xx 2 жыл бұрын
Do you happen to know why it keeps opening in excel every time I double click to edit inside word. Thanks
@LisaDoe
@LisaDoe 2 жыл бұрын
If you have chosen the FULL EDIT format word will automatically take you back to excel to edit your content.
@sithikrahuman837
@sithikrahuman837 3 ай бұрын
👍
@danielschinagl5960
@danielschinagl5960 2 жыл бұрын
my table doesn't fit to the word doc. page, no matter what i do
@abirsarkar7075
@abirsarkar7075 4 жыл бұрын
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.
@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 :))
@udaradayarthna6379
@udaradayarthna6379 3 жыл бұрын
Thank you so much. it helps me to complete my thesis.
@haruprathap
@haruprathap 2 жыл бұрын
Very informative
@pedrotorrejon4606
@pedrotorrejon4606 3 жыл бұрын
Awesome but you should try to condense your content
@LeggoMyEggHo_
@LeggoMyEggHo_ Жыл бұрын
8 minutes and I learned paste and copy...
@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...
@mariancomarzan7654
@mariancomarzan7654 Жыл бұрын
Thank you very much! All the best!
@LisaDoe
@LisaDoe Жыл бұрын
Thank you.....you too!!
@rickerek
@rickerek 4 жыл бұрын
Lisa, this was so helpful! How did you learn all of this? Thanks for sharing your knowledge!
@LisaDoe
@LisaDoe 4 жыл бұрын
Thanks Rick. I'm a keen learner and sometimes have to experiment. Glad it helped.
@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
@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
@tommyharris5817
@tommyharris5817 2 жыл бұрын
When I import an Excel table into word and convert it back into a table, it doesn't allow rows to be added??
@akprem92
@akprem92 3 жыл бұрын
Thanks a lot
@someoneprice2371
@someoneprice2371 3 жыл бұрын
thanks
@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?
@darrenhatton3550
@darrenhatton3550 4 жыл бұрын
Thanks Lisa , well explained, will look at your other tutorials for tips
@LisaDoe
@LisaDoe 4 жыл бұрын
Thank you. You’re welcome 😊
@kariyawasamdonaweerasinghe711
@kariyawasamdonaweerasinghe711 4 жыл бұрын
thnk you
@kanika6308
@kanika6308 2 жыл бұрын
Not visible properly
@AbdulRehman-nz4rg
@AbdulRehman-nz4rg 4 жыл бұрын
good effort, but very long video
@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?
@freeworld4me
@freeworld4me 4 жыл бұрын
Does it really need 8:20 to explain? It is possible to do it way less time. Thanks for the video anyway.
@agbe2902
@agbe2902 Жыл бұрын
Excellent 4 year old news 👏🏾 👍🏾 This will save me a lot of frustration 😂🤣😂
@LisaDoe
@LisaDoe Жыл бұрын
Glad to hear it!
@fallsnative
@fallsnative 4 жыл бұрын
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!!
@MS-zk3qm
@MS-zk3qm 4 жыл бұрын
👍👍👍👍👍💟
@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!
@SS-qx7nh
@SS-qx7nh Жыл бұрын
Brilliant! Thank you so mucj!
@oalala5763
@oalala5763 3 жыл бұрын
Thank you so much beautifully explained
@tarekemara4175
@tarekemara4175 4 жыл бұрын
Thank you!!
@successmaharjan2906
@successmaharjan2906 4 жыл бұрын
Oh! 😱this is so amazing. It helped me lot. Thank you so much.
@LisaDoe
@LisaDoe 4 жыл бұрын
I'm so glad!
@topg6792
@topg6792 4 жыл бұрын
I love u
@simbarashenindi2233
@simbarashenindi2233 3 жыл бұрын
Definitely subscribing. You are my superhero
@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.
@muhammadzeeshan1752
@muhammadzeeshan1752 Жыл бұрын
Good job
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.
@shayeikonyak5064
@shayeikonyak5064 3 жыл бұрын
Wow great video helped me a lot
@LisaDoe
@LisaDoe 3 жыл бұрын
Glad it helped
@shayeikonyak5064
@shayeikonyak5064 3 жыл бұрын
Indeed
@basu.31
@basu.31 2 жыл бұрын
I have learned a lot of things from the video....Thank You....
@LisaDoe
@LisaDoe 2 жыл бұрын
Glad to hear it :)
@pawankalyan9105
@pawankalyan9105 3 жыл бұрын
3:51
@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!
@monicac2466
@monicac2466 3 жыл бұрын
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 жыл бұрын
Yes absolutely. Thank you for your comment :)
@ktrock77
@ktrock77 3 жыл бұрын
@@LisaDoe, sounds like there's a little danger there.
@aidankiely3951
@aidankiely3951 4 жыл бұрын
Thank you, wonderfully clear
@robsretrorides796
@robsretrorides796 3 жыл бұрын
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!
@shayejohn6319
@shayejohn6319 3 жыл бұрын
Very helpful even in 2021..Thx much
@LisaDoe
@LisaDoe 3 жыл бұрын
Glad it helped!
@cherylb1986
@cherylb1986 5 ай бұрын
Really helpful!
@LisaDoe
@LisaDoe 5 ай бұрын
Glad it was helpful!
@himhimhlondo1190
@himhimhlondo1190 2 жыл бұрын
Thanks so much.. been looking for this for so long
@LisaDoe
@LisaDoe 2 жыл бұрын
Glad I could help :)
@khalmohammadsharifi8196
@khalmohammadsharifi8196 4 жыл бұрын
it was so excellent thank you very much i wish all the best to you
@Nothing_to_see_here
@Nothing_to_see_here 2 жыл бұрын
Life saver.
@christinemarshall447
@christinemarshall447 3 жыл бұрын
Thank you so much appreciated
@LisaDoe
@LisaDoe 3 жыл бұрын
You are so welcome
@MrNathz001
@MrNathz001 4 жыл бұрын
Thank you very much !
@baileysnights3479
@baileysnights3479 4 жыл бұрын
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.
@Vivianne1124
@Vivianne1124 3 жыл бұрын
Thank you this was very easy and extremely well-explained.
@LisaDoe
@LisaDoe 3 жыл бұрын
Glad it was helpful! :)
@vlogtouch5852
@vlogtouch5852 4 жыл бұрын
ভালো পারতো অপু
@the-world-outdoors
@the-world-outdoors 5 жыл бұрын
:)))
@RowRat
@RowRat 4 жыл бұрын
Very nice, I learned a lot!
@ZheeVee
@ZheeVee 4 жыл бұрын
Omg thank you soooooo much!!
@LisaDoe
@LisaDoe 4 жыл бұрын
No problem!!
@XdekHckr
@XdekHckr 2 жыл бұрын
omg mac user, what a waste of...
Стойкость Фёдора поразила всех!
00:58
МИНУС БАЛЛ
Рет қаралды 4,9 МЛН
Please Help This Poor Boy 🙏
00:40
Alan Chikin Chow
Рет қаралды 23 МЛН
How to Copy Excel Table into MS Word (that auto updates)
7:40
TrumpExcel
Рет қаралды 233 М.
HOW TO INSERT AN EXCEL WORKSHEET: Into A Word Document
2:57
Online Tech Tips
Рет қаралды 113 М.
Mail Merge from Excel to Microsoft Word
15:03
Technology for Teachers and Students
Рет қаралды 2,6 МЛН
Three Ways to Insert Tables in Microsoft Word
8:39
Erin Wright Writing
Рет қаралды 290 М.
How to Insert Excel Tables into Microsoft Word (PC & Mac)
3:58
Erin Wright Writing
Рет қаралды 18 М.
How to Put Excel Formulas in a Word Document
5:10
Chester Tugwell
Рет қаралды 57 М.
How to embed an Excel file into Word
2:33
Ready Steady Excel
Рет қаралды 279 М.
(1/2) Automating Word Documents from Excel - No VBA
4:37
Andrew Ligon Fant
Рет қаралды 368 М.