Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change all of the cells in a row(s) by a percentage
I need to change several different rows some are side by side and some not. I
have tried several different things but nothing seems to work. Our yearly budget has been move to me and now I need to make several changes, some rows will go up by percentages and some row down by percentages. I don't want to have to phyically change every cell is there some way I can select a row or rows and increase the amount by a given percentage. I would apprciate any help I could get. Thanks Danny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change all of the cells in a row(s) by a percentage
Hi,
Put the % you want to multiply by in a cell e.g. 1.05 for 5% and copy that cell Select your row and then Edit|Paste special Select Multiply OK Mike "tankerman" wrote: I need to change several different rows some are side by side and some not. I have tried several different things but nothing seems to work. Our yearly budget has been move to me and now I need to make several changes, some rows will go up by percentages and some row down by percentages. I don't want to have to phyically change every cell is there some way I can select a row or rows and increase the amount by a given percentage. I would apprciate any help I could get. Thanks Danny |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change all of the cells in a row(s) by a percentage
Suppose you want to increase a few cells by 5% (which is 1.05), then
put 1.05 in an empty cell somewhere, and <copy that cell. Then highlight the cells that you want to change (if they are not contiguous then you can hold down the CTRL key while you select them), then Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. Then you can delete the 1.05 from the original cell. If you want to decrease by 5% then you should start with 0.95 in the cell. Hope this helps. Pete On Aug 28, 7:19*pm, tankerman wrote: I need to change several different rows some are side by side and some not. I have tried several different things but nothing seems to work. Our yearly budget has been move to me and now I need to make several changes, some rows will go up by percentages and some row down by percentages. I don't want to have to phyically change every cell is there some way I can select a row or rows and increase the amount by a given percentage. I would apprciate any help I could get. Thanks Danny |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change all of the cells in a row(s) by a percentage
Thanks to all who responded the answer worked great
Thanks again Danny "Pete_UK" wrote: Suppose you want to increase a few cells by 5% (which is 1.05), then put 1.05 in an empty cell somewhere, and <copy that cell. Then highlight the cells that you want to change (if they are not contiguous then you can hold down the CTRL key while you select them), then Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. Then you can delete the 1.05 from the original cell. If you want to decrease by 5% then you should start with 0.95 in the cell. Hope this helps. Pete On Aug 28, 7:19 pm, tankerman wrote: I need to change several different rows some are side by side and some not. I have tried several different things but nothing seems to work. Our yearly budget has been move to me and now I need to make several changes, some rows will go up by percentages and some row down by percentages. I don't want to have to phyically change every cell is there some way I can select a row or rows and increase the amount by a given percentage. I would apprciate any help I could get. Thanks Danny |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change all of the cells in a row(s) by a percentage
Glad to hear that, Danny - thanks for feeding back.
Pete On Aug 28, 8:03*pm, tankerman wrote: Thanks to all who responded the answer worked great Thanks again Danny "Pete_UK" wrote: Suppose you want to increase a few cells by 5% (which is 1.05), then put 1.05 in an empty cell somewhere, and <copy that cell. Then highlight the cells that you want to change (if they are not contiguous then you can hold down the CTRL key while you select them), then Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. Then you can delete the 1.05 from the original cell. If you want to decrease by 5% then you should start with 0.95 in the cell. Hope this helps. Pete On Aug 28, 7:19 pm, tankerman wrote: I need to change several different rows some are side by side and some not. I have tried several different things but nothing seems to work. Our yearly budget has been move to me and now I need to make several changes, some rows will go up by percentages and some row down by percentages. I don't want to have to phyically change every cell is there some way I can select a row or rows and increase the amount by a given percentage. I would apprciate any help I could get. Thanks Danny- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change percentage symbol (Excel XP) | Excel Discussion (Misc queries) | |||
What formula do I use to find a percentage change? | Excel Discussion (Misc queries) | |||
Need formula to figure out percentage of change for 5 years | Excel Discussion (Misc queries) | |||
Change the way a non-computed percentage is displayed | Excel Discussion (Misc queries) | |||
How do I change percentage function to less than a hundredth? | New Users to Excel |