Excel: cut and move function


YOUR OBJECTIVE

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?

Excel Cut

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.

First select the cell range that you want to move. Click in the Clipboard group on the Home tab. 

 

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.

HINT

You can also use the pop-up menu to cut out a selected section. Right-click on the selected section and select excel Cut. 

Paste

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.

KEY COMBINATION:

You can also press [Ctrl]+[V] to access the Paste function.

HINT

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.

HINT

You can also use the pop-up menu to paste the cut-out section. Click in the cell where you want to insert the cut-out content and select Paste from the pop-up menu.

HINT

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.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen