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 Google Sheets
Google Sheets autofills with the **fill handle** for dragging patterns and formulas, plus **Smart Fill** that suggests values based on examples you've typed.
Use the fill handle
- Type a value or formula in a cell.
- Hover the small blue square in the bottom-right of the cell (the fill handle).
- Drag down or across to copy; double-click the handle to fill down next to existing data.
Continue a series
- Enter the first two values of a sequence (1, 2 or Jan, Feb) in adjacent cells.
- Select both cells, then drag the fill handle—Sheets extends the pattern.
- To fill dates by month or weekday, type the first two dates in the pattern, then drag.
Smart Fill for text patterns
- In a new column, type one or two output examples (e.g. extracting last names from a Full Name column).
- Sheets shows a Smart Fill suggestion banner; press Ctrl/Cmd + Enter to accept.
- Or trigger explicitly via Data → Smart Fill (or Ctrl + Shift + Y).
Tips
- Smart Fill works best with consistent source data; clean column headers first.
- Drag with the fill handle while holding Ctrl/Cmd to copy without continuing a series.
Try it faster with guidance
Skip the menu hunt—let Vocordia guide you through it with voice and on-screen cursor guidance so you can fill thousands of rows in seconds.
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.