# How to Cut in Excel

Get FREE Advanced Excel Exercises with Solutions!

In this article, you will learn how to cut in Excel with paste using different quick features. You will also learn to cut using formulas and multiple cells in Excel.

Cutting and pasting enable you to perform data manipulation tasks, such as moving data from one location to another, merging data from different sources, or splitting data into separate cells or columns.

You can reorganize data to perform various analyses, such as sorting, filtering, or creating charts by cutting and pasting data, which can provide valuable insights about your data range.

## How to Cut and Paste in Excel

### 1. Apply Keyboard Shortcut

• Select cell B5 and press Ctrl+X.

• Then, select cell E5 and press Ctrl+V.

### 2. Use the Ribbon

• Select cell B6 and go to Clipboard group from Home tab.
• Choose Cut.
• Move to cell E6 and choose Paste from Clipboard group.

• Look at the dataset now.

### 3. Apply Mouse Drag and Drop

• First, select cell B5 and take the mouse to the cellâ€™s border. When it turns into a cross shape, left-click on the mouse and drag it to cell E5.

### 4. Use Context Menu of Excel

• Select cell B5 and right-click on your mouse.
• Choose Cut option.

• Move to cell E5 and right-click on your mouse.
• Choose Paste option.

The selected cell will be pasted here.

## How to Cut Using Formula in Excel

### 1. Apply Combination of LEFT and LEN Functions

• Type this formula based on the combination of LEFT and LEN functions on cell E5 and press Enter.
`=LEFT(B5,LEN(B5))`
• Then use Fill Handle to copy the formula to the rest of the rows.

### 2. Use Combination of RIGHT and LEN Functions

• Type this formula based on the combination of RIGHT and LEN functions on cell E5.
`=RIGHT(B5,LEN(B5))`
• Then use Fill Handle to copy the formula to the rest of the rows.

## How to Cut Multiple Cells in Excel

• Select your entire range and press Ctrl+X.

• Then, select the first cell of your destination and press Ctrl+V.

1. How do I cut and paste data without including hidden cells or rows in Excel?

Ans: You canâ€™t cut and paste data in Excel without including hidden cells or rows. However, you copy and paste data in Excel without including hidden cells or rows. Follow these steps:

• Select the range of cells you want to copy.
• Press Ctrl+G to open the Go To dialog box.
• Click on the SpecialÂ option.
• Select Visible cells only and click OK.
• The visible cells within the selected range will be highlighted.
• Copy the selected cells using Ctrl+C and paste them elsewhere using Ctrl+V.

2. Does cutting affect any references or formulas in Excel?

Ans: When you cut and paste cells in Excel, it does not affect the references or formulas in the cut cells. The references and formulas remain intact and maintain their original references. The cut operation only moves the data to a new location while preserving the formulas and references.

3. Does cutting in Excel affect data validation rules or conditional formatting applied to the cut cells?

Ans: When you cut cells in Excel, the data validation rules and conditional formatting applied to the cut cells are retained. This allows you to move the data without affecting the validation rules or conditional formatting, ensuring that the data remains consistent and formatted according to the specified criteria.

## Conclusion

In conclusion, cut in Excel is a useful operation that allows you to move data from one location to another within a worksheet or between different worksheets or workbooks. You can follow the keyboard shortcut method or use the context menu or formulas depending on your working criteria. These methods are to save you from spending too much time on necessary tasks.

## Cut in Excel: Knowledge Hub

<< Go Back to 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.
Mehedi Hassan

Mehedi Hassan, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, functions as an Excel & VBA Content Developer at ExcelDemy. His deep interest in research and innovation aligns seamlessly with his fervor for Excel. In this role, Mehedi not only skillfully addresses challenging issues but also exhibits enthusiasm and expertise in gracefully navigating intricate situations, emphasizing his unwavering dedication to consistently delivering outstanding content. His interests are Advanced... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF