Problems With Excel Copy and Paste Multiple Selections. http://www.contextures.com/xlDataEntry01.html In Excel, you can run into problems when you copy multiple ranges and try to paste them to a new location.
If you select ranges that aren't the same size, and try to copy them, you'll see an error "That command cannot be used on multiple selections"
Another problem is that values are pasted, instead of formulas, when you paste multiple ranges.
See the steps for copying and pasting multiple selections in this short Excel video tutorial.
Tags: Problems With Excel Copy and Paste Multiple Selections, Excel copy, Excel, Excel copy and paste, Excel video tutorial, copy and paste, copy multiple ranges, Contextures