How to copy and paste multiple cells in excel to another sheet
- how to copy multiple selections in excel
- how to copy multi selection in excel
- how to copy multiple cells in excel
- how to copy multiple rows in excel
This action won't work on multiple selections copy paste excel...
How to copy multiple cells in excel that aren't next to each other
Error Message: That command cannot be used on multiple selections
- Article
- Applies to:
- Excel 2000
Symptoms
When you attempt to copy nonadjacent cell or range selections, you may receive the following error message:
That command cannot be used on multiple selections.
Cause
These error messages may occur when your cell or range selections are in different columns or different rows.
You can, however, copy and paste nonadjacent ranges without getting an error message if your selection contains any of the following:
Multiple rows within the same column, for example, A1, A3, A5.
Multiple columns within the same row, for example, A2, C2, E2.
Multiple rows and columns within the same columns and rows, for example, A1, C1, A3, C3, A5, C5.
More information
When you make a nonadjacent selection and then click Copy on the Edit menu, Excel tries to identify an outline type of the selection.
Because Excel "slides" the ranges together and pastes them as a single rectangle, a contiguous rectangle must remain if the rows and columns in between the selected cells are c
- how to copy multiple cells in excel without dragging
- how to copy multiple rows in excel and paste into one cell