Forum Discussion
Cell Referencing not Autofilling Correctly
Hello, I'm having some trouble autofilling some referenced cells from another sheet. I would like to have the column letter continue its sequence but I want the row number to stay the same (ex. a11, ...
Hi, as you are filling down the column references do not move! You have fixed row 11 with the dollar symbol, which makes row 11 to stay in the reference as you fill downwards. Column TX is naturally staying in the same column as you fill, because you are filling downwards.
In order to move the reference TX to TU, TV, etc; you should be filling to the right.
I think that you might want a TRANSPOSE function. For instance, =TRANSPOSE(TX11:TW11)