To copy cells in Excel and keep their formatting, select the cells, press Ctrl+C, click the destination, and press Ctrl+V. A normal paste copies the contents and formatting; if you need only the appearance, use Home > Paste > Paste Special and choose Formats. These steps are for Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook with the cells, range, or worksheet you want to copy.
- A destination in the same workbook or another workbook. If copying between workbooks, keep both open while you work.
Step-by-Step
- Select the cells to copy. Click one cell, or drag across a range. To select a whole column or row, click its letter or number heading. For a non-adjacent selection, hold Ctrl while selecting additional ranges on Windows. Copying a larger selection also copies its formatting, such as number formats, font, fill color, borders, alignment, and, where applicable, conditional formatting.
- Copy the selection. Press Ctrl+C, or choose Home > Copy. A moving dashed outline appears around the copied cells. You can also right-click the selection and choose Copy. Keep the outline visible until you paste; clicking elsewhere is fine, but pressing Esc cancels the copy.
- Choose the destination. Click the upper-left cell where the copied range should begin. Check that there is enough room for the full range and that you are not selecting a destination that overlaps merged cells in an incompatible way. When copying several columns and rows, Excel pastes the same-sized block starting at this cell.
- Paste with the source formatting. Press Ctrl+V. A normal paste brings over the copied cells’ contents and formatting, including formulas where present. If Excel displays Paste Options beside the result, you can click the button and choose Keep Source Formatting. This is useful when a destination range has a different style and you want the copied cells to retain their original look.
- Use Paste Special when you need a specific result. Select the source and copy it as above. At the destination, choose Home > Clipboard > Paste > Paste Special, then choose the option you need. Choose Formats to apply appearance without replacing destination values or formulas. Choose Values if you want the displayed results but not the source formulas; note that Values does not preserve the source formatting. Available choices can vary slightly depending on what you copied and where you paste it.
- Copy only the appearance with Format Painter. Select a cell or range that has the formatting you want, then choose Home > Clipboard > Format Painter. Drag across the destination cells. This transfers formatting without copying the source cell contents. Double-click Format Painter to apply the same formatting to more than one destination; press Esc when finished. For one destination, a single click on Format Painter is enough.
- Copy an entire worksheet if you need its layout too. Right-click the sheet tab and choose Move or Copy. Select where to place the sheet, check Create a copy, and select OK. This copies the worksheet rather than only its cell range, so it is a better choice when you need the sheet’s layout, widths, and other sheet-level elements. On a Mac, Control-click the sheet tab to open its shortcut menu; the Move or Copy command is also available from the sheet menu.
- Check the result before continuing. Look at the destination for font, fill, borders, alignment, and number formats. If you pasted formulas, click a few cells and check the formula bar: relative references may adjust to the new position. If you used Format Painter, confirm that only the appearance changed and the destination values are still there.
On a Mac, use Command+C and Command+V for the usual copy and paste shortcuts. The ribbon options are similar, though their arrangement can vary by Excel build. In Excel for the web, use the Home tab’s Copy and Paste controls or Ctrl+C and Ctrl+V in a supported browser. Some browser or clipboard restrictions can affect copying between the browser and other apps, so use the ribbon controls if a keyboard shortcut does not work.
Common Mistakes
- Choosing Values when you want the appearance. Paste Values replaces formulas with their current results and does not carry over the source’s formatting. Use a normal paste for content plus formatting, or Paste Special > Formats for formatting alone.
- Expecting a regular cell copy to include column widths. Copying a range normally does not make the destination columns match the source widths. Use Paste Special > Column Widths if that option is available, or adjust the destination column widths manually. Row heights may also need separate adjustment.
- Overwriting existing destination formatting by accident. A regular paste replaces the destination cells’ formatting with the copied formatting. If the destination’s appearance should stay, use Paste Special > Values or another appropriate paste option instead.
- Assuming formulas remain identical. Excel commonly adjusts relative cell references when a formula is pasted elsewhere. This is expected behavior, not a formatting change. Check formulas if their references must remain fixed.
- Using Format Painter and expecting it to copy data. Format Painter transfers the look, not the cell contents. To copy both, use Copy and Paste instead.
- Copying into a merged or filtered range without checking. Merged cells can prevent a paste when source and destination shapes do not match. With filtered data, a normal selection may include hidden rows. Review the selection and destination before pasting a large block.
Tips
- Use the paste preview or Paste Options button. After pasting, the small options button can offer choices such as keeping source formatting, matching the destination, or pasting values. The choices shown depend on the copied content and Excel version. If you choose the wrong one, immediately press Ctrl+Z on Windows or Command+Z on Mac, then paste again with the right option.
- Use Formats for a reusable style. Paste Special > Formats is handy when the destination already contains the correct data but needs the same borders, font, fills, or number format as another range. It can also bring over conditional formatting, so inspect the result if the source has conditional-formatting rules.
- Copy a full row or column when its dimensions matter. Selecting the row or column heading and copying can be more useful than selecting only its cells. For an exact match of worksheet layout, copying the entire sheet is usually clearer than trying to reproduce several widths and heights individually.
- Keep a clean source example. If you often apply the same look, maintain a clearly formatted example range or a template worksheet. Copy from it with Paste Special > Formats or use Format Painter, rather than rebuilding the style each time.
- Be mindful of themes and conditional formatting. Theme colors may appear differently in a workbook with a different theme, and conditional-formatting rules can refer to changed cell ranges after copying. If a color or rule looks unexpected, inspect the destination’s theme and its conditional-formatting rules.
- Paste in stages for large or important ranges. Try a small sample first when copying between workbooks, especially if the range contains formulas, merged cells, or conditional formatting. Confirm the result before applying the same method to the full dataset.
Troubleshooting
The formatting disappeared. Undo the paste, if it is still the last action, and repeat it with Ctrl+V or the Paste dropdown’s Keep Source Formatting option. If you already pasted only the values, copy the original cells again and use Paste Special > Formats on the destination.
The destination looks different from the source. Check whether you chose Match Destination Formatting, whether the destination has a different workbook theme, and whether conditional formatting is changing the displayed color. Also check the number format: a date or percentage can look different even when the underlying value is unchanged. Select the destination cells and inspect the Number Format controls on the Home tab.
Excel will not paste the range. Press Esc once, recopy the source, and try again. Make sure the copied block and destination are compatible in size, and check for merged cells that do not match. If the worksheet is protected, you may not be allowed to edit the destination; ask the workbook owner or unprotect the sheet if you have permission.
The paste looks right, but formulas or rules changed. Pasting formulas can shift relative references. Undo and use Paste Special > Values if you want fixed results rather than formulas. If conditional formatting is involved, open Home > Conditional Formatting > Manage Rules and review the ranges and formulas for the destination cells.
The copied column does not fit. Cell formatting and column width are separate. Adjust the destination width by dragging the boundary between its column headings, or use Home > Format > AutoFit Column Width. To copy a specific width, use Paste Special and choose Column Widths when that option is available.
Copy and paste shortcuts do nothing in Excel for the web. Use the Copy and Paste buttons on the Home tab, and check whether the browser has blocked clipboard access. If the workbook is in view-only mode or the destination is locked, switch to editing mode or request edit access.
Frequently Asked Questions
Does Ctrl+C and Ctrl+V copy formatting in Excel?
Yes. A normal copy and paste usually transfers cell contents and formatting, including formulas, fonts, fills, borders, alignment, and number formats. Use Paste Special when you need only particular parts.
How do I copy formatting without copying the value?
Copy the formatted source, select the destination, then choose Home > Clipboard > Paste > Paste Special > Formats. You can also use Home > Clipboard > Format Painter and drag over the destination.
How do I keep the destination formatting instead?
Use Paste Special > Values when you want the source results but want to avoid bringing its formatting. If you need formulas rather than fixed results, choose the appropriate formulas paste option, then check the destination appearance; a normal paste replaces destination formatting.
Can I copy formatting to multiple separate ranges?
Yes. Double-click Format Painter, then apply the formatting to each destination range. Press Esc to turn it off. You can also copy the source and use Paste Special > Formats on each range in turn.
Why did my formulas change after copying?
Excel adjusts relative references to reflect the new location. Absolute references marked with dollar signs do not shift in the same way. If you only need the displayed answers, paste values; if you need formulas, inspect their references after pasting.
Will copying cells also copy column widths?
Usually not when you copy an ordinary cell range. Use Paste Special > Column Widths if available, adjust widths manually, or copy the whole worksheet when preserving its overall layout is important.
Related
- How to Close an Excel Sheet with a Keyboard Shortcut
- How to Close an Excel Sheet With a Keyboard Shortcut
- How to Close Editing Mode in Excel Without Losing Work
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Unable to Unhide Rows in Excel? Try These FixesIf you are unable to unhide rows in Excel, first select the row headers immediately above and below…
- Can You Compare Two Excel Sheets? Methods That WorkYes. In Excel for Microsoft 365 on Windows, you can compare two sheets cell by cell, check whether…
- Excel Hide Columns With an Expand Button: Grouping GuideTo hide columns that readers can reopen with a plus button, select the columns, choose Data > Group,…
- How to Delete a Blank Page in Word: Quick, Simple FixesTo delete a blank page in Word, show formatting marks with Ctrl+Shift+8 on Windows or Command+8 on Mac,…
- Excel Date Selector: Add a Calendar or Validate DatesExcel for Microsoft 365 on Windows does not include a built-in calendar date selector for ordinary worksheet cells.…
- Can You Put Text With a Checkbox in Google Sheets?Yes—but a Google Sheets checkbox does not display ordinary text inside its box. Put the label in a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.