Transposing formulas in Excel
Posted: 2009-11-13, 23:53If like me you have ever been frustrated by that the paste transpose function in Excel messing up your formulas, don't panic. I found this useful tip on the internet for getting around the problem.
Using the =TRANSPOSE formula rather than the paste transpose command keeps all your references relative to where you want them... This will save a lot of stress!
Using the =TRANSPOSE formula rather than the paste transpose command keeps all your references relative to where you want them... This will save a lot of stress!