When we work in Excel sometimes we need to move data from one or multiple cells to another cell or multiple cells. There is no move option in Excel. But no worry Excel has the Cut option available. We can use the Cut option in various ways to cut data from multiple cells in Excel and move those to another destination.
Download Practice Workbook
You can download the practice workbook from here.
3 Simple Methods to Cut Multiple Cells in Excel
We can cut multiple cells in Excel and move the data of those cells to another destination in different ways. We will show here 3 very simple methods to cut multiple cells in Excel.
Method 1: Cut Multiple Cells Using Keyboard Shortcut
We can easily cut multiple cells using a keyboard shortcut. Thanks to Excel. The method is described below stepwise.
Step 1: First we have to select the range of cells whose data we want to cut. The selected range will be highlighted by a green border.
Step 2: Then we need to press and hold CTRL and simultaneously press X. we will see a green dynamic border sometimes called Dancing Ant.
Step 3: Now we have to select the cell from which our destination range will start. In our case, the cell is B14.
Step 4: We need to press CTRL+V.
Now we can see the selected data of our sheet moved.
Method 2: Select the Cells & Use Context Menu to Cut Multiple Cells
Another way to cut multiple cells in Excel is by using the context menu. We will show the steps to do that below.
Step 1: Firstly we need to select the range of cells we want to cut.
Step 2: Then we will right click the mouse. We will see the Context Menu appear.
Step 3: We need to choose the Cut option from the context menu. We will see a dynamic border around the selected cells to cut.
Step 4: We need to select the 1st cell from where our destination range will start. In our case, the cell is B15.
Step 5: Then we have to right click on the mouse and the Context Menu will appear again.
Step 6: We need to select Paste from the options.
Hurrah! Our selected cells’ data moved to the destination.
Method 3: Using Menu Option on Home Tab
Except for the methods mentioned above, we can also use the Cut option from the Home tab. The steps to do that are given below.
Step 1: Firstly we have to select the range of cells whose data we will cut.
Step 2: Then we have to select the Home tab from the ribbon. Now we choose the Cut option from the list.
We will see a dynamic border around the selected cells.
Step 3: Now we have to select the 1st cell of the destination range. In our case the cell is C14.
Step 4: We have to select the Home tab from the ribbon again. Then we select the Paste option from there.
We will see our selected cells moved to the destination.
For moving data from multiple cells to other cells in Excel, the Cut option is a very efficient way. In this article, we have discussed 3 easy and simple methods to cut multiple cells in Excel. Hopefully, it will be helpful to you. If you face any problems or if you have any suggestions, please let us know by comment.