Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How do I increase a whole column of figures by the same percentage. The only
way I know is to multiply the first figure by what I want and copy and paste the rest of the way down. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assume you want to increase all the numbers by 10%. Enter 1.1 in a blank
cell. Copy it. Then select the entire range in question. Select Paste Special--Multiply and click OK. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "jonilyn" wrote: How do I increase a whole column of figures by the same percentage. The only way I know is to multiply the first figure by what I want and copy and paste the rest of the way down. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way ..
Suppose you want to increase by 10%. Enter 1.1 in any empty cell. Copy the cell. Then right-click on the col of numbers, choose Paste Special Mulitply OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jonilyn" wrote: How do I increase a whole column of figures by the same percentage. The only way I know is to multiply the first figure by what I want and copy and paste the rest of the way down. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you - I knew there must be an easy way. I'll need to run the numbers
using different percentages so this will work great. Thanks again! "jonilyn" wrote: How do I increase a whole column of figures by the same percentage. The only way I know is to multiply the first figure by what I want and copy and paste the rest of the way down. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to increase the value of a whole column of cells by a percentage? | Excel Discussion (Misc queries) | |||
How to increase the value of a whole column of cells by a percentage? | Excel Discussion (Misc queries) | |||
How do I increase a column of numbers by a percentage-same cell | Excel Discussion (Misc queries) | |||
Can I increase an entire column by a percentage? | Excel Discussion (Misc queries) | |||
increase all values in a column by a percentage | Excel Worksheet Functions |