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

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.


Download Practice Workbook

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


4 Ways to Cut and Paste in Excel

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

You can also access the cut-and-paste features from the right-click options.

  • 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.

Read More: How to Cut Filtered Rows in Excel (with Quick Steps)


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 on the desired destination cell.

drag and drop range within the worksheet

Read More: [Fixed!] Cut and Paste Not Working 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.

Conclusion

Now you know the 4 quickest ways to cut and paste in excel. Which method do you prefer the most? Do you have any further queries or suggestions? Please let us know in the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.


Related Articles

Tags:

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo