Skip to content

Create Cell Styles to Save Time in Excel

So you just spent five minutes formatting a cell to make it look just right. The only problem is – you need to add the same formatting to a bunch of other cells scattered throughout your workbook.

That will take forever, won’t it?

Here is a tip that will save you a lot of work and time.

How to Repeat Formatting Quickly

There are many tools available for you to use in Excel to help you repeat formatting throughout your workbook. In this article, I will show you how to use cell styles.

Cell styles allow you to design the formatting for a cell once and then apply that same formatting to other cells with a single click.

For example, here I have a cell that I spent some time formatting.

If I translate this formatting design into a cell style, I can then immediately apply it to another cell or range of cells.

How to Create a Cell Style

There are a few different ways you can create cell styles in Excel. I will show you the easiest method.

The first step is to format a cell you want to model the cell style after. For instance, I have added many different types of formatting to the cell below.

Select the cell once you have it formatted the way you want. Next, click on the Home tab in the ribbon and then click on the down arrow next to the cell styles.

From here, select New Cell Style.

Give your cell style a name, then click on Ok.

You will now see your new cell style listed among the other cell styles in the ribbon.

How to Apply the Cell Style

Now that you have created your cell style, all you have to do is apply it to the other cells you want to format.

Just select the cell or range of cells you want to format, and click on the cell style in the ribbon to apply it.

The style is added to the selected cells, and you’ve replicated your formatting with the click of a button.

And that is one of the fastest and easiest ways to replicate your formatting throughout your Excel workbook.

This Post Has 2 Comments

  1. This is so cool!! Does the formatting style stay in the styles box for future uses of Excel? Like if I close out the workbook that I’m working in, will it be in the new workbook that I open up?

    1. Hi Meagan! What a great question!

      Unfortunately, cell styles you create in one workbook are not automatically available in another workbook. You would have to re-create the style in each workbook.

      I hope this helps.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top