- 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.
For example if you wanted to perform an operation on the following sample data
because a contiguous rectangle remains if you were to collapse row 2 and column B, you can individually select cells A1, C1, A3, C3 and copy them without error. (To make a nonadjacent selection, hold down the CTRL key while selecting additional cells or ranges.)
A1: 1 B1: C1: 2
A2: B2: C2:
A3: 3 B3: C3: 4
This selection will be pasted as a single rectangle:
However, you cannot add cell B2 to this nonadjacent selection, because Microsoft Excel cannot determine which direction you want the cells to slide. For example, B2 could slide between A1 and A3, C1 and C3, A1 and C1 or A3 and C3. This would result in rectangles of varying shapes and sizes. Because you cannot designate how you want the rectangle arranged, Excel returns the error message. In this case, the cell range must be a single selection, or the cells must be copied individually.
A5: 1 B5: 2
A6: 3 B6: 4
Article ID: 214080 - Last Review: Nov 20, 2008 - Revision: 1