Easy Keyboard Shortcut to Cut a Cell Value in Excel

Sharing is caring!

Cutting a cell value in Excel is a basic but essential task. It helps when you’re moving data, organizing information, or simply cleaning up your spreadsheet. Instead of using your mouse every time, you can save time with keyboard shortcuts.

In this guide, we will teach you how to cut a cell value in Excel using keyboard shortcuts, covering Windows and Mac. You’ll also learn how to cut ranges, use shortcuts in Excel tables, and common issues that might come up.

Basic Shortcut to Cut a Cell in Excel

Windows Shortcut

To cut a cell in Excel on Windows:

• Select the cell
• Press Ctrl + X

This shortcut removes the content from the original location and makes it ready for pasting somewhere else.

Mac Shortcut

To cut a cell on Excel for Mac:

• Select the cell
• Press Command (⌘) + X

Whether you’re using a desktop or laptop, this shortcut works across most Excel versions including Excel 2016, Excel 2019, Excel 2021, and Microsoft 365 Excel.

Visual Example

Let’s say you want to cut the value from cell B2 and paste it in D2.

• Select B2 → Press Ctrl + X (or ⌘ + X on Mac)
• Go to D2 → Press Ctrl + V (or ⌘ + V)

Result:

How to Cut Multiple Cells or Ranges

You can also use shortcuts to cut multiple cells, not just one.

Steps to Cut a Range

1. Select a range (for example, B2:B5)
2. Press Ctrl + X (or ⌘ + X)

This cuts all the selected values, keeping their formatting intact.

Example

Select cells B2:B5 → Press Ctrl + X → Move to C2 → Press Ctrl + V

Result:

Cutting Values Inside Excel Tables

When working with Excel tables, cutting works similarly but with one key difference: tables automatically shift to fill the gap.

Example:

• Cut cell B2 (Quantity 50) → Ctrl + X
• Paste in a new cell outside the table

Excel adjusts the table, often leaving a blank cell or moving data upward, depending on the paste location.

How to Cut and Paste Between Worksheets

If you want to move data from one worksheet to another, the same shortcut applies.

1. Select the cell(s) in Sheet1.
2. Press Ctrl + X
3. Switch to Sheet2 (use Ctrl + Page Down to switch tabs)
4. Select a cell → Press Ctrl + V

This helps when you’re organizing data across sheets, like monthly reports, sales tracking, or inventory updates.

Cut and Paste Between Excel Files

You can even use keyboard shortcuts to move content between different Excel files.

1. Select the content in File A → Press Ctrl + X
2. Switch to File B using Alt + Tab
3. Select the target cell → Press Ctrl + V

This method is faster than using right-click menus or ribbon commands.

Keyboard Shortcuts for Other Cut-Related Actions

Excel provides more shortcuts that are useful when cutting or editing data.

These help when you’re cleaning data, adjusting layouts, or working with bulk records.

Best Practices When Using Cut in Excel

Cutting values is easy, but it can cause issues if you’re not careful.

Avoid Cutting Formulas That Reference Other Cells

If you cut a cell that contains a formula, and it references another cell, the formula might break when moved.

Example:

• Formula in B2: =A2 + A3
• If you cut and move B2 elsewhere, it may still reference A2 and A3, even though the logic no longer fits.

Use Paste Special When Needed

If you’re only interested in values and not formulas or formatting, use Paste Special.

Steps:

1. Press Ctrl + X to cut
2. Go to the destination
3. Press Ctrl + Alt + V
4. Choose Values → Press Enter

This keeps your data clean and prevents formula issues.

Common Errors When Cutting Cells

1. #REF! Error

If you cut a cell that other formulas depend on, you may see a #REF! error.

Fix: Make sure to update formulas or use Paste Special > Values.

2. Merged Cells Error

You can’t cut a range if it contains merged cells. Excel will show an error.

Fix: Unmerge the cells before cutting.

3. Read-Only Worksheet

If you’re trying to cut from a protected or read-only sheet, Excel won’t allow edits.

Fix: Unprotect the sheet under Review > Unprotect Sheet, if you have permission.

Cutting Values Using the Excel Ribbon (as Backup)

Although this article focuses on keyboard shortcuts, it’s useful to know where the Cut command is in the Ribbon.

• Go to the Home tab
• Click on Cut (scissors icon)

You can also use the right-click menu, but that’s slower than the keyboard.

When to Use Cut vs. Copy in Excel

Many users confuse Cut and Copy. Here’s a quick comparison:

Tip: Use Cut when you’re reorganizing data. Use Copy when you’re making backups or building templates.

Summary

Knowing how to cut a cell value in Excel using keyboard shortcuts can make your work faster and more efficient. Whether you’re using Ctrl + X on Windows or Command + X on Mac, the method is simple and consistent.

From cutting a single cell to handling ranges, tables, or even cross-file moves, mastering this shortcut boosts your productivity. Remember to be cautious with formulas and use Paste Special when needed.

FAQs

Vaishvi Desai

Vaishvi Desai is the founder of Excelsamurai and a passionate Excel enthusiast with years of experience in data analysis and spreadsheet management. With a mission to help others harness the power of Excel, Vaishvi shares her expertise through concise, easy-to-follow tutorials on shortcuts, formulas, Pivot Tables, and VBA.