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, b11, c11, etc.). I have inserted a $ symbol before the number so it stays the same, but the letter doesn’t continue its sequence even without the $ symbol in front of it. Here are a couple of screen shots to hopefully help with this problem:
Here is what my formula looks like before I drag it down to autofill it.
Here is what it looks like after I drag it down:
The formula just stays the same for each cell. The letter doesn’t change and the number stays the same (=TPT!TX$11). I would like it to continue like this: (=TPT!TU$11, =TPT!TV$11, =TPT!TW$11, etc.). I can manually change each cell, but it can be very tedious. Any help with this would be greatly appreciated. Thanks!
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, b11, c11, etc.). I have inserted a $ symbol before the number so it stays the same, but the letter doesn’t continue its sequence even without the $ symbol in front of it. Here are a couple of screen shots to hopefully help with this problem: Here is what my formula looks like before I drag it down to autofill it. Here is what it looks like after I drag it down:The formula just stays the same for each cell. The letter doesn’t change and the number stays the same (=TPT!TX$11). I would like it to continue like this: (=TPT!TU$11, =TPT!TV$11, =TPT!TW$11, etc.). I can manually change each cell, but it can be very tedious. Any help with this would be greatly appreciated. Thanks! Read More