How to Copy a Cell Formatting from One Cell to Other Cells in Excel 365?
Tags: copyacellformattingi, kutoolsexceltutorial, kutools
Published: 2020-11-02 12:06:52

---
title: How to Copy a Cell Formatting from One Cell to Other Cells in Excel 365?
published: true
date: 2020-11-02 12:00:02 UTC
tags: CopyaCellFormattingi,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-copy-a-cell-formatting-from-one-cell-to-other-cells-in-excel-365/
---

In this post, we will understand the steps to **Copy a Cell Formatting from One Cell to Other Cells in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Copy Specific Formatting from One cell to Other Cells:

To do this, you need to follow the below instructions.

- First, you need to **select a single** cell that you want to apply the formatting to other cells.

![Select a single cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-a-single-cell.png)<figcaption id="caption-attachment-16720">Select a single cell</figcaption>

- On the **Kutools Tab, select** the **Format** option, then **choose** the **Copy Cell Formatting** option from the drop-down list.

![Select the Copy Cell Formatting option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-Copy-Cell-formatting-option.png)<figcaption id="caption-attachment-16721">Select the Copy Cell Formatting option</figcaption>

- It will open the **Copy Cell Formatting Dialog box**.
- Kindly, **specify the formatting attributes** that you want to apply to other cells in the dialog box.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button-1.png)<figcaption id="caption-attachment-16722">Click the OK button</figcaption>

- Then, **click** the **OK** button. It will open a prompt box to ask you to select the range for applying the formats.
- After specifying the range in the **Paste to** box, **hit** the **OK** button.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-range.png)<figcaption id="caption-attachment-16723">Select the range</figcaption>

- At last, the specific cell formatting from the **cell B1** will apply to the selected range as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output.png)<figcaption id="caption-attachment-16724">Output</figcaption>

## Closure:

From this post, you can quickly understand the steps to **Copy a Cell Formatting from One Cell to Other Cells in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment box. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Allow Only the Specific Characters to be Entered in a Range of Cells in Excel!](https://geekexcel.com/steps-to-allow-only-the-specific-characters-to-be-entered-in-a-range-of-cells-in-excel/)
- [How to Create a Step Chart in Excel using Kutools?](https://geekexcel.com/how-to-create-a-step-chart-in-excel-using-kutools/)
- [How to Copy Multiple Sheets Multiple Times in Excel Office 365?](https://geekexcel.com/how-to-copy-multiple-sheets-multiple-times-in-excel-office-365/)
- [Remove All Blank Rows from Bottom/a Range in Excel Office 365!!](https://geekexcel.com/wp-admin/post.php?post=16525&action=edit)