It’s pretty handy to right-click, drag on the Fill Handle to get a secret list of options.
Use this Site’s Search link for “Secrets of the Fill Handle” – a previous post covers right-clicking.
Here are MORE of the goodies the Fill Handle allows:
Hold down the Ctrl key while dragging the Fill Handle. The mouse cursor gets a baby plus indicating Copy mode.
It performs an AutoFill Copy.
Hold down the Shift key while dragging the Fill Handle down. The mouse cursor changes to a double line with double arrows pointing outward indicating Insert mode.
It performs Cell Insert.
Hold down the Shift key while dragging the Fill Handle overtop of the selected cells. The mouse cursor changes to a double line with double arrows pointing inward indicating Delete mode.
It performs Cell Delete.
Of course, these actions work when the entire Row or Column are selected too!
(Though, if you’ve got entire Rows or Columns selected, you might find it quicker to hit the shortcut Ctrl+NumKeypad_Plus or Ctrl+NumKeypad_Minus)
Posting code? Use <pre> tags for VBA and <code> tags for inline.