How to Paste in Excel and Keep Formatting

How-to basics · Updated November 20, 2026

To paste cells in Excel while keeping their original appearance, copy the cells, select the destination, open Home > Paste, and choose Keep Source Formatting. If you want to keep the destination’s contents but apply the copied cells’ appearance, use Paste Special > Formats instead. These options help preserve details such as fonts, fills, borders, alignment, and number formats.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows, with the source cells available to copy.
  • A destination cell or range large enough for the content, unless you are pasting formats only.
  • For content copied from another program, access to that program or its clipboard data. The available formatting options can depend on the source.

Before you begin, decide whether you want to copy both the cell contents and their appearance, or only the appearance. A regular paste with Keep Source Formatting copies the cells’ contents and formatting. Paste Special with Formats changes the destination’s formatting without replacing its values or formulas. That distinction can prevent accidentally overwriting useful data.

Step-by-Step

  1. Select and copy the source cells. Click the first cell and drag across the range you need, or click the first cell, hold Shift, and click the last cell. To select an entire row or column, click its row number or column letter. Press Ctrl+C on Windows. A moving dashed outline usually appears around the copied selection. If the cells are in a different workbook, copy them there first; you can switch workbooks with the View tab’s Switch Windows command or by selecting the other open workbook.
  2. Select the destination. Click the upper-left cell where the copied range should begin. If the copied range is several columns wide or several rows tall, make sure there is enough room for it to fit. Excel generally expands the pasted range from that starting cell, so you do not need to select an exactly matching destination range. Avoid selecting a destination that overlaps important data unless you intend to replace it.
  3. Open the paste choices. On the Home tab, click the arrow under Paste in the Clipboard group. The menu shows paste options with icons and, in many cases, text labels when you point to an option. For a normal paste that keeps the source appearance, choose Keep Source Formatting. Depending on the source and Excel build, the option may be represented by a clipboard icon with a paintbrush or may appear in the Paste Options menu after you paste. If you do not see the exact label, use Paste Special as described in the next step.
  4. Use Paste Special if you need a specific result. Choose Home > Paste > Paste Special to open the Paste Special dialog. Choose All to paste the contents and most cell properties, or choose Formats to paste the source’s cell formatting without changing the destination’s values or formulas. Click OK. On Windows, Ctrl+Alt+V opens the Paste Special dialog after copying. In Excel for Mac, use Edit > Paste Special or the Paste Special command on the ribbon; available shortcuts can differ by keyboard and Excel version.
  5. Check the result before continuing. Look at a few representative cells, including headings, dates, currency, percentages, and cells with borders. Confirm that the contents are correct as well as the appearance. For instance, a cell displayed as a date might contain a date serial value, and copying all content can replace the destination’s formula even if the displayed result looks similar. If you only needed the look, undo immediately with Ctrl+Z and repeat using Paste Special > Formats.
  6. Use the paste options button when it appears. After a regular paste, Excel may show a small Paste Options button near the lower-right edge of the pasted range. Click it to choose a different result, such as Keep Source Formatting, Match Destination Formatting, Values, or Formatting, where available. This is useful when you have already pasted but notice that Excel used a different style than you wanted. The button can disappear when you start another action; if so, undo and paste again using the ribbon menu.

For content copied from another application, first try a regular paste and inspect the Paste Options button. Text copied from a webpage or document may offer different choices from cells copied inside Excel. If the source application supplies rich text, Keep Source Formatting can retain much of its appearance, but it may not reproduce every object or feature exactly. Pasted tables, images, and text are not always treated as Excel cell ranges, so the best option depends on what you copied.

Common Mistakes

Choosing Match Destination Formatting by accident. This option applies the destination’s style to pasted cells rather than retaining the source’s appearance. It is useful when you want the new cells to blend into the existing sheet, but it is the wrong choice when matching the original font, fill, or borders matters. Check the option’s label before clicking, especially when choosing from icons.

Using a normal paste when you only wanted formatting. A standard paste can replace destination values, formulas, and other cell content. If the destination contains calculations or carefully entered data, choose Paste Special > Formats. When copying only the display style, do not choose All or use Ctrl+V without checking what it will replace.

Expecting formatting to change the underlying value. A number format changes how a value appears, not the value itself. For example, applying a currency format to 12.5 displays it as money but does not convert or calculate anything. Similarly, a date format cannot turn arbitrary text into a real Excel date. If a value is stored as text, formatting alone may not make it behave as a number or date.

Overlooking merged cells or different range shapes. A destination with merged cells, a protected sheet, or a differently sized merged layout may block a paste or make the result look unexpected. Unmerge or adjust the destination only if that is appropriate for the worksheet. Also check that the copied and destination ranges have compatible shapes when pasting a selection into an existing layout.

Assuming every visual feature is ordinary cell formatting. Conditional formatting, data validation, column widths, comments, and objects have their own paste behavior. A cell’s fill color may be produced by a conditional-formatting rule rather than a manually applied fill. Copying formats may not give the result you expect if a rule’s range or conditions differ at the destination.

Tips

  • Choose the paste type based on your goal. Use Keep Source Formatting when you want the source’s contents and appearance. Use Formats when you want the destination’s contents to remain in place. Use Match Destination Formatting when the pasted content should adopt the destination’s style.
  • Try Format Painter for a quick style-only transfer. Select a cell or range with the desired appearance, then choose Home > Format Painter and select the destination. Double-click Format Painter to apply the same formatting to multiple separate areas; press Esc when finished. Format Painter does not copy the source values or formulas.
  • Be deliberate about number formats. Paste Special > Formats can copy number formats, so a destination value may change from a plain number to a date, percentage, or currency display. If you want the font and fill but need to preserve the destination’s number format, check the result and reapply the appropriate number format afterward from Home > Number.
  • Use column-width paste when widths matter. Cell formatting does not always make the destination columns the same width as the source. If you need matching widths, use Home > Paste > Keep Source Column Widths where available, or copy the source column and use Paste Special > Column widths. This changes column widths, so consider how it will affect other content on the worksheet.
  • Copy a clean example cell. If you need a consistent look across a report, use one correctly formatted cell as the source instead of a range containing mixed styles. Applying a clean example reduces the chance of carrying along an unwanted border, font, or number format.
  • Remember the Mac and web differences. Excel for Mac has similar paste choices, but ribbon placement and keyboard shortcuts can vary. Use the Paste menu or Edit > Paste Special if a Windows shortcut does not work. Excel for the web also offers paste options, but some advanced Paste Special choices may be limited; for a complex formatting transfer, open the workbook in the desktop app.

Troubleshooting

The pasted cells lost their original look. Undo with Ctrl+Z on Windows, select the destination again, then choose Home > Paste > Keep Source Formatting. If the source was copied from a program other than Excel, try the paste options button or Paste Special and see which choices are available. You may need to recreate a feature that the source program does not transfer as Excel cell formatting.

The destination’s values or formulas were replaced. Undo immediately if possible. Copy the source again and use Home > Paste > Paste Special > Formats. This applies the appearance while leaving the destination’s contents in place. If the change has already been followed by other edits, Ctrl+Z may undo those edits too; check the workbook carefully before saving, and use a saved copy or version history if needed.

The colors or fonts look different even after using Keep Source Formatting. The workbook may use a different theme, or the source may rely on theme colors and fonts. Check the Page Layout tab’s Themes controls, and consider whether changing the workbook theme would affect other sheets. For a one-off correction, manually apply the desired font or fill from the Home tab rather than changing the entire workbook’s theme.

A fill color does not appear, or it changes later. Check whether conditional formatting controls the cell’s appearance. Select the cell and choose Home > Conditional Formatting > Manage Rules to review relevant rules. A rule may apply only to the source range, use a formula tied to different cells, or override a manually applied fill. Edit or create a suitable rule for the destination instead of repeatedly pasting a fill color that the rule will replace.

Excel refuses to paste or shows an error. Check that the sheet is not protected against editing, that the destination is not part of an incompatible merged-cell layout, and that the copied range is still on the clipboard. If the marching outline has disappeared, copy the source again. For a large range, try a smaller section to identify whether a particular cell or merged area is causing the problem.

The displayed numbers look wrong after formatting. Inspect the underlying value in the formula bar and choose a suitable format from Home > Number. A percentage format, for example, displays 0.25 as 25%, while changing the format does not alter the underlying 0.25. If Excel shows ####, widen the column or choose a shorter number format; the hashes usually indicate that the column is too narrow to display the formatted value.

Frequently Asked Questions

How do I paste in Excel without changing the destination’s values?
Copy the source cells, select the destination, and choose Home > Paste > Paste Special > Formats. This transfers formatting while keeping the destination’s existing values and formulas.

What is the difference between Keep Source Formatting and Match Destination Formatting?
Keep Source Formatting retains the source cells’ appearance. Match Destination Formatting applies the destination’s style to the pasted cells, which helps new content blend with the area around it.

Can I paste formatting without copying formulas?
Yes. Choose Paste Special > Formats. Do not choose All or use an ordinary paste if you need the destination formulas to stay unchanged.

Will Excel copy column widths when I paste formatting?
Not necessarily. Use Keep Source Column Widths or the Column widths option in Paste Special when you specifically need the source widths. Check nearby content because changing a column width affects every cell in that column.

Can I keep formatting when pasting from a website or Word?
Often, but the result depends on how the copied content is placed on the clipboard. Paste first, then inspect the available Paste Options. If Excel cannot preserve the original appearance, use Paste Special choices that are available or format the cells directly in Excel.

Why does my pasted format change after I paste?
A conditional-formatting rule, workbook theme, or existing style may control the final appearance. Review the relevant conditional-formatting rules and the workbook’s theme, then adjust the rule or apply a suitable Excel format at the destination.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.