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.

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

Similar Content on TeachExcel
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 E...
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...
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 Clear all Formatting in Excel
Tutorial: How to remove all formatting from cells at once in Excel. This includes removing any and...