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 the numbers in the column to the right. Is there a way to set up the columns to fill only to the level of those numbers listed to the left of the column? I'm doing a worksheet that lists different types of wood, the board feet and the cost per foot. I then want to calculate what that wood will cost. I don't want to autofill to the level of cells with the formula, but just to the level of cells with the type and board ft. When I double click the autofill handle in the first cell of the third column, I only want it to fill to the point where the first two columns end. I've attached a file to help explain since I don't know if I'm making much sense.
5 Replies
Yes, former time it worked differently. But there were issues with blank cells in the middle of adjacent column. After the the improvement, or now if you don't consider that as improvement, fill handle works till last not blank cell in both adjacent columns, like this
To my knowledge there is no way to change such behaviour. Workaround could be (as in your sample if you stay on the first cell of third column)
Left
Ctrl+Down
Right
Ctrl+Shift+Up
Ctrl+D
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)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)
