Cut, Copy, and Paste in Excel: Shortcuts and Steps

To cut, copy, or paste in Excel for Microsoft 365 on Windows, select the cell or range and press Ctrl+X to cut, Ctrl+C to copy, or Ctrl+V to paste. You can also use the Cut, Copy, and Paste buttons on the Home tab; cutting moves selected content, while copying leaves the original in place.

What Cut, Copy, and Paste Do

These commands transfer cell contents from one place to another, but they do different things. Cut prepares the selected cells to be moved. Copy prepares a duplicate. Paste puts the prepared content into the destination you select. The source of cut content is not cleared immediately: Excel shows a moving dashed outline around it until you paste or cancel the operation.

For example, if a project name is in A2 and you cut it, then paste it into D2, the name moves to D2 and is removed from A2. If you copy A2 instead, pasting into D2 creates another copy while A2 remains unchanged. A copied range can be pasted more than once. A cut selection is intended to be moved, and the cut operation ends when the content is pasted or canceled.

Excel can transfer more than visible text. Depending on the paste option, a cell or range can include values, formulas, number formats, borders, fill colors, comments or notes, and other cell properties. This is why pasting into an existing area can change its appearance or replace its contents as well as its displayed values.

Use the Keyboard or Ribbon

Keyboard shortcuts are usually the quickest option. First select the cell or range, issue the cut or copy command, select the destination, and paste. To cancel a cut or copy before pasting, press Esc. To choose a destination on another worksheet, click its sheet tab before selecting the destination cell; to move between workbooks, make the destination workbook active.

Ctrl+X: cut the selection.
Ctrl+C: copy the selection.
Ctrl+V: paste at the active cell or into the selected destination range.
Esc: cancel the active cut or copy outline.

For ribbon commands, select the cells, then choose Home > Cut or Home > Copy in the Clipboard group. Select the destination and choose Home > Paste. The Paste button’s dropdown offers additional choices, such as pasting values or formulas. Right-clicking a selected cell also provides Cut and Copy in the context menu; right-click the destination to find paste options.

When pasting a range, the active cell is the upper-left destination. If you copy a block that is three columns wide and two rows tall, select the upper-left destination cell and paste; Excel fills a block of the same dimensions. A destination range of a different size can produce an error or an unexpected result, so selecting just the upper-left cell is a reliable default.

Move Cells Without Replacing Other Data

Ordinary paste places the cut cells over the destination area. If the destination already contains data, pasting can replace it. To insert the cut cells while shifting existing cells out of the way, cut the range, right-click the destination, and choose Insert Cut Cells. Excel then asks whether to shift the existing cells right or down when the layout requires a choice. Check the surrounding data before confirming, because shifting cells can affect the shape of a table or the alignment of related columns.

You can also move a selection by dragging its border to another location, but this is easier to do accidentally, especially in a busy worksheet. For a deliberate move, cut and paste makes the source and destination clearer. If you drag cells, make sure the pointer is on the selection border and look for the move pointer before releasing the mouse button.

Moving a whole row or column differs from moving only a cell range. Click the row number or column letter to select the entire row or column, then cut and paste it at the intended location. Pasting a cut row onto another populated row can replace cells, so use Insert Cut Cells when the goal is to insert the row and push existing rows down. Avoid selecting only part of a row if the data is meant to remain aligned across the worksheet.

Choose the Right Paste Option

Excel’s paste options help when you want only part of what was copied. After copying, use the Paste dropdown on the Home tab or right-click the destination to inspect the available options. The exact icons shown depend on what you copied, but common choices include keeping the source formatting, matching the destination formatting, pasting formulas, and pasting values.

Values: pastes the displayed results rather than formulas. This is useful when sharing a finished report or freezing results that should not recalculate.
Formulas: pastes formulas without carrying over all the source formatting.
Formats: applies formatting without replacing the destination’s values.
Transpose: switches rows and columns when pasting a copied range. For example, a copied row can be pasted as a column.
Paste Special: opens a dialog with more specific choices, including values, formulas, formats, and operations such as adding or multiplying pasted values by existing destination values.

On Windows, Ctrl+Alt+V opens the Paste Special dialog after you copy or cut a selection. You can also open it from Home > Paste > Paste Special. Not every paste option is appropriate for every task: pasting values is not a substitute for copying a formula when the result needs to update as source data changes. When in doubt, use a small test area or undo immediately with Ctrl+Z if the result is not what you intended.

What Happens to Formulas and Formatting

Copying a formula can change its relative cell references to suit the new location. For example, a formula that refers to a cell one column to the left may refer to the cell one column to the left of its new position after it is copied. Absolute references, marked with dollar signs, are designed to stay fixed in the specified row or column when a formula is copied. This difference matters when duplicating calculations across a worksheet.

Cutting and moving a formula is not the same as copying it. Excel generally keeps the formula’s references to the cells it used, rather than adjusting them as if you had created a second formula in a new location. Excel may also update other formulas that refer to cells being moved. Because formulas can depend on several parts of a workbook, check important calculations after moving cells, especially when moving across sheets or into a different layout.

Formatting can travel with a normal paste, so a destination cell may take on the source’s number format, borders, font, or fill. If you only want a value, use the Values paste option; if you want the destination to keep its appearance, choose a paste option that does not bring source formatting. For instance, pasting a date value with a general format may display it differently from the original date-formatted cell even if the underlying value is the same.

Common Problems and How to Fix Them

Paste replaces existing data: normal paste writes over the destination cells. Undo with Ctrl+Z if you have not made subsequent changes, or repeat the operation using Insert Cut Cells when you need to make room.
The copied outline disappears: pressing Esc, starting another cut or copy, or completing a paste can end the active selection. Copy the source again if necessary.
Excel reports that the copy area and paste area differ: the selected destination may not match the copied range’s shape. Select only the destination’s upper-left cell and paste again.
Only part of the result appears: merged cells, a protected worksheet, or a destination with a different shape can constrain the operation. Check whether the sheet is protected and whether the copied and destination areas have compatible layouts.
Cells seem to paste in an unexpected place: confirm the active worksheet and active cell before pressing Ctrl+V. The active cell, not the mouse pointer, determines where a keyboard paste begins.
Copied data does not look the same: inspect the paste option and destination number format. A value-only paste, formula paste, or formatting choice can produce a different appearance from a standard paste.

Filtered lists deserve extra care. A normal copied range may include cells that are hidden by a filter, and pasting into a filtered range can be confusing if the visible rows are not consecutive. If the task is limited to visible cells, select those cells explicitly before copying; Excel’s Go To Special dialog includes a Visible cells only option. Review the selection outline and the destination before pasting so hidden rows are not inadvertently included in the operation.

Cut, Copy, and Paste on Mac and the Web

In Excel for Mac, the familiar shortcuts use the Command key: Command+X cuts, Command+C copies, and Command+V pastes. The ribbon and right-click menus provide the same basic commands. The Paste Special shortcut differs from Windows; Control+Command+V opens Paste Special in Excel for Mac. Keyboard behavior can vary with macOS settings or other software, so the ribbon is a useful alternative if a shortcut is intercepted.

Excel for the web also provides cut, copy, and paste through its ribbon and standard keyboard shortcuts, though browser and operating-system clipboard permissions can affect copying between Excel and other applications. If a browser blocks an operation, use the on-screen ribbon command or follow the browser’s permission prompt. The desktop Excel application is often more convenient for complex Paste Special work, while basic cell transfers work in both environments.

Frequently Asked Questions

How do I cut and paste in Excel using the keyboard?
Select the cell or range, press Ctrl+X, select the destination, and press Ctrl+V. On a Mac, use Command+X and Command+V.

How do I copy a cell without changing the original?
Select the cell, press Ctrl+C on Windows or Command+C on Mac, select the destination, and paste. Copying leaves the original cell in place; cutting is the command that moves it.

How do I paste values only in Excel?
Copy the source, select the destination, then choose the Values option from the Paste dropdown on the Home tab or the right-click menu. This pastes results instead of formulas and avoids bringing across the full set of source formatting.

How do I move a row without overwriting another row?
Select the row by clicking its row number, cut it, right-click the row where it should go, and choose Insert Cut Cells. This inserts the cut row and shifts existing rows rather than simply pasting over their contents.

Why does Excel change a formula when I copy it?
Excel adjusts relative references when a formula is copied so they reflect the formula’s new position. If a reference must stay fixed when copying, use an absolute reference with dollar signs, or choose a paste option that suits the calculation. Moving a formula with cut and paste behaves differently from creating a copy.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.