Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colume Headings | Excel Worksheet Functions | |||
3 COLUME CHART | Excel Worksheet Functions | |||
how do i multiply entire columns of numbers by a % | Excel Discussion (Misc queries) | |||
how do I divide or multiply an entire column? | Excel Worksheet Functions | |||
How can I look up max of one colume and display the colume to the. | Excel Worksheet Functions |