Quickly Copy Cell Formatting to Other Cells in Excel

Add to Favorites

How to copy all of the formatting of a single cell to other cells in the spreadsheet without having to re-apply each formatting element separately.  This will save you a lot of time when formatting spreadsheets.

Steps to Quickly Copy Cell Formatting to Other Cells

  1. Select the cell that contains the formatting that you want to replicate:
  2. On the Home tab click the Format Painter button on the left side of the menu.
  3. Then, simply click the cell that you want to also have that formatting.
  4. To add the formatting to multiple cells at once, follow steps 1 and 2 and then click, hold, and drag the mouse to select multiple cells at once.
  5. When you let go of the mouse button the format will be applied to all of the cells that you selected.

You have now completed in just a few seconds what would have taken you minutes to do by hand, especially with large lists.


If you mess-up, you can always hit Ctrl + Z to undo any unwanted changes.

If you need to remove all cell formatting, follow this tutorial for quickly removing all cell formatting in Excel.

Download the spreadsheet that accompanies this tutorial to try it out yourself.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Copy Data or Formatting to Multiple Worksheets in Excel
Tutorial: Quickly copy all or parts of a single worksheet - data, formatting, or both - to multiple...
Count The Number of Words in a Cell or Range of Cells in Excel - UDF
Macro: Count words in cells with this user defined function (UDF). This UDF allows you to count t...
Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
Macro: UDF to count the number of words in a cell or range with a user-specified delimiter. ...
Apply Conditional Formatting to Multiple Cells with a Single Formula
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in ...
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...
Quickly Copy the Last Action to Multiple Cells in Excel
Tutorial: In the previous tutorial I talked about the Redo button in Excel and how using Ctrl + Y ca...