0:01
hi everyone and welcome back to Excel
0:04
with In today's video I'm going to show
0:06
you how to insert Excel into a word
0:11
started so the first step have your word
0:14
document open and then open your Excel
0:17
where your data is so in this case I
0:20
have a product quantity price and total
0:23
table here so what I'll do I'll actually
0:27
So you have to ensure that you already
0:29
have your data here um ready and your
0:33
Excel sheet has been made properly so go
0:40
document uh click on click on the insert
0:48
uh over text click on
0:51
object and then click on
0:55
object ensure that you create from file
0:59
click on create from file and then under
1:02
file name let's browse
1:06
once you browse uh this will give
1:11
you this will now ask give you a choice
1:14
to uh take your Excel sheet from where
1:18
you've saved it from in this particular
1:20
case how to insert Excel into one
1:22
document is the sheet that we need so
1:25
click on it and click on insert uh once
1:28
that's done you can choose the option of
1:33
when you choose link to file this means
1:36
that you will always get updates uh the
1:39
update will reflect in word so if you do
1:42
not trust the people you're working with
1:44
you do not want this to be clicked but
1:47
if you trust everyone else in the team
1:50
you can do it um in this particular case
1:53
we'll go with display as an icon you can
1:56
click here change icon to change the uh
2:00
the way your icon looks click on okay
2:03
and then click on okay as you can see if
2:07
you now want to access the data in your
2:09
Excel you just double click on
2:13
it you double click on it and it's going
2:17
to open your Excel sheet and you can
2:19
make the necessary you can make the
2:23
um changes that's the first step i'll
2:26
moving on I'll show you the second step
2:29
the second method is going to be copy
2:31
paste your Excel data into one word so
2:34
let's open our Excel sheet
2:37
uh copy the data that you need to take
2:41
to your word document click on copy open
2:45
your word document and then double click
2:47
where you want to paste it and then in
2:50
this case you can choose three options
2:53
of pasting the first one uh you can
2:56
paste it as a picture as you can see if
2:59
you paste it as a picture you cannot um
3:03
change anything on it the other way you
3:07
can do that let's copy this again the
3:10
other way you can do it you
3:12
can right click another
3:15
place and then choose to paste as a link
3:20
and keep the format the formatting
3:23
um the formatting this means
3:27
that if you update anything on your
3:30
Excel sheet this is going to be updated
3:32
as well and the third option that you
3:35
can actually do is let's go back
3:39
copy copy open our word document and the
3:43
last is to keep the source formatting
3:48
we can just paste as as it appears on
3:52
our Excel sheet so this will come in
3:57
everything and as you can see this is
4:00
the second way you can now actually
4:03
insert your Excel into one i will show
4:08
one the third method we we are going to
4:12
look at is how we will insert Excel as a
4:16
table open your word document click on
4:20
insert click on table and then click on
4:27
spreadsheet exel will open up you can
4:30
choose to manually type in your data or
4:33
go back to your Excel copy your
4:38
data back into your word document
4:43
and back into your word document and
4:45
just paste it and then you can click
4:49
anywhere on the word document to get out
4:51
of the of the exam and there you have
4:55
document and here is your
4:57
document so that's the three methods you
5:00
can use to insert Excel into your Word
5:03
document thank you for watching
