Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

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:

  1. select the column by clicking in the header,
  2. click on any cell in the column (not on the header),
  3. 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:

  1. after selecting column B, left-click AND press the Alt key,
  2. 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.