This FAQ focuses on 3 common question types about sequence recognition, overwriting existing data, and date filling, and also includes a short glossary.
FAQ
Can Fill recognize a sequence pattern?
- Yes, it can recognize common number sequences.
- For example, if you enter 1 and 2 first, then select both cells and fill, the result usually continues the increasing pattern.
- If you only want to repeat the same content, switch to Copy Fill after dragging.
Will Fill overwrite existing data?
- Yes. Existing data in the target area can be replaced by the new fill result.
- Check the destination area before dragging if you need to keep current content.
- If the result is not what you want, use Undo right away to revert it.
Can Fill extend dates automatically?
- Yes, date values can be used for continuous filling.
- Enter a starting date or a simple date pattern first, then use Series Fill.
- After filling, review the result to make sure the date interval matches what you need.
Glossary
| Term | Definition |
|---|---|
| Fill | A spreadsheet feature that copies existing content into adjacent cells or extends a pattern into nearby cells. |
| Copy Fill | A fill mode that repeats the original content without increasing or decreasing numbers, dates, or other patterns. |
| Series Fill | A fill mode that generates continuous results based on the pattern in the selected cells, such as numbers or dates. |