Excel 2010 - possible to apply a function to an entire column?
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)?
Solution 1:
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!