#331 Insert or Delete Cells with AutoFill

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

Excel-Fill-Handle-Insert-Delete

Advertisements

One thought on “#331 Insert or Delete Cells with AutoFill

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s