How to fill down the formula in Excel only increments the number of columns, and the number of rows

There is a lock symbol $ in the excel formula, and you can lock the line number by adding it in front of the number of rows. For example, a formula like =a$1 is always 1 regardless of the line number copied to **.

In excel formulas, the $ lock symbol can lock the row number, the column number, or both. Commonly used in various excel formulas, the lock character is used in the English state input method when entering, and the shift can be entered by pressing the number key 4 of the main keyboard. You can also write the formula and select the cells that need to be locked, and press F4 to add a lock.

It's easy to put it another way.

a1=offset (schedule!) $a$1,,row()-1) is padded downward. Make the exact same formula:

Check the A1 input

Select the Schedules worksheet.

Select cell A1.

Press the F4 key 3 times. Enter.

Put the formula inside the a1

Changed to. a$1

Change according to your needs.

In other words, you can prefix the unchanged line number in the formula with the English dollar sign $.

a1=offset (schedule!) $a$1,,row()-1) Fill down to make the exact same formula:

Check the A1 input

Select the Schedules worksheet.

Select cell A1.

Press F4 key 3 to press Enter.

a1=indirect("List! r1c"&row(),0) If you want to do exactly what you want, you can do the following:

List! a$1

List! b$1

List! c$1

Copy the above and paste it in summary table A1.

You can make all the formulas in Notepad and paste them into the summary table A1).

Precede the number of rows with the absolute sign: $

Hope you try it!

Cause: Down-autofill is not set in **.

Solution: Method 1:

1. While dragging the cursor down to fill in the value, press the "Ctrl" button on the keyboard.

2. The number of drop-down fills can be incrementally filled.

Method 2: 1. Fill in the number "1" in cell A1 and select the cell that needs to be filled with increments.

2. Then click "Rows & Columns" in the toolbar and select "Fill" in the drop-down menu.

3. Then click on the "Sequence" option in "Fill".

4. In the pop-up "Sequence" dialog box, select "Type" as "Equal Difference Sequence" and click OK.

5. You can fill the selected cells into the incrementing value of the equal difference sequence.

1. For example, if you want to say a data, pull down from it to make an incremental series. Place the mouse in the lower right corner of the cell and click the drop-down when it becomes a cross.

2. See that the default sequence format is the same number.

3. Click on the pattern containing the cross in the lower right corner of the sequence number, and select the second filling sequence in the menu.

4. The data of the sequence becomes incremental. Another way is to fill in two or more friendly base data at the beginning of the initial crack, as shown in the figure below, and select two data at the same time to pull down.

5. The result is the same as the previous one.

Enter the following formula.

address(1,1+(row(a1)-1)*10,4) is shown in the attached figure for example.

You can use char() to convert line numbers to letters. Then use the text address function indirect() to turn the letters into cell addresses, reference the data, and finally use sum() to sum.

Copy down <> g4 formula:

sum(indirect("Table.