Forum Discussion
Fill Series with varying data
Is there anyway to fill a series when the data varies in column, I have to drag each value down and copy/fill, I would love it if there was a way to copy the series down, for example. Grab all the c...
Select the column.
Press F5 or Ctrl+G to activate the Go To dialog.
Select Special...
Select Blanks.
Click OK.
Note the address of the active cell in the selection. You should see this on the left hand side of the formula bar.
Let's say it is G7 (just as an example).
Enter the formula =G6 (referring to the cell above the active cell).
Confirm the formula by pressing Ctrl+Enter.