To copy cells in Excel for Microsoft 365 on Windows and keep their formatting, select them, press Ctrl+C, select the destination’s upper-left cell, and press Ctrl+V. Standard paste normally brings the source formatting along with the contents. If you want to copy only the appearance, use Home > Paste > Paste Special > Formats instead. The steps below explain which option to use and how to fix common formatting surprises.
What You’ll Need
- An Excel workbook with the cells you want to copy and a destination worksheet or workbook.
- Permission to edit the destination. If the sheet is protected, you may need the password or an authorized person to allow editing.
- For a paste between workbooks, both workbooks should be open in Excel. You can also copy and paste within a workbook.
Step-by-Step
- Select the source cells. Click and drag across the cells you need, or click a cell and hold Shift while selecting another cell to select a rectangular range. To select a whole column, click its letter; to select a whole row, click its number. Copying a range this way includes its cell contents and formatting, not just the visible text.
- Copy the selection. Press Ctrl+C on Windows, or choose Home > Copy. A moving dashed border usually appears around the copied cells. Leave the selection copied while you choose the destination; clicking somewhere else does not cancel the copy.
- Choose the destination carefully. Click the upper-left cell where the copied range should begin. If you copied a multi-cell range, Excel fills a corresponding area from that starting point. Check that the destination does not contain information you need: a normal paste replaces the cells it covers. If the source and destination are on different worksheets, click the destination sheet tab and then its upper-left target cell.
- Paste the cells. Press Ctrl+V, or choose Home > Paste. In the usual case, Excel copies the values or formulas and the source cell formatting, such as number formats, font, fill color, borders, and alignment. The copied range’s size and layout are retained. Review the result before continuing, especially if the destination has a different layout or contains important data.
- Use the Paste Options button if you need a different result. After pasting, Excel may show a small Paste Options button beside the selected range. Open it to choose an available paste behavior, such as keeping the source formatting or matching the destination formatting. The choices can vary depending on what you copied and where you pasted it. If the button disappears, you can undo and paste again using the Home tab’s Paste menu.
- Choose Keep Source Formatting when Excel offers a choice. In the Home > Paste dropdown, select Keep Source Formatting if you want the copied cells to retain their original appearance rather than adopt the destination’s style. This is particularly useful when pasting into a formatted table or a worksheet that applies its own style. For an ordinary range-to-range paste, Ctrl+V generally already brings the source formatting with it.
- Paste formatting without replacing the cell contents. If the destination already contains the values or formulas you want to keep, copy the formatted source cells, select the destination, and choose Home > Paste > Paste Special > Formats. This applies the source formatting only. It does not paste the source values or formulas. Check the appearance and number formats afterward, because formats-only paste can change how existing destination values are displayed.
- Copy formatting with Format Painter when you do not need to copy cells. Select a cell or range whose appearance you want to reuse, choose Home > Format Painter, and then select or drag across the destination. Format Painter transfers formatting, not the source data. Double-click Format Painter if you want to apply the same formatting to several separate areas, then press Esc to turn it off.
- Confirm the result. Look at the destination’s borders, fills, font, alignment, and number display. If the source contains formulas, click a pasted formula cell and inspect the formula bar: relative references may change to reflect the new location. Save the workbook once you are satisfied.
On a Mac, use Command+C and Command+V for the standard copy and paste commands. The Home tab’s Paste menu and Paste Special options provide the same general choices; menu labels or their placement can differ slightly by Excel version. In Excel for the web, use the Home tab’s paste controls or the browser’s supported keyboard shortcuts. Some clipboard and Paste Special behavior may be more limited in a browser than in the Windows desktop app.
Common Mistakes
- Choosing the wrong paste option. Match Destination Formatting is intended to make the pasted cells fit the destination’s appearance. It is not the choice when you want to preserve the source look. Choose Keep Source Formatting, or use Paste Special > Formats when you want appearance only.
- Assuming formats-only paste copies the data too. Paste Special > Formats transfers cell appearance, not the source’s text, numbers, or formulas. Use ordinary paste if you need the contents as well.
- Pasting over existing cells. A normal paste replaces what is in the matching destination area. Before pasting a large range, check the destination and consider using a blank area or making a copy of the sheet.
- Expecting column widths to follow a normal paste. Cell formatting and column width are different. A normal paste does not reliably resize destination columns to match the source. If available, use Home > Paste > Paste Special > Column Widths to copy the source widths, or adjust the destination columns manually.
- Overlooking formulas and references. Pasting formulas can adjust relative cell references. That is normal Excel behavior and is separate from formatting. If you need the displayed results rather than formulas, choose Values from the Paste options; if you need the original formulas, inspect them after pasting.
- Confusing visible color with cell formatting. A cell may look colored because of conditional formatting, a table style, or a theme rather than a manually applied fill. A paste may carry or interact with those rules differently. Check the destination’s conditional formatting rules or table design if the appearance changes unexpectedly.
Tips
- Use ordinary paste for a faithful cell copy. When you want contents and appearance together, Ctrl+C followed by Ctrl+V is usually the simplest approach. The paste menu is useful when you need to control which parts are copied.
- Use Paste Special for a specific purpose. Formats is for appearance only; Values is for displayed results without formulas; Formulas is for formulas without ordinary source formatting. The menu may offer other choices, including column widths, depending on the copied range and Excel version.
- Check number formats. A value such as 0.25 can display as 25%, 0.25, or a currency amount depending on its number format. If a pasted value looks different, inspect the cell’s number format rather than assuming the underlying value changed.
- Copy a whole range when consistency matters. Selecting the full source block helps retain its borders and relative arrangement. If you copy only individual cells, you may miss edge borders or other formatting applied to the surrounding range.
- Use Format Painter for a quick visual match. It is convenient when the destination data should stay untouched. Select the source range first so Excel has the intended formatting, and select a destination range of the appropriate size.
- Know when table formatting is in control. If the destination is an Excel table, its banded rows and table style can affect what you see. If keeping the source style is essential, consider pasting into a normal cell range or review the table style after the paste.
- Undo promptly if the result is wrong. Press Ctrl+Z on Windows or Command+Z on Mac to undo a recent paste, then repeat it with the correct option. Undo is most reliable before making additional changes.
Troubleshooting
The formatting did not come across. Undo the paste, copy the source again, and use the Home tab’s Paste dropdown. Choose Keep Source Formatting if it is available. If you only need appearance and the destination’s contents must stay, choose Paste Special > Formats. In Excel for the web, try the Home tab’s paste controls; if the option is missing, open the workbook in the desktop app.
The destination looks different even though you chose to keep formatting. Check whether the cells are part of a table, have conditional formatting, or use a theme-dependent color. Also compare number formats and column widths. Try pasting into an empty area to see whether the destination’s table or rules are influencing the appearance. If column width is the issue, copy it separately with Paste Special > Column Widths where that option is available.
Excel pastes the wrong cells or only part of the range. Recheck the source selection before copying. For a multi-cell range, click one destination cell rather than selecting a differently sized target range; Excel will place the copied block from that starting cell. If the source or destination contains merged cells, unmerge or adjust the ranges first, because mismatched merged areas can prevent a paste.
The paste command is unavailable or nothing happens. Click a normal worksheet cell and try copying again. A copied range may have been canceled if you pressed Esc or performed another clipboard action. A protected sheet, a cell being edited, or browser clipboard restrictions can also interfere. Exit cell-edit mode with Enter or Esc, check whether the sheet allows editing, and use the ribbon command if a keyboard shortcut does not work.
Formulas changed after pasting. Excel normally adjusts relative references when formulas move. If the formula itself must remain unchanged, review whether its references should be absolute, or paste values if you only need the current displayed results. Before replacing formulas with values, make sure you no longer need the calculations to update.
Frequently Asked Questions
Does Ctrl+V keep formatting in Excel?
Usually, yes. Ctrl+V pastes the copied cells with their contents and source formatting. If a table, destination style, or paste choice changes the appearance, use the Paste Options button or Home > Paste to select Keep Source Formatting.
How do I copy formatting without copying the cell’s value?
Copy the source cell, select the destination, and choose Home > Paste > Paste Special > Formats. Format Painter is another option when you want to apply appearance directly to one or more destination ranges.
How do I paste values and keep the destination formatting?
Copy the source cells, select the destination, and choose Values from the Paste options. This brings over the results without the source formatting, so the destination’s existing cell appearance is generally retained. Check the result if the destination is a table or uses conditional formatting.
Can I copy formatting between different workbooks?
Yes. Open both workbooks, copy the source cells, switch to the other workbook, select the destination, and paste. If you need only the appearance, use Paste Special > Formats. Be aware that copying formulas between workbooks can create references to the source workbook.
Why did my column widths stay the same?
Column widths are not the same as cell formatting, and a standard paste may leave the destination widths unchanged. Use Home > Paste > Paste Special > Column Widths if available, or change the destination column width manually.
Can I keep formatting when pasting in Excel for the web?
Often, yes: copy the range and use the Home tab’s paste controls. The available options depend on the browser and web version. For a specific Paste Special choice that is missing, open the workbook in Excel for Microsoft 365 on Windows or Mac.
Related
- How to Color Cells in Excel Based on Values Automatically
- How to Color Negative Values in Excel Automatically
- How to Color Code Names in Excel with Conditional Formatting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Share a Personal Calendar in Outlook on Any DeviceTo share a personal calendar in Outlook, open Calendar, choose the calendar’s sharing option, add the recipient, select…
- How to Hide Columns in Excel on Mac Without Losing DataTo hide columns in Excel on a Mac, select the column letter or letters, then choose Home >…
- Close Version History in Excel Without Losing DataTo close Version History in Excel for Microsoft 365 on Windows, open the Version History pane and select…
- How to Average Data in Excel Across Different SheetsTo average the same cell across several worksheets, enter a formula such as =AVERAGE(Jan:Mar!B2) when the sheets are…
- Freeze Panes in Excel: Keep Rows and Columns VisibleTo freeze panes in Excel for Microsoft 365 on Windows, select the cell below the rows and to…
- How to Embed a Video With Sound in PowerPoint SlidesTo embed a video with sound in PowerPoint, choose Insert > Video > This Device on Windows, select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.