1.5Sort, autofill & series
The essentials in 30 seconds
- The handle guesses the rest: two values (1; 2) + drag = series 3, 4, 5…; a single value = copy as is — built-in lists (Monday, January…) and dates (days, months) included.
- Sort the table, not the column: select the whole table (or one cell inside, Excel extends) via Data ▸ Sort — sorting an isolated column disconnects the rows.
- The test that saves you: after sorting, each name stays attached to its amount — otherwise, undo (Ctrl+Z) and start over on the whole table.
Running mini-case — Wassim prepares the monthly trial balance
Last gesture of the month: Wassim numbers 60 entries (1, 2, drag the handle → 1 to 60 in three seconds), generates January's dates by dragging a date with the «month» option, then sorts the table by amount to spot anomalies — whole table selected, each row follows. The sort that, last year, had mixed up clients and amounts will not happen again: the whole table, always.
End of the 1.1-1.4 thread — Wassim wraps up the month: numbers, dates, safe sorting.
1. The fill handle
The small square at the bottom-right of a selection is the fill handle. By dragging it, Excel copies (shifted formulas) or creates a series. With two selected values (1; 2), it guesses the step (3, 4, 5…). It also knows the built-in lists: Monday, Tuesday… or January, February…
Wassim numbers his entries this way: 1 and 2 entered, both selected, one drag — sixty numbers without typing.
2. Date and custom series
Dragging a date creates a series of days; with the fill menu, you choose «weekdays», «month» or «years». You can create your custom lists (e.g. the list of branches) to regenerate them with a simple drag.
For Wassim: a January date dragged with the «month» option generates the twelve due dates — without a calendar or copy-paste.
3. Sorting without breaking the table
To sort, you select the whole table (or a single cell inside, Excel extends), not a single isolated column — otherwise the rows disconnect and the data gets mixed up. You sort via Data ▸ Sort, choosing the column and the order; structured tables (level 2) make this gesture even safer.
Wassim's reflex: before any sort, a backup (or a ready Ctrl+Z), then a name = amount check on three random rows.
The single-column sorter (never do this)
Morality: sorting a single column is redistributing debts at random.
🔎 Concrete example — 🔎 Concrete example — The sort that mixes everything up
Classic danger: sorting a single column of a table.
❌ Select ONLY the «Amount» column then Sort
→ the amounts are sorted, but the names stay in place → wrong rows
✅ Select the whole table (or one cell inside) then Sort
→ the whole row follows → consistent dataReading: sorting an isolated column dissociates the data from their rows.
Lesson: you sort the whole table, never a single column.
Section vocabulary
- Fill handle
- Small square at the bottom-right of a selection; copies or creates a series when dragged.
Simple example: Wassim numbers 60 entries in a single drag.
What it is not: a Sort button on the ribbon.
Reflex: dragging = guessing the rest or copying.
- Series
- A sequence generated automatically (numbers, dates, days, lists) from a guessed step.
Simple example: 1; 2 dragged give 3, 4, 5…; January gives February, March…
What it is not: a copy as is (1, 1, 1).
Reflex: two values to impose the step.
- Sort
- Reordering rows according to one or more columns, via Data ▸ Sort.
Simple example: Wassim's table sorted by amount, rows intact.
What it is not: a sort of an isolated column that mixes the rows.
Reflex: the whole table selected, never a single column.
- Custom list
- A user-defined sequence (branches, codes…) regenerable by dragging.
Simple example: The Algiers branches re-entered in one gesture each month.
What it is not: a calculation formula.
Reflex: lists that come back = custom list.
In practice — In practice — Safe series and sorting
- Enter 1 and 2, select them, drag the handle: get 1..10.
- Drag a date to generate a series of days, then test «month».
- On a small Name/Amount table, sort by Amount by selecting the whole table.
- Check that each name stayed associated with its amount.
Ready-to-say script — sorting without risk (30 s)
« I never sort a single column: I click a cell of the table, Data, Sort, by Amount. The whole table follows — each name stays attached to its amount. And I check three random rows before saving. »
Say it while sorting live, with a Ctrl+Z ready in case of a slip.
Copy-paste template — safe sorting
1. Click ONE cell in the table
2. Data ▸ Sort → «Amount» column, ascending order
3. Check 3 rows: name = original amount?
4. Doubt? Ctrl+Z then start over (whole table)Wassim's trial balance
As above: 60 numbers + 12 due dates by dragging, sort by amount on the whole table — rows intact.
Cash weeks
«Monday» dragged gives Tuesday, Wednesday…: the seven days without typing them, handy for schedules.
Invoice ranks
Prefix + series (INV-2026-001, 002…): two cells entered to fix the step, then drag.
Recurring branches
Custom list of branches: one drag regenerates the official order each month, without a mistake or omission.
✓ Best practices
- Two values → Excel guesses the step.
- Sort via Data ▸ Sort on the whole table.
- Create recurring custom lists.
✗ Common pitfalls
- Sorting a single column → disconnected rows.
- Dragging a single value hoping for a series.
- Sorting data mixed with totals.
Key takeaways
- The fill handle copies or creates series.
- Two values are enough to guess the step.
- Date series: days, months, years, weekdays.
- Sorting: select the whole table, never a single column.
48h challenge — apply tomorrow
Number 30 rows by dragging (1; 2 then slide), generate a date series, then sort a whole table by amount and check three rows.
- I generate series and dates by dragging.
- I sort the whole table via Data ▸ Sort.
- I check that the rows stayed consistent.
Frequently asked questions
Why does dragging «1» give «1, 1, 1» and not «1, 2, 3»?
With a single value, Excel copies as is. For an incremented series, enter two values (1 and 2) so it deduces the step, or use the fill menu ▸ Series.
How to definitively avoid the sort that mixes the rows?
Convert the range into a structured table (Insert ▸ Table, seen in level 2): sorting and filters there always act on the whole row, which removes the risk.
How do you sort a table without mixing the rows?