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

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


--
MageeStringer
------------------------------------------------------------------------
MageeStringer's Profile: http://www.excelforum.com/member.php...o&userid=33298
View this thread: http://www.excelforum.com/showthread...hreadid=531742

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


On 4/10/06 6:49 PM, in article
, "Ed"
wrote:

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

Use an array perhaps, such as

=SUM(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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

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?

"MageeStringer" wrote:


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


--
MageeStringer
------------------------------------------------------------------------
MageeStringer's Profile: http://www.excelforum.com/member.php...o&userid=33298
View this thread: http://www.excelforum.com/showthread...hreadid=531742