How do I set the Excel fill sequence?

How do I set the Excel fill sequence?

1, the regularity of the number of numbers of filling: for the number of filling, usually, we only need to enter the first two digits to complete the entire sequence of fill. The implementation method: Enter the first two digits, then select the two digits, move the cursor to the lower right corner of the selection, press and hold when the mouse changes to ten, and then drag to automatically generate the desired sequence.

2. Fill the formula sequence: for a sequence of formulas, you usually just enter a formula and then copy or drag the formula to fill the other cells.

3, cell reference sequence fill: In Excel, there are three kinds of cell references, one is relative reference, the other is absolute reference, and one is the relative driver reference. The relative reference changes as the cell changes, and the absolute reference does not change as the cell changes.