To paste into existing Excel cells without changing their formatting, copy the source, select the destination, then choose Home > Paste > Paste Special > Values for fixed results or Formulas for formulas. These options transfer cell contents without bringing across the source formatting, so the destination’s fonts, fills, borders, and number formats stay in place.
Use Values when you want the displayed result rather than a live formula; use Formulas when the pasted cells should keep calculating. If you need to preserve other cell features, such as validation rules or comments, choose the corresponding Paste Special option instead of a general paste.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- A copied source range and a destination range. To paste a block, make sure the destination has enough room for the copied rows and columns.
- Access to the destination cells. If the sheet is protected, you may need permission to edit or to unprotect it before pasting.
You do not need to change Excel’s default settings or install anything. The instructions below use the ribbon and work for ordinary cells as well as many worksheet ranges. Excel for Mac has equivalent Paste Special options, with a slightly different shortcut; the web version also offers paste options, though the desktop dialog has more choices.
Step-by-Step
-
Choose what you want to keep. Decide whether the destination needs fixed values or formulas. Values are best for a final report, imported list, or result you do not want to recalculate. Formulas are appropriate when the destination should remain linked to cell references and recalculate when inputs change. Both options leave the destination’s existing formatting alone.
-
Copy the source cells. Select the cell or range you want to transfer, then press Ctrl+C on Windows. You can also right-click the selection and choose Copy. A moving dashed outline usually indicates that Excel has copied the range. Copy rather than cutting: cutting moves cells and can affect the original location and references.
-
Select the destination. Click the upper-left cell where the pasted content should begin. If you are pasting a rectangular block, Excel fills the cells to the right and below it, so check that the destination area is clear and has the intended shape. You usually select only the first destination cell; selecting a differently sized range can make the result confusing or trigger an error.
-
Open Paste Special. On the ribbon, select Home > Paste arrow > Paste Special. In the Paste section, choose Values to insert the copied cells’ calculated results, or Formulas to insert their formulas. Do not choose All or Formats if the goal is to retain the destination’s current appearance. The command may appear in a menu reached by right-clicking the selected destination as well.
-
Confirm the paste. Click OK if a Paste Special dialog is open. The destination should now contain the copied values or formulas but retain its existing font, fill, borders, alignment, and number format. Click a pasted cell and inspect the formula bar if you need to confirm whether it contains a value or a formula.
-
Use the keyboard route when you prefer. On Windows, after copying and selecting the destination, press Ctrl+Alt+V to open the Paste Special dialog. Select Values or Formulas with the keyboard or mouse, then confirm. This opens the dialog rather than performing a normal paste, which is important when you want to control what comes across. Ctrl+V alone may paste the source formatting too.
-
Check the displayed results. Compare a few pasted cells with the original destination cells. A number may look different even though its value is correct: for example, a destination formatted as a date can display a pasted serial number as a date, and a percentage-formatted cell can display a decimal as a percentage. That is the destination format doing its job, not necessarily a failed paste.
-
Repeat for other ranges if needed. Keep the copied range active and select another destination cell to paste the same values or formulas again. If you need a different Paste Special choice for the next range, open the dialog and select it again rather than assuming Excel will use the option you expect. Press Esc when you are finished to clear the moving copy outline.
In Excel for Mac, copy the source and select the destination, then use Home > Paste > Paste Special and select Values or Formulas. The available keyboard shortcut differs by keyboard and Excel version; use the menu command if you are unsure. In Excel for the web, use the Paste options on the Home tab or the context menu and choose the option that pastes values. If the option you need is unavailable in the browser, open the workbook in the desktop app.
Common Mistakes
-
Using Ctrl+V for a normal paste. A standard paste can bring the source format along with its contents. If you notice changed colors, fonts, borders, or number formats, undo immediately with Ctrl+Z and repeat using Paste Special > Values or Formulas.
-
Choosing Values and Number Formats. This option is useful when you want the source’s number display, but it also applies number formatting. For example, it can change a destination from General to Currency or Date. Choose plain Values if the destination number format must remain unchanged.
-
Choosing Formats instead of Values. Formats copies appearance without transferring the cell contents. It is useful for copying a style, but it will not achieve a content-only paste. Likewise, All can copy both content and formatting, which defeats the purpose here.
-
Expecting a formula paste to reproduce the same displayed result. Relative references can adjust to the new location, and the destination’s number format may display the result differently. Check the formula bar and the references, not just the visible value.
-
Pasting over a whole table without checking its behavior. Excel tables can apply their own column styles, calculated-column formulas, or data rules. If a table seems to change the pasted cells, inspect its table style, formula behavior, and conditional formatting before concluding that Paste Special copied the source style.
Tips
-
Use the simplest option that matches the task. Values is the most reliable choice when you only need the results. Formulas is right when calculations must remain active. Paste Special also offers options such as Column widths, Validation, and Comments and Notes when you specifically need those features.
-
Remember that Values removes formulas. If you paste a formula cell as a value, the destination receives the result calculated at the time of copying, not a continuing calculation. This is helpful for snapshots, but it will not update when the original inputs change.
-
Keep the destination formatting ready first. Apply the desired number format, borders, and fill to the target cells before pasting. Then use Values or Formulas. This makes the result predictable and avoids having to repair formatting afterward.
-
For a quick one-time paste, use the paste-options button. After a normal paste, Excel may show a Paste Options button near the pasted range. Select it and choose the values-only option if available. Because the default paste may already have altered the appearance, check the result and undo first if preserving the original formatting is essential.
-
Consider conditional formatting separately. A cell’s visible color may come from a conditional-formatting rule rather than its ordinary fill. Pasting a value can trigger that rule, making the color change even though the underlying cell formatting was not copied. Review Home > Conditional Formatting > Manage Rules to inspect applicable rules.
-
Check the clipboard range before a large paste. A quick test with a few cells can reveal whether values, formulas, and number displays behave as expected. For important workbooks, save before a large operation so you can return to a known version if the result is not right.
Troubleshooting
The formatting still changed. Undo with Ctrl+Z, then repeat using Paste Special > Values or Formulas. Make sure you did not choose All, Formats, or Values and Number Formats. If the color changes again after a values-only paste, check conditional formatting, table styles, or formatting rules that respond to the new contents.
The pasted numbers look wrong. Look at the destination’s number format and the formula bar. A date, percentage, or currency format can make a correct underlying number look unexpected. If you want the destination display to remain as it is, do not use Values and Number Formats. If the value itself differs, confirm that you copied the intended source cells and selected the correct destination.
The formulas show different results. Select a pasted cell and inspect its formula. Excel normally adjusts relative references when a formula is copied to a new position. If you intended to paste the calculated result instead, undo and paste Values. If you intended the original references to remain fixed, the source formula may need absolute references before copying.
Paste Special is unavailable or the paste is blocked. Confirm that you copied a range and selected a worksheet cell, rather than a chart or another object. Check whether the worksheet is protected, whether the copied and target ranges have compatible shapes, and whether Excel is in cell-edit mode. Press Esc to exit editing, copy again, and retry. If a dialog says the ranges differ, select only the top-left destination cell and let Excel fill the matching-sized area.
Only part of the range appears. Check for hidden rows or columns, merged cells, filters, or a destination range that overlaps existing data. A multi-cell paste may not fit cleanly around merged cells. Try a small unmerged test area, verify the copied selection, and paste again once the target layout is clear.
Frequently Asked Questions
How do I paste values without formatting in Excel?
Copy the cells, select the destination, and choose Home > Paste > Paste Special > Values. This inserts the calculated results without copying the source cell formatting.
Can I paste formulas and keep the destination format?
Yes. Choose Paste Special > Formulas. The formulas transfer while the destination’s existing formatting remains. Check relative references afterward because they may adjust to the new location.
What is the difference between Values and Values and Number Formats?
Values transfers the cell results only. Values and Number Formats transfers the results and the source’s number display, such as a date or currency format. Choose plain Values when you want the destination’s number format preserved.
Does Ctrl+Shift+V paste without formatting in Excel?
Do not rely on that shortcut in desktop Excel for Windows; it is not the dependable general shortcut for this task. Use Ctrl+Alt+V to open Paste Special, then choose Values or Formulas. Shortcuts can differ in Excel for Mac and the web.
Will pasting values keep formulas in the destination?
No. Values replaces formulas in the selected destination cells with their current results. Choose Formulas if you need editable calculations, or paste into a separate area if you need to keep the existing destination formulas.
Can I keep the formatting but copy only the source’s formulas?
Yes. Select Paste Special > Formulas. If you also need the source number formats, that is a separate choice and will change the destination’s number display; use it only when that change is intended.
Related
- How to Merge Excel Files Using Power Query in Excel
- Merge Cells in Excel Using Keyboard Shortcuts on Windows
- Make a Schedule in Excel Using Templates: Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Background Formatting in Word 2007: What to DoIn Word 2007, remove a page background with Page Layout > Page Color > No Color, or remove…
- How to Put Slide Numbers in PowerPoint on Every SlideTo put slide numbers in PowerPoint, open Insert > Slide Number, check Slide number, then select Apply to…
- How to Extend a Dropdown in Google Sheets: Full GuideTo extend a dropdown in Google Sheets, edit its data validation rule: add choices to the rule or…
- Excel Data Validation List: How to Exclude Blanks in ExcelTo exclude blank entries from an Excel data validation dropdown in Microsoft 365, create a helper list with…
- Excel: Calculate the Length of Time Between Two DatesTo find the elapsed number of days between two dates in Excel, subtract the earlier date from the…
- Excel Table Color Combinations: Choose and CustomizeExcel table color combinations come from built-in table styles or a custom style you create: select a table,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.