Copy and paste sounds like the simplest task in Excel. You click a cell, hit Ctrl+C, click somewhere else, hit Ctrl+V, done. And for plenty of jobs, that really is the whole story. But the moment you start moving formulas, dragging blocks between sheets, pulling data out of a browser, or trying to keep formatting intact across workbooks, the simple shortcut starts misbehaving. Numbers turn into text. Formulas point at the wrong cells. Column widths collapse. Conditional formatting vanishes or doubles up. Hidden rows appear out of nowhere.

This guide covers every paste method Excel offers and the situations each one solves. You will learn the keyboard shortcuts that real Excel users lean on, the Paste Special menu that almost nobody opens but everybody needs, the difference between copying values and copying formulas, how to handle paste across sheets and workbooks, and the most common errors that turn a five-second task into a twenty-minute mess. Once you know which paste mode to reach for, Excel stops fighting back.

The methods covered here work in Excel for Windows, Excel for Mac, Excel for the web, and Excel on mobile, with notes on differences where they matter. Shortcuts use the Windows convention (Ctrl) by default. On Mac, swap Ctrl for Cmd unless the method specifically says otherwise. The Paste Special dialog and Ribbon paths look almost identical across versions, with the biggest differences appearing in older builds (2013 and earlier) where a few preview options are missing.

The core copy-paste workflow has three steps. Select what you want to move. Copy or cut it. Click the destination and paste. To select a single cell, click it. To select a range, click the first cell and drag across the others, or click the first cell and Shift+click the last cell of the range.

To select non-adjacent ranges, hold Ctrl and click each cell or range separately. To select an entire row or column, click the row number or column letter. To select the whole sheet, press Ctrl+A or click the small triangle in the top-left corner where the row and column headers meet.

Copy puts a duplicate on the clipboard and leaves the original in place. Cut puts a duplicate on the clipboard and removes the original when you paste. You will see a moving dashed border (often called the marching ants) around the copied range until you paste, switch sheets, or press Esc.

The border is your visual reminder that the clipboard is loaded. If the border disappears before you paste, Excel has cleared the clipboard and you need to copy again. Some actions like saving the file or typing into another cell can quietly clear the clipboard, which surprises new users.

Most people only ever use the default Ctrl+V paste, which works fine until it does not. The classic failure happens when you copy a calculated total from one workbook and paste it into another. The pasted cell shows #REF! errors because the formula is now pointing at cells that do not exist in the destination workbook.

The fix is Paste Values, which converts the formula result into a plain number that travels safely. Another common situation is copying a styled table where you want only the numbers, not the colors and borders. Paste Values strips the formatting and gives you clean data.

To use Paste Values quickly, copy your range, click the destination, then press Ctrl+Shift+V if you are on a recent Microsoft 365 or Excel 2024 build. On older versions, press Ctrl+Alt+V to open the full Paste Special dialog and then press V to choose Values, followed by Enter. Both routes produce identical results. The Ctrl+Shift+V shortcut is faster but only exists in newer builds, so the Paste Special dialog remains the universal method that works everywhere.

Paste Special is where Excel hides its most useful tricks. Open it with Ctrl+Alt+V (Windows) or Cmd+Ctrl+V (Mac) after copying a range. The dialog presents a grid of paste options including All, Formulas, Values, Formats, Comments, Validation, All using source theme, All except borders, Column widths, Formulas and number formats, Values and number formats, and All merging conditional formats. Below that, an Operation section lets you add, subtract, multiply, or divide the destination cells by the copied values without using any formula. Two checkboxes at the bottom toggle Skip blanks and Transpose, two features that solve specific problems elegantly.

Skip blanks is useful when you have two ranges of the same shape and you want to overlay one onto the other without overwriting the destination where the source is empty. Copy the source, click the destination, open Paste Special, check Skip blanks, paste. Any blank cells in the source leave the destination cells untouched.

Transpose flips rows and columns. Copy a vertical list of seven cells, click an empty destination, open Paste Special, check Transpose, paste. The vertical list becomes a horizontal row. Combined with Paste Values, transpose converts a wide pivoted table into a tall table or vice versa in two clicks.

Drag and drop is an alternative to copy and paste that some users prefer for short moves. Select a range, hover the mouse over the edge of the selection until the cursor changes to a four-headed arrow, then drag the selection to the new location.

By default, drag and drop moves the data (equivalent to cut and paste). To copy instead of move, hold Ctrl while dragging. The cursor adds a small plus sign indicating copy mode. To insert the dragged data between existing cells rather than overwriting them, hold Shift while dragging. The destination cells slide aside to make room.

The fill handle, that little green square in the bottom-right corner of a selected cell, is another copy-paste shortcut hiding in plain sight. Click a cell with content, grab the fill handle, drag down or across. Excel copies the cell, with intelligent behavior for series.

A cell containing a date will fill subsequent dates. A cell containing a number followed by another cell with the next number in a sequence will continue the pattern. A formula will copy with relative references adjusted. Double-click the fill handle to auto-fill down to the end of an adjacent column, which is the fastest way to apply a formula to every row of a dataset.

The Office clipboard panel is a feature most users never discover. On the Home tab, look for a small arrow at the bottom-right corner of the Clipboard group. Clicking it opens a sidebar showing the last 24 items you copied across any Office application. You can paste any of them by clicking, or paste all of them with a single button.

The clipboard panel is especially useful when you are pulling small pieces of data from multiple sources because each copy adds to the panel without overwriting the previous one. Closing the panel and reopening it preserves the entries until you exit Excel.

Excel also supports clipboard history through Windows itself. Press Windows+V on Windows 10 or later to open the system clipboard with the last 25 text items copied anywhere on the system, including from Excel. Pinning items keeps them across reboots.

The Windows clipboard and the Office clipboard are separate, so something might appear in one and not the other depending on how you copied it. For pure Excel work, the Office clipboard inside Excel is the more reliable choice because it preserves cell formatting and formulas, not just the displayed text.

Copying and pasting formulas is where most paste errors originate. Excel formulas use two reference types: relative and absolute. A relative reference like A1 shifts when copied. An absolute reference like $A$1 stays locked. Mixed references like $A1 (column locked, row relative) or A$1 (row locked, column relative) shift in only one direction. Pressing F4 while editing a formula cycles through the four combinations: A1, $A$1, A$1, $A1. Choosing the right reference type before copying is the single most important habit to develop because it eliminates most copy-paste formula errors.

When you copy a formula from cell B2 that says =A2*1.05 and paste it into B3, Excel adjusts the formula to =A3*1.05. That is relative behavior. Copy the same formula into D5 and you get =C5*1.05. The reference shifts both down (rows) and across (columns) to match the new location.

If you want the formula to always multiply by the value in cell A2 regardless of where it is pasted, write the source as =$A$2*1.05. Now pasting into B3 still produces =$A$2*1.05. Paste it into D5 and it remains =$A$2*1.05. Understanding this single concept solves about half of all formula copy-paste problems users encounter.

The format painter is technically a paste tool even though it does not use the clipboard the same way. Click a source cell, click the paintbrush icon on the Home tab, then click or drag across destination cells. Excel applies the source formatting (fonts, colors, borders, number formats, conditional formatting rules) to the destination without changing values or formulas. Double-click the paintbrush icon to lock it on, then click the paintbrush again or press Esc when done. Format painter is faster than Paste Special Formats when you are doing small formatting touch-ups across many disconnected ranges.

Pasting into filtered or sorted ranges can produce surprising results. When a column is filtered, the visible cells are not always contiguous. Pasting a range of three values into a filtered range may write to three visible cells, or it may write to three contiguous cells including hidden ones, depending on the Excel version and paste method.

As a general rule, do not paste into filtered ranges if you can avoid it. Clear the filter, paste, then reapply the filter. If you must paste into a filtered range, use Alt+; to select only visible cells before copying so you know exactly what is being moved.

For larger datasets, the most efficient way to copy is to select using keyboard shortcuts. Ctrl+Shift+Down selects from the current cell to the bottom of the column data. Ctrl+Shift+Right selects from the current cell to the right edge of the row data. Combining them with Ctrl+Shift+End selects from the current cell to the bottom-right corner of the used range. These shortcuts let you grab thousands of rows in two keystrokes without dragging the mouse. After selecting, Ctrl+C copies and you can paste anywhere normal selection rules apply.

If you frequently move data between Excel and another application, learn that application's paste conventions too. Pasting Excel data into PowerPoint defaults to a linked picture that updates if the source changes. To paste as a static table, use Paste Special in PowerPoint and choose Microsoft Excel Worksheet Object or Picture. Pasting into Word offers similar options including HTML formatted text, plain text, and linked or embedded objects. Each destination application has its own Paste Special dialog and the same logic applies: pick the format that matches how you want the destination to behave when the source changes.

Pasting large ranges can also slow Excel down noticeably. A single Ctrl+V on a sheet that uses heavy conditional formatting, many array formulas, or thousands of data validation rules triggers a full recalculation. If you are pasting tens of thousands of rows, switch calculation to manual before pasting (Formulas tab, Calculation Options, Manual). Paste, verify the result, then switch back to Automatic and press F9 to recalculate. The same advice applies to disabling screen updating when running macros that paste data inside a loop. Both tricks shave seconds or minutes off large operations and stop Excel from feeling frozen.

When you paste across protected sheets, Excel may refuse to paste with a message that the cell or chart is protected. Sheet protection only blocks paste into locked cells, so the simplest workaround is to unprotect, paste, and reprotect. If you cannot unprotect the sheet, the destination cells are locked by the owner intentionally. Copying values out of a protected sheet is allowed unless the owner also disabled the Select locked cells option in the protection settings. Pasting into a protected workbook with a password requires the password to disable the protection first.

Mac users have a few keyboard differences worth noting. Copy is Cmd+C, paste is Cmd+V, cut is Cmd+X, and Paste Special opens with Cmd+Ctrl+V (not Cmd+Option+V as you might guess).

The F4 key for cycling reference types works the same on Mac but on some keyboards you need to press Fn+F4 first or set the function keys to behave as standard function keys in System Settings. Paste Values on Mac uses the same Paste Special dialog approach since Cmd+Shift+V is reserved for other Mac functions in some setups. Drag and drop, fill handle, and the format painter all work identically on Mac.

Excel for the web has a slimmer set of paste options. Default paste, paste values, paste formulas, and paste formatting are available, but the full Paste Special dialog with math operations and transpose is not present in browser-only versions. For complex paste operations, open the workbook in desktop Excel through the Edit in Desktop App option.

Excel for the web does respect the system clipboard, so you can copy from another browser tab or application and paste into a sheet without losing standard formatting. Numbers paste as numbers, dates as dates, and formulas paste as formulas when copying within Excel for the web.

One more situation worth covering is copying conditional formatting. By default, Ctrl+C and Ctrl+V copy conditional formatting along with everything else. If you want to copy only conditional formatting without values or other formatting, open Paste Special and choose Formats. The Formats option transfers all visual styling including conditional formatting rules, which is useful when you have built a complex set of rules on one range and want to apply the same rules elsewhere. Conditional formatting rules with relative references adjust automatically to the new range, just like regular formulas do during copy and paste.