Insert or Delete Cells with AutoFill

Here are a couple of quick tips for you -- try them a few times today, and maybe you'll still remember them by Monday.
I often have to insert a few cells in a list, so I select a range of cells, then choose Insertâ–ºCells, click Shift cells down, then click OK. That method works very nicely, but it's four clicks. I don't have time for four clicks!
Recently I learned that I can press the Shift key and drag the AutoFill handle to insert cells. You can drag up, down, left or right, to insert cells in any direction. It's much quicker than all those clicks!

You can use the same technique to delete cells too. Hold the Shift key and drag the Fill Handle over the selected cells, to grey out the cells.

0 thoughts on “Insert or Delete Cells with AutoFill”

  1. Just a reminder to your readers that the same technique works for inserting and deleting rows. Select a row, hold down Shift, and drag the AutoFill handle located next to the row number.
    Thanks for all the great articles and videos on your web site! I learn something new every time I visit.

  2. Your website is great! I've been using it for a while now to learn all sorts of new things. Just discovered the blog, and I'm so excited to have access to information on a daily basis!
    This tip is great, I'll be using it frequently.

  3. Is there a way to create a program that inserts cells automatically? For example I am working on a 4x4 matrix for names and adresses. Below that I have another 9x9 matrix for a different application.
    When I am working with the 4x4 matrix and get to the fourth row, can I have a program that inserts a cell automaticallly? Help!!!!!!!!!!!!!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.