Excel Mouse Shortcuts to Insert or Delete a Block of Cells

In Excel, you can use mouse commands or mouse shortcuts, to insert and delete blocks of cells.

If you use this technique, data in other columns on the worksheet is not affected, because a whole row is not inserted.

The first step is to select cells as a starting point, and then use the command or shortcut to insert or delete cells.

Watch this short video, to see the steps.
For written steps, go to my Contextures blog.

[krn]

Thanks Debra. Didn't know about the shift fill handle thing. Great tip.

[TickyMN]

Wow! What a great tip using shift and the fill handle. Thank you

[contextures]

@Jon D Thank! There's always something new to discover in Excel.

[pmsocho]

'Shift + mouse' is cool! I didn't know about that!
Almost as cool as 'ALT + mouse' when moving objects :)

[contextures]

@Ticky66MN Thanks! Glad you like the tip.

[anabellepiramide]

Wow! I never knew this 'til now... Awesome trick, thanks a lot to Contextures... :-)

[contextures]

@pmsocho Thanks! The Alt+mouse tip is handy too.

[ronwb]

I'm confused on how you did this task.