How to Cut and Paste in Excel (4 Quick Ways)

Get FREE Advanced Excel Exercises with Solutions!

This article illustrates how to cut and paste in Excel. Cut and Paste is one of the most used features in Excel. You can use this feature to move data within the worksheet, to another sheet, or to another workbook. In this article, we will discuss 4 quick ways to use this feature in Excel. Follow along to know how to do that.


How to Cut and Paste in Excel: 4 Quick Ways

We will use the following dataset to illustrate the methods. Assume you need to cut the Sales column and paste it onto the next column.

dataset to lillustrate how to cut and paste in Excel

Follow the methods below to do that.


1. Cut and Paste Using Keyboard Shortcuts

You can use the CTRL + X and CTRL + V shortcuts to quickly cut and paste data in Excel.

  • First, select the Sales column (range D4:D10). Then press CTRL + X to cut the selected data. After that, you will see a dancing border around that range. Now select the destination cell (E4) where you want to paste the data. Then press CTRL + V to paste the data.

press CTRL+X to cut and CTRL+V to paste

  • After that, you will see the following result.

result after cut and paste


2. Use Cut and Paste Icons

Alternatively, you can use the cut and paste icons available in the Clipboard group in the Home tab.

  • First, select the Sales column (range D4:D10). Then click on the Cut icon (scissors-shaped) in the clipboard group from the Home tab.

click on the Cut icon

  • Now select the destination cell (E4) where you want to paste the data. Then click on the Paste icon just beside the Cut icon.

click on the paste icon

  • After that, you will get the same result as earlier.

3. Right-Click to Cut and Paste in Excel

Do you want to know how to cut and paste in Excel by right-clicking?

  • First, select the Sales column (range D4:D10). Then right-click on the selected range. Next, select the Cut option.

select > right-click > cut

  • Now select and right-click on the destination cell (E4) where you want to paste the data. Then click on the Paste icon.

select > right-click > paste

  • After that, you will get the same result as earlier.

4. Drag & Drop to Move Data in Excel

You can also drag and drop a range to move data within the same worksheet.

  • First, select the desired range (D4:D10). Then put the cursor at the border of the selection. You will see a four-sided arrow. Now drag the selected range and drop it on the desired destination cell.

drag and drop range within the worksheet

Read More: How to Cut Text Using Formula in Excel


Things to Remember

  • The cut and paste feature won’t allow you to paste as special.
  • You can drag and drop a range within the same worksheet only.

Download Practice Workbook

You can download the practice workbook from the download button below.


Conclusion

In this article, we learned how to cut and paste in Excel with the 4 quickest ways. Which method do you prefer the most? Do you have any further queries or suggestions? Please let us know in the comment section below. Stay with us and keep learning.


Related Articles


<< Go Back to Cut in Excel | Copy Paste in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Md. Shamim Reza
Md. Shamim Reza

Md. Shamim Reza, a marine engineer with expertise in Excel and a fervent interest in VBA programming, sees programming as a time-saving tool for data manipulation, file handling, and internet interaction. His diverse skill set encompasses Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He holds a B.Sc in Naval Architecture & Marine Engineering from BUET and has transitioned into a content developer role, generating technical content focused on Excel and VBA. Beyond his professional pursuits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo