Things might work smoothly for a while, then suddenly Excel shows a message that warns you, “This action won’t work on multiple selections.”Įxcel will show that error message if you selected multiple ranges, and those ranges don’t “match up”.įor example, Excel will show a warning message if To follow along with the video, go to my Contextures site, and get the sample file.įirst, here’s an Excel copy and paste problem that you might run into, if you select more than one group of cells on a worksheet, and try to copy them. One problem is sneaky, and you might not even know it’s happening!įirst, watch this short video, to see two problems you might have when copying and pasting multiple selections. See how to fix Excel copy and paste problems when you’re working with multiple selections. Occasionally though, you might run into problems.
Imagine if you had to manually re-enter all that data instead!.
Copying and pasting can save you lots of time in Excel.
