Insert Rows with Excel Fill Handle

If you want to insert a block of cells on a worksheet, what method do you use?

One way to insert cells is to select some cells, right-click on the selected range, and click Insert. Then you can select one of the Insert options.

insertcells01

Insert With the Fill Handle

This week, I was doing some updates on this blog, and found a tip that I posted 5 years ago. You can use the Fill Handle as a shortcut for inserting and deleting cells.

Select cells as a starting point, press Shift, and drag the fill handle to insert cells. You can use the Fill Handle to delete cells too!

insertcells02

Apparently I haven’t used that tip too often, because I forgot all about it! You’ll find more data entry tips on my Contextures website.

Watch the Video

Maybe I’ll remember this tip a bit longer if I make a video. To see the steps for inserting and deleting a block of cells, you can watch this short video. And watch for this tip again in 2018!

_

_____________________

You may also like...

3 Responses

  1. simlaoui says:

    hi Debra;
    thank you in advance.
    a really appareciate how you share your knowledge.
    if we want to insert EMPTY rows within others and give a little oxygen to our data ; we can use this tricks.
    http://www.simlaoui.blogspot.com/2013/04/un-peu-doxygene-pour-vos-donnees.html

    to read it in english you can translate this post by google translater on the above of the blog.
    thank you in advance.
    yours

  2. Jeff Weir says:

    Cool!

  3. richard says:

    This insert dialog behavior is no longer observed in Excel 2013. I only have the option to insert an entire row or an entire column. I can no longer shift cells down or right. This makes it more difficult when I am combining data from different sources.

Leave a Reply to Jeff Weir Cancel reply

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