View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default 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