Cut, copy, and paste are the most frequently used operations in Excel. Mastering every variation — from basic Ctrl+C to Paste Special — saves hours every week and eliminates a whole class of formula errors caused by accidentally copying formatting or calculated values instead of raw data.
The Core Three: Copy, Cut, Paste
Copy: Ctrl+C
Ctrl+C copies the selected cell or range to the clipboard. A dashed "marching ants" border appears around the copied cells. The content stays on the clipboard until you press Escape or copy something else. On Mac: Cmd+CCut: Ctrl+X
Ctrl+X cuts the selected cell or range. The cells are marked with a dashed border just like copy, but when you paste, the original cells are cleared. Cut-and-paste also moves formulas and their relative references correctly — the references update to reflect the new location. On Mac: Cmd+XPaste: Ctrl+V
Ctrl+V pastes whatever is on the clipboard into the active cell. If you copied a range, pasting drops the top-left corner of that range at the active cell. On Mac: Cmd+V Important: After pasting, a small Paste Options icon appears near the bottom-right of the pasted range. Click it (or press Ctrl again immediately after pasting) to choose alternate paste modes without opening the full dialog.Paste Special: Ctrl+Alt+V
Ctrl+Alt+V opens the Paste Special dialog, which gives you fine-grained control over exactly what gets pasted. This is one of the most powerful — and most underused — features in Excel. On Mac: Cmd+Ctrl+VThe dialog offers these paste options:
| Option | What It Does |
| All | Pastes everything (default) |
| Values | Pastes only the calculated result, no formula |
| Formats | Pastes only the cell formatting |
| Formulas | Pastes only the formula, no formatting |
| Comments | Pastes only cell comments/notes |
| Validation | Pastes only data validation rules |
| Column widths | Pastes only the column width settings |
| Formulas and number formats | Formula plus number format |
| Values and number formats | Value plus number format |
There is also a Transpose checkbox that flips rows and columns as you paste, and a Skip Blanks checkbox that prevents blank cells in the copied range from overwriting existing data.
Paste Values Only
Pasting values is the single most important Paste Special variant to learn. When you copy a cell with a formula and paste normally, the formula comes along. If the source data changes later, your pasted cell changes too — sometimes that is not what you want. Pasting values locks in the current result.
Three ways to paste values:
Method 1 — Keyboard shortcut:- Copy the cell(s): Ctrl+C
- Click destination
- Press Ctrl+Alt+V, then V, then Enter
- Copy: Ctrl+C
- Paste: Ctrl+V
- Immediately press Ctrl to open the Paste Options mini-toolbar
- Press V to select Values
Paste Formats Only
To copy the look of a cell without its content:
- Copy the source cell: Ctrl+C
- Select the destination
- Ctrl+Alt+V → T (Formats) → Enter
This is useful for applying consistent number formats, borders, or color coding to new cells. For repeated formatting tasks, the Format Painter button on the Home ribbon is often faster.
Paste Formulas Only
To paste only the formula without picking up the source cell's number format or background color:
- Copy: Ctrl+C
- Ctrl+Alt+V → F (Formulas) → Enter
This keeps your destination cell's existing formatting intact.
Fill Down: Ctrl+D
Ctrl+D fills the selected range downward with the content of the topmost cell in the selection. It is faster than copy-paste when you want to extend a formula or value down a column. How to use it:- Type a formula in the first cell of a column, for example =A1*B1 in C1
- Select C1 through C10
- Press Ctrl+D
You can also fill down by double-clicking the fill handle (the small square at the bottom-right of a cell), which automatically fills down to match the length of an adjacent filled column.
Fill Right: Ctrl+R
Ctrl+R fills the selected range to the right with the content of the leftmost cell. The mirror image of Ctrl+D for filling across rows. How to use it:- Type a formula in cell A1
- Select A1 through E1
- Press Ctrl+R
Copy the Cell Above: Ctrl+' (Apostrophe)
Ctrl+' copies the exact value (not the formula) from the cell directly above the active cell. Unlike Ctrl+D, this pastes the raw text or number — not a formula.This shortcut is handy for quickly repeating a date, name, or code from the row above without taking your hands off the keyboard.
On Mac: Ctrl+' (same)A related shortcut is Ctrl+Shift+" (double-quote), which also copies the value from above but works in some older Excel versions where apostrophe does not.
Copy a Value to Multiple Cells at Once
To enter the same value or formula in many non-contiguous cells simultaneously:
- Select all destination cells. Hold Ctrl and click each cell individually, or select a range.
- Type the value or formula.
- Press Ctrl+Enter instead of just Enter.
This technique works for ranges too. Select A1:A10, type =B1*2, press Ctrl+Enter — all ten cells get the formula with adjusted row numbers.
The Clipboard Pane
Excel can hold up to 24 items in its Office Clipboard, not just the last copied item.
To open the Clipboard pane:- Home tab → Clipboard group → click the small launcher arrow in the bottom-right corner of the group.
To clear the clipboard, click "Clear All" at the top of the pane.
Mac vs. Windows: Quick Reference
| Action | Windows | Mac |
| Copy | Ctrl+C | Cmd+C |
| Cut | Ctrl+X | Cmd+X |
| Paste | Ctrl+V | Cmd+V |
| Paste Special dialog | Ctrl+Alt+V | Cmd+Ctrl+V |
| Paste Values (in dialog) | V then Enter | V then Return |
| Fill Down | Ctrl+D | Cmd+D |
| Fill Right | Ctrl+R | Cmd+R |
| Copy value from cell above | Ctrl+' | Ctrl+' |
| Fill selected cells | Ctrl+Enter | Cmd+Return |
Frequently Asked Questions
Why does pasting a formula give me wrong results?When you paste a formula, Excel adjusts relative references based on the distance moved. If you moved the formula two rows down, every relative row reference increases by two. If the results look wrong, check whether your source formula uses absolute references ($A$1) where needed. Use F4 to toggle through reference types while editing a formula.
What is the difference between paste values and paste formulas?Paste Values pastes only the current computed result as a plain number or text — the formula is gone. Paste Formulas pastes only the formula itself, discarding formatting from the source cell. Use paste values when you want to "lock in" a result so it does not change if source data changes.
How do I paste without changing the column width?By default, pasting overwrites column widths. To preserve destination column widths, use Paste Special → "Keep Source Column Widths" (the icon that looks like two columns). Alternatively, paste normally and then click the Paste Options icon to select that option.
Can I paste and transpose (flip rows to columns) at the same time?Yes. Copy your range, go to the destination, open Paste Special (Ctrl+Alt+V), check the Transpose checkbox at the bottom of the dialog, and click OK. The rows become columns and the columns become rows.
Why does Ctrl+D sometimes not work? Ctrl+D fills from the topmost selected cell downward. If you have only one cell selected (or it is the only row), there is nothing to fill. Make sure you select the source cell plus the destination cells below it before pressing Ctrl+D. How do I paste the same value into hundreds of rows quickly?Type the value in the first cell. Then select the entire destination range (you can type in the Name Box — for example A1:A500 — and press Enter to select it). Then press Ctrl+D to fill down, or type the value and press Ctrl+Enter to fill all selected cells simultaneously.