How to move columns
When I want to move one or more columns, I select them by clicking in the header but this does not allow me to actually move them.
The click in the header only selects. To actually move your selected column, do the following:
- select the column by clicking in the header,
- click on any cell in the column (not on the header),
- keeping the left button down, drag the cursor to the desired destination. The column will move with it.
For example, starting with:
If you move to column D, you obtain :
It is also possible to directly "permute" the columns:
- after selecting column B, left-click AND press the Alt key,
- move the cursor to column A.
Of course you can also do this kind of thing with copy and paste or paste special with or without a move.