0:00
let's dive into an important and
0:01
practical feature in Excel paste special
0:05
this tool helps you work with your data
0:06
in more flexible and powerful ways in
0:08
this video we will explore how to paste
0:10
only the values paste only the
0:12
formatting and how to switch rows into
0:14
columns using the transpose function
0:16
let's start with pasting values imagine
0:19
you have a section of data you want to
0:21
copy without bringing over any
0:23
formatting or formulas first select the
0:26
data you want to copy rightclick and
0:28
choose copy then go to the place where
0:31
you want to paste this data right click
0:32
again and choose paste special from the
0:35
options that appear select values and
0:37
click okay this will paste only the raw
0:40
numbers or text into the new location
0:42
leaving behind any formulas or formats
0:44
it's a very handy way to get just the
0:46
data itself without any extra baggage
0:49
now what if you only want to paste the
0:51
formatting maybe you have a nicely
0:53
formatted table with colors fonts or
0:55
borders and you want another section of
0:57
your worksheet to have the same
0:58
appearance to do this follow the same
1:01
steps copy the original data right click
1:03
where you want the formatting and select
1:05
paste special this time choose formats
1:08
and click okay excel will apply the same
1:12
style font color and border settings
1:14
from your original data to the new area
1:16
but without copying any values or
1:18
formulas another powerful option in past
1:21
special is the transpose feature this
1:23
allows you to switch rows into columns
1:25
or columns into rows let's say you have
1:27
a set of data laid out horizontally
1:29
across a row but you want it displayed
1:31
vertically in a column start by
1:34
selecting the data you want to switch
1:35
copy it then right click on the
1:37
destination cell and choose paste
1:39
special in the past special window look
1:42
for the option called transpose and
1:44
check that box click okay and Excel will
1:47
rearrange the data by flipping it from
1:50
rows to columns or vice versa for
1:51
example a row of values in row 7 can be
1:54
transformed into a column in column C
1:56
this is especially useful when you want
1:58
to reformat your data for better
2:00
readability or when your layout needs to
2:07
paste special can save you a lot of time
2:09
and make working with Excel much
2:11
smoother whether you're copying values
2:13
applying consistent formatting or
2:15
switching data orientation these options
2:17
give you more control and flexibility
2:19
keep practicing with different paste
2:21
special options to discover how they can
2:23
simplify your work and help you create
2:25
cleaner more professional spreadsheets
2:27
thanks for following along and I hope
2:29
you feel more confident in using these
