What is the simplest way to enter a sequence of values such as =SUM
(A1:A100),=SUM (B1:B100),=SUM (C1:C100), etc. into a COLUMN?
What is the simplest way of converting simultaneously such values to
($a$1:$a$100) etc.?
I could only find a slow and clumsy method by putting the formula in a row,
right dragging, then using F4 on each individual cell before using paste
special with transpose.
Roger PB
Bookmarks