How to Cut Multiple Cells in Excel (3 Simple Methods)

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.

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.

cut multiple cells

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.

use kewboard to cut multiple cells

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.

cut multiple cells using context menu

Step 2: Then we will right click the mouse. We will see the Context Menu appear.

cut multiple cells context menu

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.

cut multiple cells by context menu

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.

cut multiple cells result

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.

cut multiple cells using home tab

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.

select to cut multiple 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.

cut multiple cells-home tab

We will see our selected cells moved to the destination.

result of cut multiple cells


Conclusion

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.

Tags:

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo