Column Forumulas
 

I'm sure this is simple, but i suck with excel. Okay, I want to
mulitply column A by column B and paste the product into column C. For
example, A2 x B2 = C2, but for say, 100 rows without having to do it by
hand.


--
GuitarFingers
------------------------------------------------------------------------
GuitarFingers's Profile: http://www.excelforum.com/member.php...o&userid=34737
View this thread: http://www.excelforum.com/showthread...hreadid=544964

Column Forumulas
 

Select the 100 cells in C, starting at C2

In the formula bar, enter =A2*B2

Use Ctrl-Enter to enter the formula (not just enter)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"GuitarFingers"
wrote in message
news:GuitarFingers.28atrz_1148452203.4625@excelfor um-nospam.com...

I'm sure this is simple, but i suck with excel. Okay, I want to
mulitply column A by column B and paste the product into column C. For
example, A2 x B2 = C2, but for say, 100 rows without having to do it by
hand.


--
GuitarFingers
------------------------------------------------------------------------
GuitarFingers's Profile:
http://www.excelforum.com/member.php...o&userid=34737
View this thread: http://www.excelforum.com/showthread...hreadid=544964