How to Cut and Paste in Excel – 4 Methods

This is the sample dataset.

To cut the Sales column and paste it into the next column:

dataset to lillustrate how to cut and paste in Excel

 


Method 1 – Cut and Paste Using Keyboard Shortcuts

  • Select D4:D10.
  • Press CTRL + X to cut.
  • Select the destination cell (E4) .
  • Press CTRL + V to paste.

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

This is the output.

result after cut and paste


Method 2 – Using the Cut and Paste Icons

 

  • Select D4:D10.
  • Click Cut  (scissors-shaped) in Clipboard (Home tab).

click on the Cut icon

  • Select the destination cell (E4).
  • Click Paste.

click on the paste icon

This is the output.


Method 3 – Right-Click to Cut and Paste in Excel

  • Select D4:D10.
  • Right-click.
  • Select Cut.

select > right-click > cut

  • Select the destination cell (E4) and right-click.
  • Click Paste.

select > right-click > paste

This is the output.


Method 4 – Drag & Drop to Move Data in Excel

  • Select D4:D10.
  • Place the cursor at the border of the selection. You will see a four-sided arrow.
  • Drag the selected range and drop it in the 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 use paste special.
  • You can drag and drop a range within the same worksheet only.

Download Practice Workbook

Download the practice workbook.


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!

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