James Perry
Member
A formula repeats itself 26 times in cells A1 thru' Z1 by dragging across
or paste special.
Values are in cells A2 thru' Z2.
Now I lock row 1 in col A with the $ sign.
The formula now reads…......A$1 (instead of A1).
But I would also like the $ sign to 'auto-appear' in the remaining
25 cells, B1 thru Z1.
What Excel formula can do the same....????
or paste special.
Values are in cells A2 thru' Z2.
Now I lock row 1 in col A with the $ sign.
The formula now reads…......A$1 (instead of A1).
But I would also like the $ sign to 'auto-appear' in the remaining
25 cells, B1 thru Z1.
What Excel formula can do the same....????
Last edited: