If you want to move the content of a cell to a different place in your table, you can cut it out and paste it into the new position. You can also move it using the mouse.
In this learning module “ Excel cut and move function” you will learn how to move cell content.
HOW DOES THE EXCEL CUT AND MOVE FUNCTION WORK?
To move the content of a cell to a different position, you can cut it out and paste it into the new position. You can therefore not only move cell content within a worksheet, but also to a different spreadsheet or a different Excel file.
The cell range that has been selected in the Excel table is now transferred onto the clipboard. It remains visible in the table until it has been inserted into a different position.
Excel cut: KEY COMBINATION:
Alternatively, you can press [Ctrl]+[X] to access the Cut function.
You can also use the pop-up menu to cut out a selected section. Right-click on the selected section and select excel Cut.
To paste the cut-out section into a new position, click in the relevant position (in the same or a different spreadsheet or in a different Excel file). The active cell in which the top left cell will be pasted is most important here. To paste, click thebutton.
You can also press [Ctrl]+[V] to access the Paste function.
When you have cut out a cell range in Excel it will receive a running border. This frame indicates that the section has been transferred to the clipboard. It will remain there even after pasting. If the border distracts you, press [Esc]. This will remove the border.
You can also move a selected section by dragging it to a different position using the mouse. You will learn more about this in the Copy and move with drag-and-drop learning module.