How to Apply Cell Styles in Excel for Cleaner Spreadsheets

Written By Sophanith Dith
Last Updated June 09, 2026
Applies to Microsoft Excel 365 (Windows only)
Part of the Beginner Learning Path
Module 3 Formatting and Layout
Lesson 7 of 14

Table of Contents

When you are new to Excel, it is easy to spend too much time changing fonts, colors, borders, and alignment one cell at a time. Your worksheet may look better for a while, but it can quickly become inconsistent if every heading, total, and note is formatted differently.

That is why learning how to apply cell styles in Excel is useful. Cell Styles let you apply a ready-made group of formatting choices with one click. Instead of manually formatting each important cell, you can choose a built-in style such as Heading, Total, Good, Bad, or Neutral.

Cell Styles help beginners make worksheets look cleaner and more organized without needing advanced design skills. They are especially helpful when you want titles, labels, totals, and important values to stand out in a consistent way.

By the end of this tutorial, you will know where Cell Styles are, how to use them, how to remove them, and how to create a basic custom style for your own workbook.

Quick Answer:
To apply Cell Styles in Excel, select the cell or range you want to format, go to the Home tab, open the Cell Styles gallery in the Styles group, and choose a style. Excel applies the style’s formatting, such as font, color, borders, fill color, or number formatting, to the selected cells.

Quick Reference

Cell Styles are simple once you know where to find them. Use this quick reference first, then follow the detailed steps below for examples and beginner tips.

Cell Styles are found on the Home tab in the Styles group.
Select the cells first, then choose a style from the Cell Styles gallery.
Built-in styles can format headings, totals, warnings, notes, and calculation results.
The Normal style can remove a cell style from selected cells.
Custom styles let you save your own reusable formatting combination.
Cell Styles are best for consistent formatting across a workbook.

The rest of this tutorial explains each part step by step so you can use Cell Styles with confidence.

What Are Cell Styles in Excel?

Before you apply Cell Styles, it helps to understand what they are. A cell style is a saved set of formatting choices that Excel can apply to a cell or range with one click.

A style may include formatting such as font size, bold text, fill color, font color, borders, alignment, or number format. Instead of applying those choices separately, Excel Cell Styles combine them into one reusable option.

For example, you might use:

A Heading style for section titles.
A Total style for final amounts.
A Note style for reminders.
A Good, Bad, or Neutral style for simple status labels.
A custom style for a repeated worksheet design you want to reuse.

The main benefit is consistency. If all your totals use the same Total style, readers can quickly understand which numbers are final results. If all your notes use the same Note style, they are easier to identify.

Beginner Tip:
Think of Cell Styles as formatting presets. They do not change the meaning of your data. They only change how the selected cells look.

Cell Styles are part of Excel formatting, so they fit naturally with other layout skills. If you are still learning basic formatting, you may also want to review How to Add Borders in Excel because many styles use borders to separate important cells visually.

Once you know what styles are meant to do, the next step is finding them in the Excel interface.

Where to Find Cell Styles in Excel

Cell Styles are available from the Home tab, which is where many beginner formatting tools are located. Since the Home tab is usually open by default, this feature is easy to access once you know the exact button.

You will find Cell Styles in the Styles group. This is the same area where Excel also shows formatting tools such as Conditional Formatting and Format as Table, but this lesson focuses only on Cell Styles.

To find the Cell Styles button:

Go to the Home tab.
Look for the Styles group.
Click Cell Styles.
Review the style gallery that appears.

Depending on your screen size, you may see the Cell Styles button directly, or you may need to expand the Styles group area to see more options.

The gallery usually includes categories such as Good, Bad and Neutral, Data and Model, Titles and Headings, Themed Cell Styles, and Number Format styles. You do not need to memorize every category. For beginners, the most useful styles are usually Heading, Total, Note, Good, Bad, and Neutral.

Beginner Warning:
Do not confuse Cell Styles with Format as Table. Format as Table changes a data range into an Excel table with table features. Cell Styles only apply formatting to selected cells.

Now that you know where the button is, you can apply your first style to a worksheet.

How to Apply Cell Styles in Excel Step by Step

The basic process is simple: select the cells first, then choose the style. Excel applies the selected style immediately, so you can see the result right away.

This is the most important part of the tutorial because it answers the main question directly. Once you learn these steps, you can apply cell styles to headings, totals, notes, or important values in any workbook.

Apply a Built-In Cell Style

Use this method when you want to apply one of Excel’s ready-made styles. Built-in styles are helpful because they already include common formatting combinations.

Follow these steps:

Select the cell or range of cells you want to format.
Go to the Home tab.
In the Styles group, click Cell Styles to open the style gallery.
Move your pointer over a style to preview it.
Click the style you want to apply.

For example, if cell A1 contains the title “Monthly Sales Summary,” you could select A1 and apply a Heading style. If cell B10 contains the final total, you could select B10 and apply a Total style.

Excel applies the style to the selected cell or range. If you do not like the result, you can choose a different style or undo the action.

Beginner Tip:
Select the cells before opening Cell Styles. If no cell is selected, Excel may apply the style only to the active cell, which might not be what you intended.

For Microsoft’s official instructions, you can also visit the Microsoft Support guide on how to apply, create, or remove a cell style.

Apply a Style to Multiple Cells at Once

You do not have to apply styles one cell at a time. If several cells need the same look, select them together before choosing the style.

For example, suppose row 1 contains headings such as “Product,” “Region,” “Sales,” and “Profit.” Select A1:D1 and apply one heading style to all four cells at the same time.

Follow these steps:

Select the full range you want to format, such as A1:D1.
Go to Home → Styles → Cell Styles.
Choose a heading style.

This saves time and keeps your worksheet consistent. It is especially useful when formatting report sections, summary blocks, or repeated labels.

Beginner Warning:
Be careful when selecting a large range. If you accidentally include data cells along with heading cells, Excel will apply the heading style to all selected cells.

Cell Styles are useful because they make formatting faster, but they are most powerful when you choose the right style for the right purpose.

Common Cell Styles Beginners Should Know

Excel includes many built-in Cell Styles, but beginners do not need to use all of them. A few common styles are enough for most simple worksheets.

The table below explains several useful styles and when you might use them. This helps you choose styles based on the purpose of the cell, not just the color you like.

The exact colors may look different depending on the workbook theme, but the style names and purpose are usually easy to recognize.

Cell Style Type	Best Used For	Simple Example
Heading	Section titles or worksheet labels	“Monthly Sales”
Total	Final totals or summary results	Grand total at the bottom of a list
Note	Extra reminders or explanations	“Check prices before sending”
Good	Positive status or result	“Completed”
Bad	Problem, warning, or failed result	“Over Budget”
Neutral	Middle status or general label	“Pending”
Calculation	Formula result cells	A calculated sales total

The names of the styles help readers understand the meaning of the formatting. For example, using a Total style on a final number makes the result easier to find. Using a Note style on a reminder makes it stand out without making it look like part of the main data.

Beginner Tip:
Use styles based on meaning. A style should help the reader understand the worksheet, not just decorate it.

If you are formatting a title across several columns, that is a different skill from Cell Styles. You can review How to Merge and Center in Excel if you need to create a centered worksheet title.

Once you start using styles, you may also need to remove or change them when the formatting no longer fits.

How to Remove a Cell Style

Sometimes you apply a style and later decide the cell should go back to regular formatting. Excel makes this easy with the Normal style.

The Normal style returns the selected cells to Excel’s standard cell appearance. This is the safest beginner-friendly way to remove a Cell Style without deleting the style from the workbook.

Remove a Style from Selected Cells

Use this method when you only want to remove the style from specific cells.

Follow these steps:

Select the cells that have the style you want to remove.
Go to the Home tab.
Click Cell Styles in the Styles group.
Under the style gallery, choose Normal.

Excel removes the applied style from the selected cells and returns them to the normal worksheet look.

Beginner Warning:
Removing a style from a cell is not the same as deleting a style from Excel. Choosing Normal only changes the selected cells. It does not remove the style from the Cell Styles gallery.

What If Some Formatting Remains?

In some cases, a cell may still look formatted after you choose Normal. This can happen if formatting was applied manually after the style was used.

For example, you might apply a Heading style and then manually change the fill color. Later, choosing Normal may not always remove every manual formatting change the way you expect.

If you need to remove all formatting from a cell, use Excel’s Clear Formats command instead. That is different from removing a Cell Style, so this lesson focuses only on the style-related method.

Cell Styles are not only for built-in formatting. You can also create your own style when you want a repeated look that is not already available in the gallery.

How to Create a Custom Cell Style in Excel

Built-in styles are useful, but they may not always match the look you want. If you often use the same font, fill color, border, or number format, you can create a custom style and reuse it in the same workbook.

This is where beginners start to see the real value of Cell Styles. Instead of formatting every important cell manually, you can save your preferred format as a named style.

Create a New Custom Cell Style

Use this method when you want to build a style from scratch.

Follow these steps:

Go to the Home tab.
In the Styles group, click Cell Styles.
Click New Cell Style.
In the Style name box, type a clear name, such as Input Cell or Final Total.
Click Format.
Choose the formatting options you want.
Click OK to close the Format Cells dialog box.
Click OK again to save the new style.

For example, you might create a custom style named “Input Cell” for cells where users should type information. You could give it a light fill color and a border so it is easy to see.

Beginner Tip:
Use clear names for custom styles. Names like “Input Cell,” “Final Total,” or “Review Note” are easier to understand later than names like “Style 1” or “Blue Format.”

What Formatting Can a Custom Style Include?

A custom style can include several types of formatting. You do not need to use every option. For most beginner worksheets, simple formatting is better.

A custom style may include:

Number format
Alignment
Font formatting
Border
Fill color

For example, a “Final Total” custom style might include bold text, a border above the cell, and a number format. A “Note” custom style might include italic text and a light fill color.

This connects to other formatting lessons, but you do not need to re-learn them here. If you want more control over text position, review How to Align Text in Excel. If your style uses borders, review How to Add Borders in Excel.

Beginner Warning:
Custom cell styles are saved in the workbook where you create them. If you open a different workbook, your custom style may not automatically appear there.

Now that you know how to apply and create styles, it helps to understand when they are actually the best choice.

When Should You Use Cell Styles?

Cell Styles are helpful, but they are not needed for every formatting task. Beginners often get better results when they use styles for repeated formatting, not for every single cell.

The goal is to make the worksheet easier to read. A good style should guide the reader’s eye to important information such as headings, totals, notes, or status labels.

Use Cell Styles when:

You want headings to look consistent.
You want total rows or total cells to stand out.
You want to mark notes or reminders clearly.
You want repeated input cells to have the same appearance.
You want a cleaner workbook without manually formatting every section.

For example, in a file named Budget.xlsx, you might use a Heading style for “Monthly Budget,” a Note style for reminders, and a Total style for the final spending amount.

Cell Styles are especially useful in workbooks that other people will read. Consistent formatting helps users understand the structure faster.

Beginner Tip:
Use fewer styles, not more. A worksheet with two or three meaningful styles usually looks cleaner than a worksheet with many colors and font changes.

However, there are times when another formatting tool may be a better choice.

When Not to Use Cell Styles

Cell Styles are useful, but they are not the answer to every formatting problem. Sometimes beginners use them when a simpler tool would be better.

This section helps you avoid using Cell Styles in the wrong situation. Choosing the right tool keeps your workbook easier to manage.

Do not rely on Cell Styles when:

You only need to format one cell one time.
You want Excel to change formatting automatically when a value meets a rule.
You are formatting a full data table with filter buttons.
You only want to copy formatting from one cell to another quickly.
You need a very specific layout change that does not need to be reused.

For example, if you want cells to turn red automatically when a value is below zero, that is a Conditional Formatting task, not a Cell Styles task. If you want to format a full list as a structured table, that belongs to Format as Table. If you simply want to copy formatting from one cell to another, the next lesson on How to Use Format Painter in Excel is a better fit.

Beginner Warning:
Do not use Cell Styles just to make a worksheet colorful. Formatting should make the workbook easier to understand.

By knowing when to use Cell Styles and when to use another tool, your worksheets will look cleaner and stay easier to edit.

Practical Example: Format a Simple Sales Summary with Cell Styles

A practical example makes Cell Styles easier to understand. In this example, imagine you have a small sales summary with a title, column headings, sales numbers, and a final total.

The goal is not to make the worksheet fancy. The goal is to make each part of the worksheet easy to recognize.

Suppose your worksheet looks like this:

Cell or Range	Content
A1	Monthly Sales Summary
A3:C3	Product, Region, Sales
A4:C8	Sales data
A9	Total Sales
C9	Final total amount

You could format it with Cell Styles like this:

Select cell A1.
Go to Home tab → Styles group → Cell Styles.
Apply a Heading style.
Select A3:C3.
Go to Home → Cell Styles.
Apply a heading or accent style.
Select A9:C9.
Go to Home → Cell Styles.
Apply a Total style.

After these steps, the worksheet is easier to read. The title stands out, the column headings are clearer, and the final total is easier to find.

Beginner Tip:
Try applying styles to only the most important parts of the worksheet first. You can always add more formatting later if needed.

This example also shows why Cell Styles are helpful for beginners. You do not need to choose every font, border, and color yourself. Excel gives you ready-made options that already work together.

Common Mistakes When Applying Cell Styles

Cell Styles are simple, but a few beginner mistakes can make worksheets look confusing. Knowing these mistakes early will help you use the feature more effectively.

Most problems happen when styles are used too often, applied to the wrong cells, or mixed with too much manual formatting.

Mistake 1: Applying Too Many Styles

Using too many styles can make a worksheet harder to read. If every row has a different color or font, the reader will not know what is important.

A better approach is to use a small number of meaningful styles. For example, use one style for headings, one for notes, and one for totals.

Mistake 2: Formatting Data Cells Like Headings

Headings and data cells should not look the same. If regular data cells are formatted like headings, the worksheet becomes harder to scan.

Use heading styles only for labels, titles, and section names. Use simpler formatting for normal data.

Mistake 3: Manually Changing Styled Cells Too Much

After applying a style, beginners sometimes keep changing the font, fill color, border, and alignment manually. This can remove the benefit of using a style in the first place.

If you need the same look again and again, create a custom cell style instead of manually changing each cell.

Mistake 4: Confusing Cell Styles with Table Styles

Cell Styles and Table Styles are different. Cell Styles format selected cells. Table Styles are used when you turn a data range into an Excel table.

If you only want to highlight a title, note, or total, use Cell Styles. If you want table features such as filter arrows and structured table formatting, use Format as Table instead.

Beginner Warning:
If you are not sure which style to choose, start with simple styles such as Heading, Total, Note, Good, Bad, or Neutral. These are easier for readers to understand.

After avoiding these common mistakes, you can practice the skill in a small worksheet.

Quick Practice

Practice helps you remember where Cell Styles are and how they work. Use a small sample worksheet so you can test styles without worrying about damaging important data.

Try this quick exercise:

Open a blank worksheet.
Type “Weekly Expense Summary” in cell A1.
Type “Category” in A3.
Type “Amount” in B3.
Type a few expense categories in A4:A7.
Type sample amounts in B4:B7.
Type “Total” in A8.
Select A1 and apply a Heading style.
Select A3:B3 and apply a heading or accent style.
Select A8:B8 and apply a Total style.
Select one blank cell near the summary and apply a Note style.
Remove one style by selecting the cell and choosing Normal from Cell Styles.

This practice gives you the main skills from the lesson: applying a built-in style, using styles on multiple cells, and removing a style.

Once you finish, look at the worksheet and ask yourself whether the styles make the information easier to read. If the formatting feels too busy, remove one or two styles and keep only the most useful ones.

After you finish the practice exercise, take a moment to notice how the worksheet changes. The main goal is not just to make cells look nicer, but to make headings, notes, and totals easier to recognize.

Key Takeaways

Cell Styles are a simple way to make your worksheet look more organized without manually formatting every cell. They are especially useful for repeated formatting, such as headings, totals, notes, and status labels.

Here are the most important points to remember:

Cell Styles are found on the Home tab in the Styles group.
To apply cell styles, select the cells first, then choose a style from Home tab → Styles group → Cell Styles.
Built-in styles are useful for headings, totals, notes, and status labels.
The Normal style removes a Cell Style from selected cells.
Custom styles let you save your own formatting combination.
Use styles to improve readability, not just to add color.
Cell Styles are different from Table Styles and Conditional Formatting.

Cell Styles are a beginner-friendly way to create cleaner worksheets and build better formatting habits.

These are the main points to remember as you start using Cell Styles in your own workbooks. If you are still unsure about when to use styles, remove them, or create your own, the answers below cover the most common beginner questions.

Frequently Asked Questions (FAQs)

How do I apply Cell Styles in Excel?

Select the cell or range you want to format, go to the Home tab, click Cell Styles in the Styles group, and choose a style from the gallery. Excel applies the selected style to the cells you selected.

What are Cell Styles in Excel used for?

Cell Styles in Excel are used to apply consistent formatting quickly. They are helpful for headings, totals, notes, warnings, status labels, and other important cells that should stand out.

Can I create my own Cell Style?

Yes. To create a custom Cell Style, go to Home → Cell Styles → New Cell Style. Name the style, click Format, choose the formatting you want, and save it. This is useful when you want to reuse the same formatting in a workbook.

How do I remove a Cell Style?

Select the cells with the style, go to Home → Cell Styles, and choose Normal. This removes the applied style from the selected cells and returns them to the standard worksheet appearance.

Are Excel Cell Styles the same as Format as Table?

No. Excel Cell Styles apply formatting to selected cells. Format as Table turns a range into an Excel table with table features such as filter arrows and table-specific formatting.

Should beginners use Cell Styles or manual formatting?

Use Cell Styles when you want consistent formatting that may be repeated. Use manual formatting for small one-time changes. If you find yourself formatting the same type of cell again and again, a Cell Style is usually better.

Once you understand these common questions, Cell Styles become much easier to use in everyday worksheets. Let’s wrap up with the main reason this feature is worth practicing.

Conclusion

Learning how to apply cell styles in Excel is a simple but useful step toward creating cleaner, easier-to-read worksheets. Instead of changing fonts, colors, borders, and other formatting one piece at a time, you can apply a ready-made style with just a few clicks.

For beginners, the best way to use Cell Styles is to keep them meaningful. Use them for headings, totals, notes, and important labels so readers can understand your worksheet faster. Start with a few built-in styles, then try creating a custom style when you need reusable formatting for your own workbook.

This lesson is part of the Beginner Learning Path, a structured series designed to help you learn Microsoft Excel step by step from the basics.