The SEQUENCE function allows you to generate a list of sequential numbers in an array, such as 1, 2, 3, 4. In the following example, we created an array that's 4 rows tall by 5 columns wide …

The sequence might be interrupted if you add, move, or delete rows. You can manually update the numbering by selecting two numbers that are in the right sequence and then dragging the …

You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.

A UML sequence diagram shows how a set of objects interact in a process over time. It shows the messages that pass between participants and objects in the system, and the order in which …

Combine text from two or more cells into one cell. Have Excel automatically fill your data when it detects a pattern. For example, the months of the year, the days in a month, or a sequence of …

Change numbering on a list to any number, such as continuing a list after a paragraph.

Spill means that a formula has resulted in multiple values, and those values have been placed in the neighboring cells. For example, =SORT (D2:D11,1,-1), which sorts an array in descending …

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

When you move the focus to an existing record on a form, enter or change data in the record, and then move the focus to another record, the following sequence of events occurs for the form:

Example 1 Vertically appends two simple arrays in sequence so that the results are one array.

SEQUENCE (ROW ()) can be used to replicate the old behavior of ROW in a legacy array formula. Any new formulas that return more than 1 result will automatically spill.