Black Friday Sale!

Ends in:

Quickly Copy Cell Formatting to Other Cells in Excel

Add to Favorites
Author:
BLACK FRIDAY SALE (65%-80% Off)

Excel Courses Online
Video Lessons Excel Guides

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.

Notes

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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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. ...
Use Formatted Dates and Numbers within Other Text in Excel
Tutorial: How to put dynamic formatted dates and numbers into text in Excel. This allows you to hav...
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...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course