Forum Discussion

excel_user_1720170's avatar
excel_user_1720170
Copper Contributor
Jul 31, 2020

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...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Jul 31, 2020

excel_user_1720170 

 

Quickly, I hope I got it right through the translation.
Please open the inserted worksheet.


If you liked my solution, please mark it as the correct answer ... if possible with a like (Thumbs up 🙂

so that everyone else can be informed. If you didn't like my answer, please give me a quick feedback.


Thank you
Nikolino
I know I don't know anything (Socrates)

  • excel_user_1720170's avatar
    excel_user_1720170
    Copper Contributor
    Jul 31, 2020

    NikolinoDE  

    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.

    • NikolinoDE's avatar
      NikolinoDE
      Gold Contributor
      Jul 31, 2020

      excel_user_1720170 

       

      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)
      • Ramiz_Assaf's avatar
        Ramiz_Assaf
        Iron Contributor
        Jul 31, 2020
        in cell D1 write:
        =IF(B1<>"",B1*C1,"")
        then autofill

Resources