Cell Styles in Excel

Cell Styles help you quickly format cells with just one click.
Instead of changing font, color, borders one by one, you can apply a ready-made style instantly.

---

1. Apply a Built-in Cell Style

Steps:

1. Select a cell (e.g., B2)
   
2. Go to the Home tab
   
3. In the Styles group, click Cell Styles
4. Choose a style you like

Result:

---

2. Create Your Own Cell Style

If the built-in styles are not enough, you can make your own.

Steps:

1. Go to Home tab
2. Click the small arrow in the Styles group
3. Click New Cell Style
4. Enter a name
5. Click Format… and customize:
   • Number format
   • Alignment
   • Font
   • Border
   • Fill (color)
6. Click OK

---

3. Use Your Custom Style

1. Select a cell or range
2. Go to Cell Styles
3. Click your custom style

---

4. Edit or Delete a Style

• Right-click a style → Modify or Delete
• If you modify a style → it updates all cells using it

👉 This is very powerful and saves time!

---

5. Use Styles in Another Workbook

• Open both Excel files
• Go to Cell Styles → Merge Styles
• Import styles from the other file

---

Table Styles

You can also format a whole table quickly:

1. Select a range of cells
2. Go to Home → Format as Table
3. Choose a style

---

Important Notes

• Cell styles are saved in the workbook where you create them
• Changing a style affects all cells using that style
• Great for keeping formatting consistent