How to put an EXCEL table into word. Editable Table (2019)
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
Пікірлер: 124
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!
Thank you so much! After a long struggle, you assisted me in saving my Chapter 3!
@LisaDoe
4 жыл бұрын
I'm so glad I was able to help. Have a great day.
Excellent and so clearly explained, thanks👌
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
3 жыл бұрын
Really glad you managed to solve the problem and insert the table you needed :)
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.
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!
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!!
Thanks Lisa , well explained, will look at your other tutorials for tips
@LisaDoe
4 жыл бұрын
Thank you. You’re welcome 😊
Definitely subscribing. You are my superhero
Thank you, wonderfully clear
This help to start to work from Excel to Word way more easy. Thanks
@LisaDoe
4 жыл бұрын
Great to hear!
Amazing explanation. Thank you
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
Can I copy tables and lose the lines once copied. Currently the text is jumbled up when I use text only .
Thank you so much beautifully explained
Thank you, It is very useful. Keep in touch
Thank you so much. it helps me to complete my thesis.
THank you . Very informative
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?
Very nice, I learned a lot!
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.
it was so excellent thank you very much i wish all the best to you
Thank you so much, That's A Really Nice Video
Thanks for your video Lisa! It was very helpful. : )
@LisaDoe
4 жыл бұрын
Glad it helped.
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?
Thankyou so much really helping
Thanks so much.. been looking for this for so long
@LisaDoe
2 жыл бұрын
Glad I could help :)
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...
Thank you for sharing this exquisite, useful and user-friendly tutorial followed by thorough explanation.
@LisaDoe
5 ай бұрын
Glad it was helpful!
Brilliant! Thank you so mucj!
Oh! 😱this is so amazing. It helped me lot. Thank you so much.
@LisaDoe
3 жыл бұрын
I'm so glad!
Thank you very much !
Thank you soo much... this was very helpful!
@LisaDoe
3 жыл бұрын
Glad it was helpful!
Thank you this was very easy and extremely well-explained.
@LisaDoe
2 жыл бұрын
Glad it was helpful! :)
word blackbelt. lots of dans! really amazing amount of information and how to. brilliant presentation. thanks again.
@LisaDoe
2 жыл бұрын
Glad you enjoyed it!
Excellent 4 year old news 👏🏾 👍🏾 This will save me a lot of frustration 😂🤣😂
@LisaDoe
10 ай бұрын
Glad to hear it!
Thank you very much! All the best!
@LisaDoe
Жыл бұрын
Thank you.....you too!!
Thank you!!
it was very helpful, thank you so much
@LisaDoe
3 жыл бұрын
You're welcome!
Very informative
I have learned a lot of things from the video....Thank You....
@LisaDoe
2 жыл бұрын
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?
Really helpful!
@LisaDoe
3 ай бұрын
Glad it was helpful!
Thank you so much appreciated
@LisaDoe
3 жыл бұрын
You are so welcome
When I import an Excel table into word and convert it back into a table, it doesn't allow rows to be added??
Omg thank you soooooo much!!
@LisaDoe
4 жыл бұрын
No problem!!
Very helpful even in 2021..Thx much
@LisaDoe
3 жыл бұрын
Glad it helped!
Good job
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
4 жыл бұрын
Not that I'm aware of.
Thanks a lot
Thank you.
Lisa, this was so helpful! How did you learn all of this? Thanks for sharing your knowledge!
@LisaDoe
3 жыл бұрын
Thanks Rick. I'm a keen learner and sometimes have to experiment. Glad it helped.
Wow great video helped me a lot
@LisaDoe
2 жыл бұрын
Glad it helped
@shayeikonyak5064
2 жыл бұрын
Indeed
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
3 жыл бұрын
Yes absolutely. Thank you for your comment :)
@ktrock77
2 жыл бұрын
@@LisaDoe, sounds like there's a little danger there.
so helpful1
Life saver.
very helpful
@LisaDoe
4 жыл бұрын
Glad it helped
Thanks so kindly. What if the table from the excel sheet is so large, how do you adjust it in word?
@LisaDoe
Жыл бұрын
You can decrease your margins in word or reduce the font size of your excel table :))
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
doesn't work for me when i paste my table it pastes without the table cells only the text
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
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.
amazing!! but i have a question if the tabel in excel is a little big would it still fit in Microsoft word
@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.
thnk you
thanks
SIZE OF MY EXCEL TABLE IS SAME BUT I HAVE TO IMPORT IT INTO THE PORTRAIT LAYOUT RATHER THAN LANDSCAPE KINDLY HELP
@LisaDoe
Жыл бұрын
Go to LAYOUT>ORIENTATION > PORTRAIT :))
my table doesn't fit to the word doc. page, no matter what i do
Do you happen to know why it keeps opening in excel every time I double click to edit inside word. Thanks
@LisaDoe
2 жыл бұрын
If you have chosen the FULL EDIT format word will automatically take you back to excel to edit your content.
Another brilliant course, I had no idea, now I do, practice makes perfect, i'll keep on repeating so I get it.
@LisaDoe
3 жыл бұрын
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
@LisaDoe
3 жыл бұрын
What method did you use to paste?
Thanks
@LisaDoe
4 жыл бұрын
No problem
8 minutes and I learned paste and copy...
I love u
Not visible properly
👍👍👍👍👍💟
👍
Awesome but you should try to condense your content
good effort, but very long video
Does it really need 8:20 to explain? It is possible to do it way less time. Thanks for the video anyway.
3:51
ভালো পারতো অপু
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
Ahora veo que a los gringos tambien se les van las cabras de vez en cuándo.
:)))
british
omg mac user, what a waste of...