Excel Functions

[Ed]

How do you set a function for the complete coluum in Excel sheet without
having to go to each individual line?

 

[MageeStringer]

you would probably need a VBA code, what do you want this function to
do?

 

[Dan]

On a Mac it involves entering a formula with appleCmnd-return, on a PC, it
is (I am guessing) wndCmnd-return...

The xls help section is complete on this. Search "array functions"

Dan

 

[Bob Phillips]

Use an array perhaps, such as

=SUM(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Ed]

I want to take the number in one coluum and multiply it by a number in
another coluum and I want this functionl the same in each row on the spread
sheet without having to go to each row and set up the function. Is there a
way to set the two coluums up at the top for the complete spread sheet
without setting up each row individually?