And this problem can be worse, because Excel doesn’t give you a warning message! Next, here’s another problem you can run into, when working with multiple selections. The next example, won’t cause Excel copy and paste problems, because both selections are in columns A:C. So, be sure that each selection includes exactly the same rows or columns. When you’re selecting the cells, be sure to select regions that are:Įven one wrong cell will cause that error message!
#Copy visible cells only excel office 365 mac how to
Here’s how to avoid that Excel copy and paste problem, so you don’t see the multiple selections copy error. Then you press Ctrl+C to copy (or use another method to copy).then you make another selection in different columns, A:B.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.
0 kommentar(er)
