applying a function to an entire column

[Guest]

i would like for a function to be applied to the entire column how would i do that?

 

[Jens Thiel]

i would like for a function to be applied to the entire column how would i

do that?

e.g. FUNC(A:A) -- add-in worksheet functions with entire columns are buggy
though.

Jens.

 

[Dave Peterson]

I read your question as:

I want to apply a function to each cell in the entire column.

If that's true, just insert a nice helper column to the left of the original and
type your formula in row 1.

Then drag that formula down to the bottom of the other column (probably not to
row 65536--just to the bottom of your data).

You could even copy that column and then Paste|Special|Values right over the
original column.

And delete the helper column.

 

[Anders S]

Patrick,

- select the range or column where you want the formula entered
- enter the formula in the formula bar
- press Ctrl+Enter

Don't enter the formula in the entire column - 65,000+ rows - if you don't have to, it will make your file unnecessary large.

HTH
Anders Silven