Quickly Insert Multiple Rows in Excel

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

Leave a comment

Your email address will not be published. Required fields are marked *