To paste a copy of cells in Excel with their contents and formatting, select the source cells, press Ctrl+C, select the destination, and press Ctrl+V. This copies the cells as a whole, but relative references in formulas may adjust to the new location. If you need the formula text itself to stay identical, use the formula-bar method in the steps below.
This guide is for Excel for Microsoft 365 on Windows. The same basic copy-and-paste process works in most recent desktop versions. Excel for Mac and Excel for the web have a few shortcut and clipboard differences, noted where they matter.
What You’ll Need
- An Excel workbook with the cells you want to copy and a destination for the pasted copy.
- Permission to edit the workbook. If a sheet is protected, you may not be able to paste into locked cells.
- A decision about what you mean by exactly the same: all cell contents and formatting, values only, or identical formula text. These are different paste results.
Step-by-Step
-
Select the source cell or range. Click a single cell to copy it, or drag across the cells you need. For a whole column or row, click its letter or number heading. If you copy a range, note its shape—for example, three columns by four rows—because the destination must be able to accommodate it.
-
Copy the selection. Press Ctrl+C on Windows. You can also choose Home > Copy. A moving dashed border around the selection means Excel has copied it and is waiting for a destination. Do not press Esc yet, because Esc cancels the copy selection.
-
Choose the destination. Click the top-left cell where the copied range should begin. For example, if the source is A2:C5 and you want the copy to begin at E2, select E2. Excel will fill the matching three-column-by-four-row area. Check that the destination does not contain information you need to keep: a normal paste replaces the destination cells.
-
Paste the complete copy. Press Ctrl+V, or choose Home > Paste. The standard paste copies the cell contents and most cell-level formatting, including number formats, fills, borders, alignment, and font settings. It also carries items such as formulas and, where applicable, data validation and notes or comments. The exact included items can depend on the source and Excel version.
-
Check formulas before relying on the result. Excel normally adjusts relative references to suit the new position. If A2 contains =B2+C2 and you paste it into A3, Excel changes the formula to =B3+C3. That is usually helpful when copying a calculation down a table, but it is not the same formula text. Absolute references, such as $B$2, stay fixed when copied. Click the pasted cell and inspect the formula bar if the reference behavior matters.
-
Use Paste Special when you only want part of the copy. Copy the source, select the destination, then choose Home > Paste > Paste Special. In the dialog, choose Values to paste results without formulas, Formulas to paste formulas without the source formatting, or Formats to paste only formatting. Choose All for a full cell-level paste. The labels and layout can vary slightly between Excel releases.
-
Keep the formula text unchanged when that is the goal. Copying a formula cell with Ctrl+C is not enough, because Excel may shift its relative references. Select the source formula cell and click in the formula bar. Select the formula text there, copy it, click the destination cell, click its formula bar, paste the text, and press Enter. This enters the same formula text at the destination. Check that the references still point to the intended cells; identical formula text can calculate differently when its location changes.
-
Repeat the paste where needed. For another destination, select it and press Ctrl+V again while the copied border is still active. To copy to a separate workbook, open both workbooks and paste into the target workbook. If you want a pasted result to remain fixed rather than change when its source changes, use Paste Special > Values after copying; this keeps the current results, not the underlying formulas.
-
Verify the result. Compare a few source and destination cells, especially the first and last cells of a large range. Look at the formula bar, number format, and borders as appropriate. If column widths also need to match, copy the source columns and use Home > Paste > Paste Special > Column Widths. A normal cell paste does not necessarily copy column widths or row heights.
Common Mistakes
-
Expecting formulas to remain textually unchanged. Standard paste copies the formula but adjusts relative references according to the new location. Use absolute references where appropriate, or copy the formula text through the formula bar if it must be identical.
-
Choosing Values when you need the original formulas. Values paste the results currently displayed, not the calculations that produced them. If the source result is 25, the destination receives 25 rather than a formula that could update later.
-
Assuming cell formatting includes dimensions. Cell fonts, fills, and borders are separate from column widths and row heights. Use the Column Widths paste option for widths; adjust row height separately when needed.
-
Pasting into the wrong-sized or occupied area. A multi-cell copy can overwrite existing data. Confirm the destination’s top-left cell and the full area that Excel will fill before pasting.
-
Pressing Esc before the paste. Esc ends copy mode. If the moving border disappears, copy the source again and then paste.
Tips
-
Use the small Paste Options button that may appear beside the pasted range to switch quickly between available paste choices. Its options depend on what you copied.
-
If you want the same value repeated without carrying over the source formatting, copy the cell and use Paste Special > Values. For a one-off entry in several selected cells, type the value and press Ctrl+Enter; this enters the typed content into all selected cells, but it is not a full copy of formatting or other cell features.
-
To copy a formula while keeping one reference fixed, edit the source formula to use dollar signs for that reference before copying. For example, $B$2 remains fixed, while B2 is relative. A mixed reference such as $B2 fixes the column but allows the row to change.
-
For a dependable menu route on Windows, use Home > Paste > Paste Special rather than guessing a shortcut. In Excel for Mac, copy and paste with Command+C and Command+V; the Paste Special choices are available from the Home tab or the Edit menu, depending on the version. Excel for the web also supports copy and paste, but browser clipboard permissions and available Paste Special options can vary.
-
When the source is a whole column or row, consider whether you really need its full contents. Copying an entire column can bring along formatting or data far below the visible table and make a workbook harder to manage.
Troubleshooting
Nothing pastes. Click a normal destination cell and try again. If the moving dashed border is gone, recopy the source. In Excel for the web, allow the browser to access the clipboard or use the browser’s permitted paste method. If the worksheet is protected, check whether editing the destination is allowed.
The pasted formula gives a different answer. Select the destination and read its formula bar. Excel may have moved relative references, or the formula may now refer to different data. Undo with Ctrl+Z if you need to restore the previous state, then decide whether the reference should be relative, absolute, or entered as identical formula text through the formula bar.
The formatting did not match. Try copying again and using Home > Paste > Paste Special > Formats. If only the width is wrong, use Column Widths. Conditional formatting may be controlled by rules that apply to a range, so inspect Home > Conditional Formatting > Manage Rules if the displayed appearance still differs.
Excel shows an error about merged cells or the paste area. Make the destination range the same shape as the copied range and check whether its merged cells match the source. Unmerge or align the merged areas before pasting if necessary. If the destination is inside an Excel table, some paste operations may behave differently; try pasting into a blank area first to identify whether the table is the cause.
The copied result changes later. If you pasted formulas, they can recalculate when their inputs change. Undo if needed, then copy the source again and choose Paste Special > Values to keep the current displayed results. Remember that this freezes the results, so they will not update with the source data.
Frequently Asked Questions
How do I paste the exact same thing in Excel?
Select the source, press Ctrl+C, select the destination, and press Ctrl+V. This copies the cells and their formatting, but formulas with relative references can adjust. Check the formula bar if exact formula text matters.
How do I paste without changing the formatting?
Copy the source, select the destination, then choose Home > Paste > Paste Special > Values if you want only the displayed results. To paste formulas without formatting, choose Formulas. The right option depends on what should be preserved.
How can I copy a formula without changing its references?
Use absolute references with dollar signs, such as $B$2, if those references should stay fixed when pasted. To preserve the formula text exactly, copy it from the formula bar and paste it into the destination formula bar, then check the resulting calculation.
Does copy and paste include column widths?
Not usually. Copy the cells, then choose Home > Paste > Paste Special > Column Widths. Row heights generally need to be adjusted separately.
Can I paste the same cells in Excel for Mac?
Yes. Use Command+C and Command+V for ordinary copying and pasting. For selective pasting, use the Paste Special options on the Home tab or Edit menu; the exact menu presentation depends on your Mac version.
Why did Excel paste only a number instead of the formula?
You may have chosen Values in Paste Special, or copied a cell that already contained a fixed value. Copy the source again and use the normal Paste command or choose Formulas if you need the calculation.
Related
- How to Insert a Signature Field in Word for Signing
- How to Insert a Section Line in Word and Customize It
- How to Insert a Separation Line in Word: 3 Easy Ways
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Worksheet in Word: How to Insert and Format ItTo insert an Excel worksheet into Word, use Insert > Table > Excel Spreadsheet for a new, editable…
- How to Group Rows in Excel Online: A Step-by-Step GuideTo group rows in Excel Online, select their row numbers, choose Data > Group, and then use the…
- Cannot Close Excel Because a Dialog Box Is Open? FixesIf Excel says it cannot close because a dialog box is open, find and respond to that open…
- AutoCAD Excel Data Links: Insert and Update TablesTo insert Excel data in AutoCAD as a linked table, run TABLE, choose From a data link, create…
- How to Paste a Link in Excel as Plain Text, Not HyperlinkTo paste a URL into Excel as plain text, select the destination cell, press F2 to edit it,…
- Excel SUM: How to Exclude Hidden Rows and Filtered RowsYes. To sum visible rows while excluding both filtered-out rows and rows hidden manually, use SUBTOTAL with function…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.