How to put an EXCEL table into word. Editable Table (2019)
Vložit
- čas přidán 29. 07. 2024
- How to put an EXCEL table into word. Inserting an Excel table or spreadsheet into Microsoft Word can be achieved in a few different ways depending on how you want the table to function. This tutorial shows you how you can insert an excel table in word that will allow you to fully edit the table if you have made a mistake or need to change it at a later date. This can be a real pain if you have to insert columns or rows or have to change a number that will alter the results or totals at the end of a row or column. Thankfully there is a solution which I will show you in the tutorial
Microsoft Office 365 - microsoft.msafflnk.net/x3yAA
The above link is an affiliate link. If you click on it and purchase a product you will not pay a penny more but I will gain a small commission to help keep the lights on!!!
Inserting an Excel table or spreadsheet into Microsoft Word can be achieved in a few different ways depending on how you want the table to function. This tutorial shows you how you can insert an excel table in word that will allow you to fully edit the table if you have made a mistake or need to change it at a later date. This can be a real pain if you have to insert columns or rows or have to change a number that will alter the results or totals at the end of a row or column. Thankfully there is a solution which I will show you in the tutorial.
The second way to insert a table into word is to simply copy and paste it. By doing this it will allow you to change the titles, row titles, column titles and numbers. However, it will not update the totals or adjust number in accordance with any formulas or sums you may have placed in your table. So for simple tables this method is perfect.
In the final example I demonstrate how to insert a table as if it were an image. This prevents that table from being formatted or edited in any way. However, it does allow for additional artwork to be placed over or around it such as arrows, circles and lines. This could be used if you need to highlight an area of the table or point to a relevant piece of information on the table. This method of inserting an excel table in word also allows you to change certain characteristic of the table such as gridline colours, borders, mirroring, shading and a number of other options that the 'format picture' tab gives you. You can really be quite whacky in this area if you need to be.
Throughout my student and adult life I used an excel spreadsheet for something whether is results for my degree and dissertation, personal finances, business finances or simply keeping track of peoples birthdays and anniversaries. However, you use excel spreadsheets they are fantastic for adding data, subtracting data and giving you answers to different date selection. For example, if you were to input your monthly spend transactions (frightening stuff) you may want to break down your spending pattern. You could make columns for the different transactions you make such as food, petrol, mortgage, gifts, clothes, toiletries, music, broadband, mobile phones, etc. Once you input the data you could have TOTAL cell at the end of each column to show you how much you were spending on each element each month. Of course, many people use a spreadsheet and table to track every element of their business from finance’s to growth and much more.
I believe that the need to insert an excel table into word comes from students, teachers, scientists and financial advisers. I inserted an excel table into my thesis numerous times to show results I had gained from experiments and interviews I had conducted. I have also used them to produce reports for my accountant.
Microsoft Excel is a spreadsheet program. That means it's used to create grids of text, numbers and formulas specifying calculations. That's extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.
It can be programmed to pull in data from external sources such as stock market feeds, automatically running the data through formula such as financial models to update such information in real time. Like Microsoft Word, Excel has become a de facto standard in the business world, with Excel spreadsheets frequently emailed and otherwise shared to exchange data and perform various calculations.
Excel also contains fairly powerful programming capabilities for those who wish to use them that can be used to develop relatively sophisticated financial and scientific computation capabilities. Due to its extreme versatility and power, Excel has become one of the most-used software programs in the business world since its launch in 1985. Indeed, the personal computing renaissance of the 1980s and 1990s was largely driven by the many uses of Excel and other spreadsheet software.
#excelspreadsheetinword
#insertexcelchartinword
#insertexceltableinword
Thank you so much! After a long struggle, you assisted me in saving my Chapter 3!
I'm so glad I was able to help. Have a great day.
Excellent and so clearly explained, thanks👌
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!
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.
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 😩💃
Really glad you managed to solve the problem and insert the table you needed :)
Thank you, wonderfully clear
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!
This help to start to work from Excel to Word way more easy. Thanks
Great to hear!
Amazing explanation. Thank you
Very nice, I learned a lot!
it was so excellent thank you very much i wish all the best to you
Thank you so much. it helps me to complete my thesis.
Thank you so much beautifully explained
Thank you very much !
Can I copy tables and lose the lines once copied. Currently the text is jumbled up when I use text only .
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!!
Thank you!!
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?
Thanks Lisa , well explained, will look at your other tutorials for tips
Thank you. You’re welcome 😊
Thanks for your video Lisa! It was very helpful. : )
Glad it helped.
THank you . Very informative
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
Thankyou so much really helping
Definitely subscribing. You are my superhero
Thank you, It is very useful. Keep in touch
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?
Oh! 😱this is so amazing. It helped me lot. Thank you so much.
I'm so glad!
Thank you this was very easy and extremely well-explained.
Glad it was helpful! :)
Brilliant! Thank you so mucj!
Thank you so much, That's A Really Nice Video
Thanks a lot
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?
Not that I'm aware of.
Thank you.
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.
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...
Omg thank you soooooo much!!
No problem!!
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!
Yes absolutely. Thank you for your comment :)
@@LisaDoe, sounds like there's a little danger there.
Thank you so much appreciated
You are so welcome
it was very helpful, thank you so much
You're welcome!
Lisa, this was so helpful! How did you learn all of this? Thanks for sharing your knowledge!
Thanks Rick. I'm a keen learner and sometimes have to experiment. Glad it helped.
Thank you soo much... this was very helpful!
Glad it was helpful!
thanks
Thank you very much! All the best!
Thank you.....you too!!
Thanks so much.. been looking for this for so long
Glad I could help :)
Good job
thnk you
Very informative
Really helpful!
Glad it was helpful!
Excellent 4 year old news 👏🏾 👍🏾
This will save me a lot of frustration 😂🤣😂
Glad to hear it!
Thank you for sharing this exquisite, useful and user-friendly tutorial followed by thorough explanation.
Glad it was helpful!
Very helpful even in 2021..Thx much
Glad it helped!
so helpful1
Life saver.
word blackbelt. lots of dans! really amazing amount of information and how to. brilliant presentation. thanks again.
Glad you enjoyed it!
I have learned a lot of things from the video....Thank You....
Glad to hear it :)
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?
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?
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.
Thanks so kindly. What if the table from the excel sheet is so large, how do you adjust it in word?
You can decrease your margins in word or reduce the font size of your excel table :))
amazing!! but i have a question if the tabel in excel is a little big would it still fit in Microsoft word
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.
Thanks
No problem
very helpful
Glad it helped
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
When I import an Excel table into word and convert it back into a table, it doesn't allow rows to be added??
doesn't work for me when i paste my table it pastes without the table cells only the text
Another brilliant course, I had no idea, now I do, practice makes perfect, i'll keep on repeating so I get it.
Thank you for your lovely comment Ian. Glad it helped.
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
What method did you use to paste?
my table doesn't fit to the word doc. page, no matter what i do
SIZE OF MY EXCEL TABLE IS SAME BUT I HAVE TO IMPORT IT INTO THE PORTRAIT LAYOUT RATHER THAN LANDSCAPE KINDLY HELP
Go to LAYOUT>ORIENTATION > PORTRAIT :))
Wow great video helped me a lot
Glad it helped
Indeed
Do you happen to know why it keeps opening in excel every time I double click to edit inside word.
Thanks
If you have chosen the FULL EDIT format word will automatically take you back to excel to edit your content.
I love u
Not visible properly
👍
Does it really need 8:20 to explain? It is possible to do it way less time. Thanks for the video anyway.
👍👍👍👍👍💟
8 minutes and I learned paste and copy...
Awesome but you should try to condense your content
3:51
ভালো পারতো অপু
Ahora veo que a los gringos tambien se les van las cabras de vez en cuándo.
good effort, but very long video
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
:)))
british
omg mac user, what a waste of...