Transposing Absolute References
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums, but the sums should row sums from above. I could turn all the sums into absolute references first, but that is tedious. Somehow, I would like to highlight multiple cells and ask Excel to turn them all into absolutely references at the same time. Can this be done?
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums, but the sums should row sums from above. I could turn all the sums into absolute references first, but that is tedious. Somehow, I would like to highlight multiple cells and ask Excel to turn them all into absolutely references at the same time. Can this be done? Read More