In Excel 2010, is it possible to apply a function (not a formula) to an entire column (without dragging the plus symbol all the way to the bottom)?
1 Answer
A function is part of a formula. So the below should work in exactly the same way.
Select the column you want:
Paste your formula:
Then hit Ctrl + Enter.
Done!