A basic guide explaining how to move columns in LibreOffice Calc.
Often it is required to move cells in LibreOffice Calc spreadsheets. It is one of the fundamental skills to have for spreadsheet users. This is used mostly for organizing data sets, tables or to optimize workflow.
Moving columns in LibreOffice has some confusing steps. It’s a little different from traditional Microsoft Excel.
Here’s how you can move.
Move LibreOffice Calc Columns
- If you select the header and try to drag the column, it won’t work.
- Because LibreOffice Calc only selects the column once clicked. You can’t drag it.
- To move it, select the column by clicking on the header.
- Now, click on any cell in that column (not on the header)
- Keep the left mouse button pressed, and drag the cursor to the designed section. The column and all its contents will move.
- That’s it.
Here’s a quick demo how you can do.
Usage Notes
- Before moving a column, ensure you are not overwriting any data in the target column.
- Using the above method, LibreOffice Calc replaces the target column entirely.
- If you want to move a column without modifying any existing data, use CUT and PASTE by selecting the entire column. See below.
That’s it.