To copy cells, use this shortcut before or after you start to drag the selection.

Excel will display a small plus (+) symbol to indicate the copy operation.

The videos below demonstrate this shortcut.

Video thumbnail for Conditional formatting with two variable inputs

Video thumbnail for How to copy and lock structured references

Video thumbnail for How to sort a pivot table with a custom list

Video thumbnail for Shortcuts for drag and drop

Video thumbnail for How to use drag and drop in Excel

Video thumbnail for How to group values with VLOOKUP