Copying And Pasting A Multiple Selection

Category: General Weirdness | [Item URL]

If you try to copy non-contiguous cells (i.e., a multiple selection), you'll probably get a pop-up message:

That command cannot be used on multiple selections.

But there are some situations in which Excel does allow you to copy a multiple selection. The rules don't seem to be documented, but copying a multiple selection is allowed if all of the range selections occupy the same column(s) or row(s). For example, the multiple selection shown in the figure below can be copied.

But when you paste the copied selection, the results may not be what you expect. The formulas are converted to values, and the ranges are pasted as a single range (see the figure below).