Autofill and Flash Fill

When entering data into large tables, it often happens that some of the values ​​that we enter are repeated. Excel offers two automations that make it easy to enter. The first one is called Autofill and starts automatically as soon as we start typing the text with a template that already existed in the current column. Flash Fill offers data filling based on forms that Excel recognizes in previous columns within the same table.

Data series

When entering data into a table among them, there is often a meaningful connection, that is, they belong to a certain set of data. This is most commonly encountered when filling out the regular numbers in the table. Excel has fine mechanisms for automatically filling data sets that, apart from numbers, can also be used to fill dates, as well as to copy values ​​in a table. The following text will be about the series of data series.