View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
GANESH GANESH is offline
external usenet poster
 
Posts: 10
Default How to multiply column and rows



"Gord Dibben" wrote:

In C1 enter =A1*B1

Double-click the fill handle of C1 to copy the formula down column C

BTW...........a "desire box" is called a "cell"


Gord Dibben MS Excel MVP


On Sat, 23 Aug 2008 11:12:00 -0700, Ganesh
wrote:

Hello friends i know how to multiply a single row or column
that if i want that Multiply A1 and A2 then i write in my desire box
"=A1*A2" thats it.

But the problem is this that i want to multiply all data of the A row with B
row and want to show in C how i can.



Still i m not able to do this i double click on C1 then what i have to do,
to multiply all tha A and B row