0:00
hello everyone welcome back to our
0:01
beginner Excel course today we are going
0:04
to learn a very important and useful
0:05
skill how to paste data in Excel in
0:08
simple terms this means how to copy data
0:10
from one place to another now let me
0:13
show you here I have a data table and I
0:16
want to copy the data from cell C3 down
0:18
to cell C4 to do this first select cell
0:21
C3 right click on it and choose copy
0:24
next select cell C4 right click again
0:27
and choose paste and just like that the
0:30
data from C3 has been copied perfectly
0:32
to C4 including not just the number but
0:35
also the formatting like colors or fonts
0:38
this is great when you want to keep your
0:40
data looking consistent now let's look
0:42
at another example i have a total value
0:45
calculated in a cell but sometimes you
0:47
don't want to copy the formula behind it
0:49
just the actual result for example here
0:51
the total value is 3500 but it comes
0:53
from a formula if I copy and paste
0:55
normally it will copy the formula to
0:58
which may cause problems if you paste it
0:59
somewhere else to paste only the value
1:02
without the formula you do this right
1:04
click on the original cell and choose
1:05
copy as before then on the cell where
1:07
you want to paste right click and under
1:09
the paste options select paste values
1:12
this will paste only the number 3500 not
1:14
the formula this is very helpful when
1:16
you want to share data without formulas
1:18
or when preparing reports you can easily
1:21
tell the difference because the pasted
1:22
cell now just has a number no formula
1:24
bar shows any formula another handy tip
1:27
for quick copying is using the fill
1:28
handle when you select a cell move your
1:31
mouse to the bottom right corner of the
1:32
cell until the cursor changes to a small
1:34
black plus sign then click and drag down
1:37
or across to the cells where you want to
1:39
copy the data or formula this method
1:41
automatically fills the selected cells
1:43
and is super useful for working with
1:45
large data sets remember mastering
1:48
copying and pasting in Excel can save
1:50
you lots of time and effort when working
1:51
with your data thank you all for
1:54
watching don't forget to subscribe and
1:56
hit the notification bell so you won't
1:57
miss the next lessons in this beginner
1:59
Excel course see you next time
