Copy Paste Excel Keyboard Shortcuts (Windows & Mac)

What You'll Be Able to Do (and a Quick Note Before You Start)

Right-clicking to paste is the slowest habit in Excel, and most people don't realize how much time it costs them. This guide covers copy paste Excel keyboard shortcuts on both Windows and Mac: the core shortcuts, Paste Special, formula copying, and a few things that trip up even experienced users. You'll need Microsoft Excel open, with a workbook in front of you. If you're starting from scratch, the Excel for Beginners starter guide has you covered on setup.

One thing most shortcut articles skip: the difference between pressing Ctrl+V and pressing Enter to complete a paste. Ctrl+V keeps your data on the clipboard so you can paste again. Enter clears it. That distinction becomes important the moment you need to paste the same data into three different places, so keep it in mind as you work through these steps.

---

Step 1: Use the Core Excel Keyboard Shortcuts to Copy and Paste (Windows & Mac)

These are the shortcuts you'll use dozens of times a day. If you're new to Excel, start here. If you've been using Excel for years and still reach for the mouse, this is where to break that habit.

Copying and pasting on Windows with Ctrl+C and Ctrl+V

1. Select the cell or range you want to copy.
2. Press Ctrl+C to copy. A dashed border (the "marching ants") appears around your selection. That's your confirmation the data is on the clipboard.
3. Click the destination cell.
4. Press Ctrl+V to paste. Or press Enter if you only need one paste and want to clear the clipboard immediately after.

To cut instead of copy, use Ctrl+X. Same workflow, but the original data moves rather than duplicates. These three (Ctrl+C, Ctrl+X, Ctrl+V) are the foundation of every cut copy paste Excel shortcut workflow.

Copying and pasting on Mac with Command+C and Command+V

On Excel for Mac, the equivalent shortcuts are Command+C to copy and Command+V to paste. The behavior is identical. One catch: some Mac function key combinations are claimed by Apple system preferences before Excel sees them. If a shortcut isn't responding, open System Settings and check whether a keyboard shortcut is intercepting it. Reassigning or disabling the conflicting system shortcut fixes it.

The Excel Mac copy paste shortcut for cutting is Command+X. Same logic as Windows, different key.

---

Step 2: Copy and Paste Values, Formulas, or Formatting Using Paste Special Shortcuts

Once you've got the basic copy-paste flow down, Paste Special is the next thing to learn, and honestly, it's the one I'd prioritize above everything else in this article. I've watched people spend twenty minutes fixing formatting that a single Paste Special shortcut would have prevented.

Opening Paste Special with Ctrl+Alt+V

After copying a cell, press Ctrl+Alt+V (Windows) or Ctrl+Command+V (Mac) to open the Paste Special dialog box. From there, you can choose exactly what to paste.

The option I use constantly is Values only. In the dialog, press V then Enter. That's it. No formatting comes with it, no formulas, just the raw values. In other words, if a cell displays "1,247" because of an underlying formula, pasting values only gives you the number 1,247 with no formula attached.

This matters more than it sounds. Pasting formulas when you meant to paste values, or dragging in someone else's cell formatting onto a carefully designed report, is the kind of error that takes ten minutes to notice and another ten to fix. Pasting values by default is a professional habit worth building early.

A related option in the dialog: Formats only (press T). Useful for applying a formatting style from one range to another without touching the data underneath.

Skipping the dialog entirely with the new Ctrl+Shift+V shortcut

Microsoft 365 added Ctrl+Shift+V as a faster route to paste as plain text or values, bypassing the dialog entirely. As of 2026 it's still not universally known, and most articles don't mention it, but if you're on a current Microsoft 365 subscription, it's worth testing. It's faster than the full Paste Special dialog for simple values-only pastes. [VERIFY: confirm Ctrl+Shift+V availability and behavior in current Microsoft 365 build for Windows]

The Excel paste special shortcut Ctrl+Alt+V remains the standard for anything more specific, like transposing data or skipping blank cells. Both have their place.

---

Step 3: Copy Formulas in Excel Without Changing Cell References

With Paste Special handled, there's one more copy behavior that catches people off guard: what Excel does to cell references when you copy a formula.

By default, Excel uses relative references. Copy a formula from B2 to B3, and any reference to A2 inside it automatically shifts to A3. Most of the time that's what you want. But if you're copying a formula that should always reference a fixed cell (say, a tax rate sitting in E1), that auto-adjustment breaks things quietly.

The fix is the $ symbol. Change E1 to $E$1 in your formula before copying, and Excel locks that reference in place regardless of where you paste. Press F4 while your cursor is on a cell reference in the formula bar to cycle through the locking options. That's faster than typing the dollar signs manually.

To copy an entire row, select it by clicking the row number, press Ctrl+C, click the destination row number, and press Ctrl+V. The Excel copy paste entire row shortcut is the same as copying a cell. The row selection is the only difference.

---

Common Mistakes With Copy-Paste Shortcuts (and How to Fix Them)

Three things go wrong more often than anything else.

Pasting formatting you didn't want. You copy a cell from a formatted report and paste it somewhere else, and suddenly your destination cell has a different font, border, or background. Use Paste Special (Ctrl+Alt+V → Values) to paste only the data. I do this by default now for any data coming from an external source.

Broken cell references after copying a formula. I used to mess this up constantly in my early days as a staff accountant. The formula looked right, the numbers were wrong, and it took embarrassingly long to find the shifted reference. Lock anything that shouldn't move with $ before you copy. Check the advanced Excel basics guide for a full breakdown of relative vs. absolute references if this is tripping you up.

Losing the clipboard marquee mid-task. If you press Escape after copying (before you've finished pasting), Excel clears the clipboard. The dashed border disappears and Ctrl+V stops working for that content. You'll need to copy again. If you're pasting to multiple destinations, don't press Escape until you're done.

If you take one thing from this article, learn Paste Special (Ctrl+Alt+V) before you think you need it. The first time you accidentally paste three columns of formatting onto a finished report, you'll wish you already knew it.

---