TechProAdvices: March 2020

Tuesday, March 31, 2020

Windows 10 old wallpaper

[caption id="attachment_1506" align="alignnone" width="2560"]

windows 10 old wallpaper[/caption]

Sunday, March 22, 2020

rotate data in excel with Transpose

today we'll learn about how to transpose
your data in Excel or how to arrange
your data from horizontal to vertical
there are mainly three ways to do it one
is fixed and other two is dynamically
select your data ctrl C for copy then
select the cell go to Home tab and paste
then transpose but this method is not
dynamic as you can see if I change it to
98 it's not changing the second method
is using transpose function you need to
know the number of rows and columns so
we have 19 rows and 3 columns so select
19 columns and 3 rows is equal then
transpose then select your data
close the parentheses then control shift
enter the first one was fixed but the
second was is dynamic let's check you
see it's dynamic the transpose function
work with array so if we select a straw
or columns we'll get this extra data who
is not exist if you want to delete it
you cannot delete it because is the part
of transpose array it's like a train
that 1st and 3rd cargo have peoples but
the second one have nothing but still
you cannot remove it the third one is
not a function or a feature from itself
but it dynamic and easier than the upper
two and it don't have this limit so our
starting data salesperson is on sale a
one product B 1 and unit C 1 put them
here now put something in front of it
excess ll it's up to you what you want
to put here so we have 19 rows gravy
so n19 do same for the lower one select
any cell upper side of the studying data
ctrl + f then replace search for XX
search for XX in el replace with equal
replace them all so done and this is
dynamic - let's check it
one underneath
so guys if you have any question leave a
comment below and give a thumbs up

Quickly Insert Multiple Rows in Excel

alright I'm just gonna show you a quick
trick here how to add multiple lines
into an excel sheet in one shot now what
I see most people doing is they'll go
into a sheet like this and say they
wanted to add a couple lines right here
above above widgets see what they would
do is they'd they'd go they'd click on
the the row here and then they do insert
and say they wanted to do ten they would
just keep doing insert like this now I
mean that that works but a quick way to
do it if you wanted to save a bunch of
time is either you can say you wanted to
put ten items above widgets see here you
can just click highlight ten rows you
can see that you have ten rows highlight
it there I'll do that again it's just so
you can see how many you got here it's
shown right there just do that and then
do the same insert and it's gonna put
those ten rows right above there so you
can quickly do that if you didn't
highlight the whole row and you just
want to do a cell somewhere you can also
do the same thing except here it's not
going to show you as in the same spot
but you can check up there to see how
many there is and then you do the same
thing a quick insert this time it's
going to ask you since you don't have
the the whole row and if you want to put
in that many rows just do entire rows
and then boom you have the same the same
result and you can do it in a couple
clicks as opposed to repeating the thing
over and over and I mean if you need to
do more than more than ten I mean it's
gonna take you a lot more time so I hope
that helps and if you're looking for
more excel tips hit the subscribe button
below and hit the bell for notifications
take care

Wednesday, March 18, 2020

How to use Microsoft word

how to reset android studio to the default settings

How to Fix Microsoft Visual C 2015 Redistributable Setup Failed error 0x80240017

How to Access Netflix Secret Menu

TechProAdvices

Tuesday, March 31, 2020

Windows 10 old wallpaper

Windows 10 old wallpaper

Sunday, March 22, 2020

rotate data in excel with Transpose

rotate data in excel with Transpose

Quickly Insert Multiple Rows in Excel

Quickly Insert Multiple Rows in Excel

Wednesday, March 18, 2020

How to use Microsoft word

How to use Microsoft word

Inpage 2012 Free Download

Report Abuse

Labels