Forum Discussion
Excel will not autofill horizontally (using an absolute reference for a column on a dif sheet)
Hey guys, So i've been trying to figure this out for awhile now. I am trying to drag my excel formula to the right. My formula is =+'Hard cost Schd'!$E4*.86. When I drag it horizontally, it s...
Use the transpose formula for your working:
https://support.office.com/en-us/article/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027
It does need using the array function, read a bit about it before actioning:
https://support.office.com/en-us/article/create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d?redirectSourcePath=%252fen-us%252farticle%252farray-formulas-c4fdebf4-f41b-4438-8b8d-ca511d66e44c&ui=en-US&rs=en-US&ad=US
https://support.office.com/en-us/article/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027
It does need using the array function, read a bit about it before actioning:
https://support.office.com/en-us/article/create-an-array-formula-e43e12e0-afc6-4a12-bc7f-48361075954d?redirectSourcePath=%252fen-us%252farticle%252farray-formulas-c4fdebf4-f41b-4438-8b8d-ca511d66e44c&ui=en-US&rs=en-US&ad=US