Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default how to multiply entire colume?

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.

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default how to multiply entire colume?

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, EditPaste SpecialMultiplyOKEsc

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

On Sun, 13 Jan 2008 09:30:13 -0800, "Andrea Gates" wrote:

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.


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how to multiply entire colume?

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andrea Gates" wrote in message
...
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.


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how to multiply entire colume?

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?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
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.
--
HTH,

RD

--------------------------------------------------------------------------

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

-
"Andrea Gates" wrote in message
...
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.



  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 284
Default how to multiply entire colume?

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

"Andrea Gates" wrote:

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.




  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,202
Default how to multiply entire colume?

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


"Ragdyer" wrote in message
...
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?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" wrote in message
...
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.
--
HTH,

RD

--------------------------------------------------------------------------

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

-
"Andrea Gates" wrote in message
...
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.




  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how to multiply entire colume?

It appears that you didn't read my first post in it's entirety!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rick Rothstein (MVP - VB)" wrote in
message ...
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


"Ragdyer" wrote in message
...
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?
--
HTH,

RD


--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-
"Ragdyer" wrote in message
...
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.
--
HTH,

RD


-------------------------------------------------------------------------

-
-
Please keep all correspondence within the NewsGroup, so all may benefit

!

-------------------------------------------------------------------------

-
-
"Andrea Gates" wrote in message
...
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.





  #8   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,202
Default how to multiply entire colume?

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


"Ragdyer" wrote in message
...
It appears that you didn't read my first post in it's entirety!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rick Rothstein (MVP - VB)" wrote in
message ...
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


"Ragdyer" wrote in message
...
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?
--
HTH,

RD


--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-
"Ragdyer" wrote in message
...
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.
--
HTH,

RD


-------------------------------------------------------------------------

-
-
Please keep all correspondence within the NewsGroup, so all may
benefit

!

-------------------------------------------------------------------------

-
-
"Andrea Gates" wrote in message
...
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.






  #9   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how to multiply entire colume?

Your reinforcement is greatly appreciated!<bg
--

Regards,

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

"Rick Rothstein (MVP - VB)" wrote in
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


"Ragdyer" wrote in message
...
It appears that you didn't read my first post in it's entirety!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rick Rothstein (MVP - VB)" wrote in
message ...
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


"Ragdyer" wrote in message
...
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?
--
HTH,

RD


--------------------------------------------------------------------------

-
Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-
"Ragdyer" wrote in message
...
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.
--
HTH,

RD


-------------------------------------------------------------------------

-
-
Please keep all correspondence within the NewsGroup, so all may
benefit

!

-------------------------------------------------------------------------

-
-
"Andrea Gates" wrote in message
...
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.







  #10   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default how to multiply entire colume?


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




  #11   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how to multiply entire colume?

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andrea Gates" wrote in message
...

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




  #12   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default how to multiply entire colume?

"RagDyer" wrote in message
...
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.
--
HTH,


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.

  #13   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,651
Default how to multiply entire colume?

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.
--
David Biddulph

"Andrea Gates" wrote in message
...

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.


"RagDyer" wrote in message
...
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.



  #14   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default how to multiply entire colume?

RD, Thank you.


"RagDyer" wrote in message
...
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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andrea Gates" wrote in message
...

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





  #15   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,572
Default how to multiply entire colume?

You're welcome, and thank you for the feed-back.
--

Regards,

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

"Andrea Gates" wrote in message
...
RD, Thank you.


"RagDyer" wrote in message
...
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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Andrea Gates" wrote in message
...

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colume Headings Gu y Excel Worksheet Functions 1 November 30th 07 01:40 PM
3 COLUME CHART BANDIT Excel Worksheet Functions 0 March 21st 06 08:17 PM
how do i multiply entire columns of numbers by a % stgaw53 Excel Discussion (Misc queries) 1 October 26th 05 06:47 PM
how do I divide or multiply an entire column? 1number Excel Worksheet Functions 4 March 5th 05 09:48 PM
How can I look up max of one colume and display the colume to the. Brian Cornejo Excel Worksheet Functions 2 February 21st 05 06:47 AM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"