Copying And Pasting A Multiple Selection
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).
Excel is a complex program, and has been around for a long time. Consequently, it has many obscure nooks and crannies to discover. Some of them are described here.
Keep in mind that some versions of Excel are odder than others. In other words, the things described here may not apply to all versions of Excel.
All Odd Stuff
Browse Oddities by Category
Seen Something Odd?
If you've discovered something weird about Excel, let me know.