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

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" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> 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
>