Get hands-on help with Vocordia
You can do it the hard way - reading guides, switching tabs, figuring it out step by step.
Or you can do it the easy way.
Vocordia is your AI copilot across Excel and any software on your screen - just say what you want, and your cursor will guide you step by step, so you can get it done instantly without leaving your window.
How to Autofill in Excel
Excel's autofill works in two ways: the **fill handle** drags or extends patterns and formulas, and **Flash Fill** detects examples of how you want values to look and fills the rest.
Autofill with the fill handle
- Type a value or formula in a cell.
- Hover the bottom-right corner until you see a + (the fill handle).
- Click and drag down or across to fill; double-click the handle to fill down to the last adjacent row.
Use Series for sequences
- Type the first two values of a series (e.g. 1, 2 or Mon, Tue) in adjacent cells.
- Select both cells, then drag the fill handle—Excel continues the pattern.
- For more control, drag with the right mouse button and pick Series from the context menu (Linear, Growth, Date, AutoFill).
Flash Fill for text patterns
- In an empty column, type one or two examples of the output you want (e.g. extract first names from full names).
- Press Ctrl + E (or Data → Flash Fill).
- Excel infers the pattern and fills the column.
Common gotchas
- Flash Fill only works in a column adjacent to your source data.
- Mixed manual edits in the column can stop Flash Fill—clear the column first if it gets confused.
Try it faster with guidance
Skip menu hunting—let Vocordia guide you through it with voice and on-screen cursor guidance so you can pick the right autofill in one move.
Had to scroll back or switch tabs a few times?
That's the hard way.
Next time, just say what you want - and let your cursor guide you step by step to the result.