Excel Training: Basic Manipulations (4/5)
Moving one or more cells
Select cells B2 to B4 and place your cursor on the lower edge of the selection to get the following move cursor:
![excel move cells manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-move-cells.png)
To move these cells, click and drag the selection:
![excel drag range cells manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-drag-range-cells.png)
Copy-pasting one or more cells
Right-click on the cells you moved and choose "Copy" (or use the shortcut Ctrl + C):
![excel copy cells manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-copy-cells.png)
Then right-click where you want to paste the cells and choose "Paste" (or the shortcut Ctrl + V):
![excel paste cells manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-paste-cells.png)
In some cases, it may be useful to copy only the values without the formatting (or vice versa), to transpose cells (switching rows and columns), to paste as an image, etc.
In this case, proceed in the same way but instead of "Paste", choose the appropriate option from "Paste Options":
![excel paste special manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-paste-special.png)
Reproducing a formatting
The "Format Painter" tool allows you to very easily reproduce a format on one or more cells.
To apply for example the formatting of cell C5 to other cells, select cell C5 and click on "Format Painter":
![excel format painter manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-format-painter.png)
Then simply select the cells you want to format:
![excel reproduce formatting manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-reproduce-formatting.png)
Automatic line wrap
By default, if the text contained in the cell is longer than the cell, it does not automatically wrap to the next line:
![excel line manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-line.png)
To activate line wrapping, click on "Wrap Text":
![excel auto line wrap manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-auto-line-wrap.png)
To obtain:
![excel line wrap manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-line-wrap.png)
![excel format cell manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-format-cell.png)
Line break within a cell
To wrap to the next line within a cell, press Alt + Enter:
![excel cell line break manipulations 4](https://www.excel-pratique.com/view/en/excel-training/img/manipulations-4/excel-cell-line-break.png)