Md. Shamim Reza
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.
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.
- After that, you will see the following result.
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.
- Now select the destination cell (E4) where you want to paste the data. Then click on the Paste icon just beside the Cut 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.
- Now select and right-click on the destination cell (E4) where you want to paste the data. Then click on the Paste icon.
- After that, you will get the same result as earlier.
Read More: How to Cut Filtered Rows in Excel
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.
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.
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.
