Go to the updated, HD version of this video.
https://youtu.be/KxFEPYdcymU

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.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.