I’m a big fan of Excel’s AutoFill tool for quick and easy copying. This week I’d like to show you how AutoFill can also be used for quickly inserting cells.
You 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 super quick and I like it better than using the ribbon.
You can also use this trick to delete cells too. Just drag the AutoFill handle UP while holding down the SHIFT key.
See It In Action