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
    What specifically are you wanting to do? – Adam Jul 29 '15 at 22:31

A function is part of a formula. So the below should work in exactly the same way.

Select the column you want:

Select Column

Paste your formula:

enter image description here

Then hit Ctrl + Enter.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.