I have a Microsoft Excel 365 file with a sheet containing a sortable table:
How can I swap 2 columns in this sheet (e.g., swap column H
with column I
)?
What I have tried unsuccessfully:
- Select column
H
and drag-and-drop at the right of columnI
. - Select column
H
, then Ctrl + X, then Ctrl + V at the right of columnI
. - Select column
H
, right-click on it, select cut, and try to paste it at the right of columnI
.
Attempt 1.
does nothing, while 2
and 3
gives me the error message:
The operation cannot be completed for one of the following reasons:
- A selection including cells both inside a table and below it cannot be copied and inserted into that table. Select cells outside the table and try inserting the data again.
- You have attempted to fill data in a way not supported by the table. Give Feedback