How can you copy a formula down a column in sheets? Not by manually dragging it. Imagine there are 1000 rows. Is there a short cut?

I have dragged the corner of the cell, but that works for a shorter list. Sometimes when I put the formula in the cell Sheets will ask if it can auto-fill, which is great but if you edit that formula - I can't seem to copy the new edit formula down 1000 rows without having to manually drag the corner.

CodePudding user response：

You can try to copy the first row, then press CTRL SHIFT ↓ until the last row and paste it.

CodePudding user response：

example 1:

you enter value/formula into A2 and want to fill down all the way.

1. select cell A2
2. press CTRL SHIFT DOWN ARROW
3. then press CTRL ENTER

example 2:

you enter value/formula into A2 and want to fill down only few cells.

1. select cell A2
2. press SHIFT DOWN ARROW to select desired cells
3. then press CTRL ENTER