Frequently asked questions - Calc
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
How to move columns
Problem
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.
Explanation
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:
starting point
If you move to column D, you obtain :
Change of column B to D
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.
You get:
Insert B before A
Of course you can also do this kind of thing with copy and paste or paste special with or without a move.