Cut and Paste Multiple Cells in Excel

November 1, 2011 at 23:04:53
Specs: Windows 7
Hi I am trying to cut multiple cells in a worksheet and paste them into a different worksheet. I get an error message for both cut and copy saying The command you chose can not be used for multiple selections.

Does anyone know a way around this?

See More: Cut and Paste Multiple Cells in Excel

November 2, 2011 at 05:57:39
I assume that by "multiple cells" you mean noncontiguous multiple cells - i.e. cells that do not border each other. As you have found, Excel will not allow you to do that.

Here is one way around it:

Here is a "oddity" that details situations where it actually does work.

Google the issue for more hits.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question