Understanding Autofill Series and Justify Option in Excel with Examples

---

✅ Autofill Series in Excel

🔍 What is Autofill?

Autofill is a feature in Excel that allows users to automatically fill cells with data that follows a pattern or series, such as numbers, dates, days, months, or even custom lists.

🔹 How to Use Autofill:

1. Type the starting value in a cell.
2. Drag the fill handle (small square at the bottom-right of the cell) across or down to fill other cells.
3. Excel detects the pattern and fills accordingly.

🔄 Common Series You Can Autofill:

Type	Example Input	Autofill Result
Numbers	1, 2	1, 2, 3, 4, …
Dates	1-Jan	1-Jan, 2-Jan, 3-Jan, …
Days	Monday	Monday, Tuesday, …
Months	Jan	Jan, Feb, Mar, …
Text + Numbers	Item1	Item1, Item2, …

🛠️ Customizing Series:

• Go to Home > Fill > Series for more control.
• Options: Linear, Growth, Date, AutoFill, etc.

✅ Example 1: Linear Series

• Type 2 in A1, then 4 in A2.
• Select A1:A2 and drag down.
• Excel will fill: 2, 4, 6, 8, 10…

✅ Example 2: Days of the Week

• Type Monday in A1, drag down.
• Excel fills: Monday, Tuesday, Wednesday…

✅ Example 3: Custom List

• Go to File > Options > Advanced > Edit Custom Lists
• Add a custom list like: “Bronze, Silver, Gold, Platinum”
• Now you can Autofill this sequence.

---

✅ Justify Option in Excel

🔍 What is Justify?

The Justify feature in Excel is used to realign and reflow long text entries across multiple rows so that it fits within a specified column width.

🔹 How to Use Justify:

1. Type a long sentence or paragraph in one cell.
2. Select a range of empty cells in a single column (vertical).
3. Go to Home > Fill > Justify.

Excel breaks the text and distributes it across the selected rows, wrapping the words neatly.

📌 Important Notes:

• Works only with text in one column.
• The column must be wide enough, and the destination cells must be empty.
• It doesn’t wrap inside a cell but spreads across multiple cells vertically.

✅ Example:

Let’s say A1 contains:

"Excel Justify option is useful for breaking long text into multiple lines within one column."

Select A1:A4 → Go to Home > Fill > Justify.

Result:

A1: Excel Justify option is
A2: useful for breaking long
A3: text into multiple lines
A4: within one column.

This is useful for cleaning up or displaying long data entries in a more readable format.

---

🧠 Summary:

Feature	Purpose	Example Use Case
Autofill	Fill cells automatically in a pattern	Fill dates, numbers, or custom lists
Justify	Reflow long text across rows in one column	Cleanly break long text into readable parts

---

Watch the Video for Autofill Series and Justify options

---

---