Log in
x
or
x
x
Register
x

or
0
0
0
s2smodern

Copy a cell formatting from one cell to other cells in Excel

Have you ever been there before, when there is a cell has exactly the formatting which you want to apply to other cells in Excel? That's for sure, and we can use the Format Painter to quickly copy formatting from one place and apply it to another. But how about copying specific formatting from one place and apply it to other cells? That's why we build the Kutools for Excel's Copy Cell Formatting utility, because Format Painter can only copy all formatting from one place in Excel. We can quickly apply these operations in Excel with Copy Cell Formatting.

Copy specific formatting from one cell and apply it to other cells


Click Kutools >> Format >> Copy Cell Formatting, see screenshots:

shot copy cell formatting 01-1 arrow-big shot copy cell formatting 02-2

Copy specific formatting from one cell and apply it to other cells

To copy and apply some specific formatting from one cell to other cells you selected, please do as follows:

1. Select a single cell (A1 for example) that you want to apply its formatting to other cells.

2. And then apply this utility by clicking Kutools > Format > Copy Cell Formatting.

3. In the Copy Cell Formatting dialog box, please specify the formatting attributes for other cells you want to apply, see screenshot:

shot copy cell formatting 03-3

4. Then click OK, and select the cells that you want to apply this formatting in the prompt box, see screenshot:

shot copy cell formatting 04-4

5. Then click OK button, the specific cell formatting from cell A1 has been applied to the selected cells at once, see screenshot:

shot copy cell formatting 05-5


Note:

This tool supports undo (Ctrl + Z).


Demo: Copy a cell formatting from one cell to other cells in Excel

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.