how to multiply entire colume?

  • Thread starter Thread starter Andrea Gates
  • Start date Start date
A

Andrea Gates

How to multiply entire colume with constant:

For example I have colume A


21
26
28
33
77


I wish to multiple all of colume A with 7 and put product result in colume B

21 147
26 182
28 196
33 231
77 539

how do I insert single formula vulue in colume B at one time during edit?
(by selecting all the cells in colume B)?

Thank you.
 
You can do it in place by entering 7 in an unused cell.

Copy that cell.

Select the range in column A and, in place, Edit>Paste Special>Multiply>OK>Esc

If you want to keep column A just copy it to column B then do the above on
column B

OR enter 7 in C1

In B1 enter =A1*C1 then double-click on the fill handle of B1 and it will copy
down.


Gord Dibben MS Excel MVP
 
Say your numbers start in A1.
In B1, enter this formula:

=A1*7

Click back in B1 to select it.
Hover your cursor over the lower right corner of B1, where you see a tiny
black square.
When the cursor changes from a fat white cross to a skinny black cross,
click and drag down Column B as far as needed.

XL will *automatically* change the cell reference in the formula to match
the row that the formula is in.

If you have no blank rows in Column A between your numbers, you can have XL
*automatically* copy the formula down Column B, as far as there are numbers
in Column A, by *double clicking* on that tiny black square when the cursor
changes to the skinny black cross.
 
In re-reading your post, here's the procedure that I believe you alluded to:

Click in B1 and drag down to select as many rows as you need.

With B1 the cell in focus (colored white), type in this formula:
=A1*7

THEN, hold down <Ctrl> and hit <Enter>.

This will fill all the selected cells in Column B with the formula.

Is that what you were after?
 
Andrea

Another approach: In C1 place the number 7, In B1 enter =A1:A5*$C$1. Then
do what Ragdyer suggested to move the formula to the bottom of you data. if
it has no blanks method work really fast! The nice part about this set up is
if you need to change the multiplier (7) to a different number you can do so
without changing anything else.

Mike Rogers
 
Or, alternately, do the first part of what you said in your first post (put
=A1*7 in B1; click back in B1 to select it) and then simply double-click
that little black square.

Rick
 
So, then, you are saying one of the key things to do when reading newsgroup
messages is to use the scroll bar too?<g>

I could say, "Sorry for having missed that in your message", but let's just
say I was reinforcing your point instead, okay?<vbg>

Rick
 
Your reinforcement is greatly appreciated!<bg>
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

message So, then, you are saying one of the key things to do when reading newsgroup
messages is to use the scroll bar too?<g>

I could say, "Sorry for having missed that in your message", but let's just
say I was reinforcing your point instead, okay?<vbg>

Rick
 
Actually this is what I am after:

Column A (qty) Column B (unit Price) Column C (total price)

21 7 147
26 7 182
28 8 224
33 8 264
77 10 770

Colume A and B are known. Column C is variable.
Is there anyway to insert one simple same formula into all the cells in
column C. Also, how to insert one formula into all the cells in column C?
Can we avoid cell specific, such as using A1, becuase the cell name will
change after sorted and moved into both different column and row of
department master account?

Thank you for you'all
 
The formula simply now becomes:

=A1*B1

Follow any one of the numerous procedures in the above posts to copy it down
Column C.

As far as moving and sorting:
You might try copying, and then use "Paste Special" - "Values",
so that only the data is duplicated in those other locations.

That way you could sort however you wished.
 
RagDyer said:
The formula simply now becomes:

=A1*B1

Follow any one of the numerous procedures in the above posts to copy it
down Column C.

As far as moving and sorting:
You might try copying, and then use "Paste Special" - "Values",
so that only the data is duplicated in those other locations.

That way you could sort however you wished.
Click to expand...

What you show is typing each cell in Column C with this formula.
I specically do not want cell specific formula.
I seek a general purpose formula for paste into all cells in column C.
 
Read again what RD said. You don't need to type separately in each cell in
column C. If you read back through the thread you will see descriptions of
numerous different easy ways of copying down the column.
 
RD, Thank you.


RagDyer said:
The formula simply now becomes:

=A1*B1

Follow any one of the numerous procedures in the above posts to copy it
down Column C.

As far as moving and sorting:
You might try copying, and then use "Paste Special" - "Values",
so that only the data is duplicated in those other locations.

That way you could sort however you wished.
Click to expand...
 
Back
Top