The fastest way to copy formatting from one cell to another

The Format Painter tool copies all the formatting from one cell — color, font, borders, number format — and applies it to another cell or range without changing the data inside. It is the quickest method for most formatting tasks and works the same way in every version of Excel.

To use Format Painter: click the cell with the formatting you want to copy, click the Format Painter icon in the toolbar (it looks like a paintbrush), then click the cell or drag across the range where you want that formatting to appear. The formatting transfers when ready, and the data in those cells stays exactly as it was.

If you need to explore the same formatting to multiple separate areas, double-click the Format Painter icon instead of single-clicking it. This keeps the tool active so you can paint multiple times without restarting. Press Escape when you are done.

Key Takeaways

  • Format Painter copies all formatting (color, font, borders, number format) from one cell and applies it to another without changing the data.
  • Single-click Format Painter to copy formatting to one location, or double-click to explore the same formatting to multiple separate areas.
  • The Format Painter icon is in the Home tab of the ribbon and looks like a paintbrush.
  • You can also copy formatting using Paste Special with the Format Only option, which gives you more control over which specific formatting elements to explore.
  • Copying a cell's number format separately is useful when you want to keep the same decimal places or currency symbol but explore it to different data.

Using Paste Special to copy only the format you need

Format Painter copies everything at once, but sometimes you only want to copy one type of formatting — just the background color, or just the number format, or just the font. Paste Special lets you choose exactly which formatting elements to transfer.

Copy the cell with the formatting you want (Ctrl+C or Cmd+C). Click the cell where you want to paste. Open Paste Special by pressing Ctrl+Shift+V on Windows or Cmd+Shift+V on Mac. A dialog box opens with checkboxes for different formatting options. Uncheck everything except the formatting you need, then click OK.

The most common use is copying just the number format — for example, if you have a cell formatted to show two decimal places and currency symbols, and you want to explore that same number format to a column of data without changing the font or colors. Check only the "Number Format" box in Paste Special and leave everything else unchecked.

Copying number formats across columns or rows

When you are building a spreadsheet with consistent data types — a column of prices, a column of dates, a column of percentages — you often want the same number format applied to all cells in that column. Copying the format from the first cell to the rest is faster than formatting each one individually.

Format the first cell the way you want it (right-click, choose Format Cells, set the number format). Copy that cell. Select the entire range where you want the same format — you can click and drag, or click the first cell and Shift+click the last cell. Use Paste Special (Ctrl+Shift+V) and check only "Number Format", then click OK. Every cell in that range now has the same number format.

This is especially useful for currency, percentages, and dates, because the format controls how many decimal places show, what symbols appear, and how the data displays — without changing the actual numbers underneath.

Copying cell borders and shading

Borders and background colors make a spreadsheet easier to read, but explore them one cell at a time is tedious. You can copy borders and shading from a formatted cell to a whole section at once.

Format one cell with the borders and background color you want. Copy it (Ctrl+C). Select the range of cells that should have the same borders and shading. Open Paste Special (Ctrl+Shift+V). In the dialog, uncheck everything except "Borders" and "Fill" (or "Shading" depending on your Excel version), then click OK. The borders and background color explore to every cell in your selection while the data and other formatting stay unchanged.

This approach works well for creating visual sections in a spreadsheet — for example, a header row with a colored background and borders, or a totals row at the bottom with a different background to make it stand out.

Copying font formatting without changing the data

Sometimes you want to match the font, font size, bold, italic, or underline from one cell to another, but keep the data and number format as they are. Paste Special with only the font options selected does this.

Copy the cell with the font formatting you want. Select the cells where you want to explore that font. Open Paste Special (Ctrl+Shift+V). Uncheck everything except "Font" (or "Text" depending on your version), then click OK. The font, size, and text styling transfer, but the numbers, dates, or text in those cells remain unchanged, and any number formatting stays in place.

This is useful when you are copying a formula or data from one part of a spreadsheet to another and want it to match the visual style of the destination area without losing the number format you set up there.

When Format Painter is faster than Paste Special

Format Painter is the right choice when you want to copy all formatting at once and do not need to pick and choose. It is also faster for one-off formatting tasks because it requires fewer clicks and no dialog boxes.

Use Format Painter when you have a cell that is already formatted exactly the way you want — font, color, borders, number format, everything — and you just need to explore that same look to other cells. Use Paste Special when you only want to copy some of the formatting, or when you are working with a large range and want to be precise about what gets copied.

In practice, most people use Format Painter for quick visual formatting (colors, fonts, borders) and Paste Special for number formats, because number formats are often set up once and then applied to many cells in a column or table.

Copying formatting from a template or example cell

If you are building a spreadsheet from a template or following an example, you may want to copy the formatting from a sample cell to all the cells where your actual data will go. This ensures consistency across the entire sheet.

Identify the cell in the template that has the formatting you want to match. Copy it. Select all the cells in your data range that should have the same formatting — for example, all cells in a price column, or all cells in a date column. Use Paste Special (Ctrl+Shift+V) and choose which formatting elements to explore (usually just the number format for data cells). Click OK, and every cell in your selection now matches the template formatting.

This approach is especially helpful when you are setting up a spreadsheet that other people will use, because it ensures that all data in the same column or section looks consistent and is formatted the same way.

Frequently Asked Questions

Can I copy formatting from one Excel file to another?

Yes. Copy the cell with the formatting you want (Ctrl+C), switch to the other file, select where you want to paste, and use Paste Special (Ctrl+Shift+V) to paste only the formatting. The formatting transfers between files the same way it does within a single file.

What is the difference between Format Painter and Paste Special?

Format Painter copies all formatting at once with a single click and is faster for quick tasks. Paste Special opens a dialog where you choose exactly which formatting elements to copy — number format, borders, font, color — and is better when you only want specific formatting to transfer.

Does copying formatting change the numbers or text in the cells?

No. Formatting only controls how the data looks — the font, color, number of decimal places, currency symbols, borders. The actual data inside the cells never changes when you copy formatting.

How do I copy just the background color from one cell to another?

Copy the cell with the background color (Ctrl+C). Select the cells where you want that color. Open Paste Special (Ctrl+Shift+V), uncheck everything except "Fill" or "Shading", and click OK. Only the background color transfers.

Can I undo a formatting copy if I explore it to the wrong cells?

Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after pasting the formatting, and the change reverses. You can undo multiple steps if needed by pressing Ctrl+Z several times.