Excel 2010 - possible to apply a function to an entire column?

Question

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)?

What *specifically* are you wanting to do? – Adam Jul 29 '15 at 22:31 — Adam, Jul 29 '15 at 22:31

score 2 · Answer 1 · answered Jul 29 '15 at 22:33

2

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!

answered Jul 29 '15 at 22:33

Michael Frank

1 Answers1