Excel Shortcut to Paste Formatting and Keep Data

In Excel for Microsoft 365 on Windows, copy the formatted cell, select the destination, then press Ctrl+Alt+V, press T to choose Formats, and press Enter. This pastes the cell’s formatting without replacing the destination’s value or formula.

The Windows shortcut, step by step

Excel’s Paste Special command lets you choose which parts of copied cells to transfer. For formatting alone, use the Formats option rather than the standard Paste command. The full keyboard sequence is:

Select the cell or range whose appearance you want to copy, then press Ctrl+C.
Select the destination cell or the upper-left cell of the destination range.
Press Ctrl+Alt+V to open the Paste Special dialog.
Press T to select Formats, then press Enter.

The letter key works in the standard English-language dialog; if your Excel uses another display language or the key does not select the option, use the dialog itself and click Formats. You can also reach the command through Home > Paste > Paste Special, then choose Formats. The precise keyboard route is useful when working quickly, while the dialog makes the chosen paste type visible before you apply it.

What pasting formats changes

Formats transfers appearance-related settings from the copied cells. That commonly includes the font, font size and color, fill color, borders, alignment, and number format. For example, a cell displaying 0.25 as 25% can give its percentage number format to another cell without changing the number stored there. A date-style format can likewise change how an existing serial number appears, while leaving its underlying value intact.

The command does not paste the source cell’s ordinary value or formula. If B2 contains the formula =SUM(B3:B8), and you paste its formats onto C2, C2 keeps its own content; only the appearance is transferred. That is the key distinction between Formats and ordinary Paste. Formats is not a way to copy a formula while preserving the destination’s styling. For that job, choose a different Paste Special option or copy the formula separately.

Formatting can include more than colors. A number format may change a display from 0.4 to 40%, or from a numeric date value to a date. The stored value remains the same, but the changed display can make a sheet seem as if its data changed. If you are checking a result, look at the formula bar or use the General number format to distinguish the stored value from its presentation.

Apply one format to a cell or range

You can paste formats to one destination cell or a selected range. To format multiple cells, copy a source cell, select the destination range, and run the Formats paste command. Excel applies the copied cell formatting across the selected area. This is useful for making a block of totals consistent, but the source is still just one cell: the operation does not infer different formatting for each destination based on its content.

For example, suppose D10 is a total styled with bold text, a top border, and a currency number format. Copy D10, select D11:D15, and paste Formats. The destination cells keep their existing values or formulas but receive those formatting choices. Be careful when the source has a special number format: applying a currency format to cells containing counts will make the counts look like money even though their values remain unchanged.

When copying a multi-cell range, select a destination range of a suitable matching size if you want the source pattern to line up predictably. For a single-format application, copying just one representative cell is usually clearer. If the destination selection includes cells with different existing styles, remember that the paste replaces their formatting with the copied formatting; it does not merge the two styles.

When Format Painter is a better choice

Paste Special is not the only way to copy appearance. Format Painter on the Home tab is often faster for a one-off job, especially when the source and destination are easy to point to with the mouse. Select the source cell, choose Home > Format Painter, then click or drag across the destination. It copies formatting, not the source’s values or formulas.

Format Painter is also handy for applying a format to more than one separate area. Double-click Format Painter to keep it active while you click or drag over several destinations; press Esc when you are finished. The keyboard Paste Special method can be more comfortable for keyboard-focused work or for a precise selection that is easier to select by reference or with the keyboard. Both methods copy styling rather than cell contents, but neither automatically preserves every difference in the destination’s existing appearance.

Choose based on the task: use Format Painter for a quick visual operation, and use Paste Special when you want to explicitly select Formats from a list of paste types. If you need only one part of a style, such as a border but not the number format, neither method offers a simple one-click “border only” result through the Formats option. You may need to adjust the specific setting afterward using the Home tab controls.

Formatting versus values, formulas, and column widths

Paste Special includes several options because copying cells can involve content as well as presentation. Formats is the choice for appearance. Values pastes results without formulas; Formulas pastes formulas; and ordinary Paste transfers a broader set of cell information. Column widths is a separate option because a column’s width is a worksheet layout property, not just the formatting of one cell.

This distinction matters when you want a matching table. Pasting Formats onto cells will not automatically make the destination columns the same width as the source columns. If you also need the widths to match, use the Paste Special dialog’s Column widths option as a separate operation, or adjust the destination width directly. Similarly, if the goal is to reproduce both formulas and appearance, ordinary Paste may be appropriate, but it can replace existing destination content.

A useful rule is to decide what must remain unchanged before copying: values, formulas, number formats, borders, or column layout. Then choose the paste type that changes only what you intend. For instance, to keep a destination formula but make its result look like a currency amount, paste Formats from a correctly formatted currency cell. To keep a value but transfer a formula, choose Values instead; that would not preserve the formula.

Excel for Mac and Excel for the web

On Excel for Mac, the most dependable route is to copy the source, select the destination, and choose Edit > Paste Special > Formats or use the Paste Special controls on the ribbon. Keyboard shortcuts can differ by Mac keyboard, Excel release, and system settings; the Windows sequence Ctrl+Alt+V, T, Enter should not be assumed to work on a Mac. If your Mac version displays a Paste Special shortcut, use the one shown by that version, or use the menu to avoid ambiguity.

Excel for the web runs in a browser, where keyboard handling can depend on the browser and operating system. Copy the source, select the destination, then look for the available paste choices on the Home tab or in the context menu. If a Formats-only choice is not available in the current browser experience, open the workbook in the desktop Excel app and use Paste Special there. The browser’s ordinary paste command should not be assumed to offer the same dialog and options as desktop Excel.

Common problems and how to fix them

The shortcut opens another command or does nothing: Confirm that you copied cells first and that Excel has focus. On Windows, Ctrl+Alt+V opens Paste Special; in another language, use the dialog and select Formats instead of relying on the T key.
The value or formula changed: You may have used ordinary Paste rather than Formats. Undo immediately with Ctrl+Z if appropriate, then repeat the operation using the Formats option.
The destination looks different than expected: Check whether the source carries a number format, alignment, fill, or border that is unsuitable for the destination. Paste Formats transfers the source style; it does not tailor it to the destination data.
Column widths did not change: That is expected when using Formats. Transfer column widths separately or resize the columns.
Only some cells appear formatted: Check the selected destination range and whether the copied source was a single cell or a multi-cell block. Also consider whether conditional formatting rules affect what you see.

Conditional formatting deserves particular attention. A cell’s displayed color may be produced by a conditional formatting rule rather than by a manually applied fill. If the appearance does not follow the way you expect, inspect Home > Conditional Formatting > Manage Rules and check which cells the rules apply to. A visible color change is not always evidence that a static fill was copied; rule ranges and cell values can determine the final display.

How to check the result safely

Before applying formatting across an important report, try the operation on a small destination range. Confirm that a representative value or formula is still present, and inspect the number format if the displayed result has changed. If a format paste produces an unwanted result, use Ctrl+Z on Windows or Command+Z on Mac promptly to undo it, then choose a more suitable source cell or adjust the destination formatting manually.

For larger workbooks, identify a source cell that already has the exact intended style. Using a cell from the same type of data column reduces surprises, such as applying a date format to a quantity or a red warning fill to an ordinary row. A carefully chosen source is particularly important when copying styles into a report with mixed units, totals, dates, and percentages.

Frequently Asked Questions

What is the Excel shortcut to paste formatting only?
In Excel for Microsoft 365 on Windows, copy the source, select the destination, press Ctrl+Alt+V, press T for Formats, and press Enter. If T does not select the option in your language or version, choose Formats in the Paste Special dialog.

Does Ctrl+Shift+V paste formatting in Excel?
Do not rely on Ctrl+Shift+V as the standard Windows shortcut for formatting-only paste in desktop Excel. Use Ctrl+Alt+V and choose Formats, or use Home > Paste > Paste Special. Shortcuts can differ across apps and versions.

Will paste formatting replace my formula?
No. The Formats option is intended to transfer cell formatting without replacing the destination’s value or formula. If content changes, check whether ordinary Paste was used instead.

Can I paste formatting without changing the number?
Yes. Formats keeps the destination value, but it may change how that value is displayed if the source has a different number format. For example, the stored value 0.5 can display as 50% after receiving a percentage format.

How do I paste formatting on a Mac?
Use Excel’s Paste Special menu and select Formats. Mac keyboard shortcuts differ from Windows and may vary with the version and keyboard configuration, so the menu route is the reliable alternative when a shortcut is unclear.

Can I copy only a border or fill color?
The Formats paste option transfers formatting as a group rather than offering a dedicated border-only or fill-only paste choice. Use the Home tab’s border, fill, font, or number-format controls afterward to change just the specific property you need.

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.