Formatting Issues

How to Copy Formatting or Values Between Excel Cells

Huma Ashraf Ch Oct 20, 2026 868 views

Question details

The user needs to replicate the visual formatting of one cell to another, or link their data so that the target cell dynamically updates when the source cell's value changes.

How to Copy Formatting or Values Between Excel Cells

Product: Excel
Device & OS: not provided
Scenario: Replicating cell styles or synchronizing data values across different cells in a spreadsheet.
Observed behavior: Achieving identical visual formatting between cells (such as making cell A1 look exactly like A3) or maintaining synchronized values where the target cell automatically mirrors the source cell.

Before you start

Identify whether you need to copy just the visual style (like colors, borders, and fonts) or the actual data value, as the tools required for these two tasks are completely different.

Solution 1Recommended

Use Format Painter to Copy Cell Appearance

The Format Painter tool quickly copies visual styles, such as fonts, background colors, and borders, from one cell to another without altering the target cell's data.

This method is ideal when you want to standardize the look of your spreadsheet. It applies the exact visual formatting of the source cell to the destination cell in just a couple of clicks.

Select the source cell

Click on the cell (e.g., A3) that contains the formatting you want to copy.

Activate the Format Painter

Navigate to the 'Home' tab on the top ribbon and click the 'Format Painter' icon (it looks like a paintbrush).

Apply to the target cell

Click on the target cell (e.g., A1) to instantly apply the copied formatting.

Use Format Painter to Copy Cell Appearance

Tip for multiple cells: If you need to apply the same format to multiple non-adjacent cells, double-click the Format Painter icon to keep it active, then click on all desired target cells. Press Esc to deactivate it.

Solution 2

Use a Formula to Link Cell Values

Use a simple equal sign formula to link two cells, ensuring the target cell always displays the exact value of the source cell and updates dynamically.

WPS Spreadsheet

Easily Copy Formatting and Link Data in WPS Spreadsheet

WPS Spreadsheet provides intuitive tools like the one-click Format Painter and seamless formula auto-complete, making it effortless to style your data or dynamically link cells across your workbooks.

1. Open your file: Launch WPS Spreadsheet and open your workbook.
2. Copy Formatting: Select the source cell, click the 'Format Painter' icon on the Home tab, and click your destination cell.
3. Link Values: To synchronize data, type '=' in the target cell, click the source cell, and press Enter to complete the link.

Accessible Format Painter for instant style replicationSeamless compatibility with Microsoft Excel (.xlsx) formatsDynamic cell referencing for automated data updatesLightweight, free, and familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Can I copy both the formatting and the value without linking them?

Yes, you can use the standard Copy and Paste functionality. Select the source cell, press Ctrl+C, select the target cell, and press Ctrl+V. This copies both the static value and the format without creating a dynamic link.

Why isn't my linked cell value updating automatically?

Your calculation options might be set to 'Manual'. Go to the 'Formulas' tab on the ribbon, click on 'Calculation Options', and verify that 'Automatic' is selected so formulas update in real-time.

How do I remove the formatting from a cell but keep the value?

Select the cell you want to clear. Go to the 'Home' tab, locate the 'Clear' button (often represented by an eraser icon), and choose 'Clear Formats'. The cell will revert to the default style while retaining its data.

Document & File Issues