Column Forumulas

  • Thread starter Thread starter GuitarFingers
  • Start date Start date
G

GuitarFingers

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.
 
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" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top