Forum Discussion
Auto Fill columns based on filled cells to the left
Older versions of Excel would let me fill a column to the row level with the data left of that row. Now when I double click the autofill handle in the first cell, it fills all the way down to match t...
The numbers in column 3 are still filling to match the cells in column D. I want them to only go down as far as column B, but I still want to have the formula in column D down to the bottom of the page. I know that if I put the formula in column D only to the rows filled in columns A - C it works, but I want to be able to have the formula fill to the bottom of the column without the price auto-filling to that same row.
According to the translation it should be like this ... if not please report again and if possible show more specifically with the worksheet ... since my english is not the best.
thank you
Nikolino
I know I don't know anything (Socrates)
Nikolino
I know I don't know anything (Socrates)
- in cell D1 write:
=IF(B1<>"",B1*C1,"")
then autofill
