excel how to paste formula from column to row -
i want copy column formula row 1 :
b c d
1 ='sheet1'!b2.......='sheet1'!b3............='sheet1'!b4............='sheet1'!b5
2 ='sheet1'!b3
3 ='sheet1'!b4
4 ='sheet1'!b5
5 ='sheet1'!b6
but when copy formula column b, cell(b1) become ='sheet1'!c3, there way transpose formula without change 1 one?
when right-click (to paste copied selection), comes paste special
option. click , select transpose
. should you. , changing b3 (in formula) $b3 should stop changing formula
Comments
Post a Comment