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.