S
S1L1Y1
I have Office XP. In Excel I want to increase the price in the whole column
by lets say 5% how do I do it?
Sol
by lets say 5% how do I do it?
Sol
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernard Liengme
If you want another column with the new values:
Suppose first old value is in A1, then in B1 enter =A1*1.05
Drag this down the column
If you want to alter the original data
In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays
as 105.00%)
Copy this cell
Select the column of data
Use Edit | Paste Special with Multiply specified
Now you can delete the 1.05
best wishes
Suppose first old value is in A1, then in B1 enter =A1*1.05
Drag this down the column
If you want to alter the original data
In an unused cell type 1.05 ( or =1+ 5% and do not worry if this displays
as 105.00%)
Copy this cell
Select the column of data
Use Edit | Paste Special with Multiply specified
Now you can delete the 1.05
best wishes
S
S1L1Y1
For example in row 1 the amount is $10.00 and I want to increase it by 5% to
$10.50, and row 2 the amount is $15.00 I want to increase by 5% to $15.75,
and row 3 the amount is $20.00 and I want to increase by 5% to $21.00, etc.
$10.50, and row 2 the amount is $15.00 I want to increase by 5% to $15.75,
and row 3 the amount is $20.00 and I want to increase by 5% to $21.00, etc.
B
Bernard Liengme
So use either method I gave you
best wishes
best wishes
S
S1L1Y1
Thank You. I am trying to change all rows in column N. How do I do it?
S
S1L1Y1
Thank You. When I go to Paste special I do not find an option Multiply. Also
am trying to change all rows in column N. How do I do it?
Sol
am trying to change all rows in column N. How do I do it?
Sol
G
Gord Dibben
What options do you see under Paste Special?
Multiply will be top right option under "Operation"
First copy the cell with 1.05
Then select the range in column N and Edit>Paste Special>Multiply>OK
Gord Dibben MS Excel MVP
Multiply will be top right option under "Operation"
First copy the cell with 1.05
Then select the range in column N and Edit>Paste Special>Multiply>OK
Gord Dibben MS Excel MVP
S
S1L1Y1
Thanks, It says source and gives a choose paste as Unicode Text, or text.
G
Gord Dibben
From where are you copying?
Same workbook and sheet?
The behaviour you describe is indicative of having two workbooks open in 2
separate instances of Excel and you are copying from one to the other.
Gord
Same workbook and sheet?
The behaviour you describe is indicative of having two workbooks open in 2
separate instances of Excel and you are copying from one to the other.
Gord
S
S1L1Y1
I am working with the same workbook and sheet.
Sol
Sol
S
S1L1Y1
Maybe somebody can explain this one. I went and first pasted the 1.05 in an
other cell and went to column N and did the special paste and it worked.
Sol
other cell and went to column N and did the special paste and it worked.
Sol
G
Gord Dibben
I can't explain it.
I can't even explain why copying 1.05 from a cell then paste special brings
up the incorrect dialog...........text, unicode text.........not the regular
paste special dialog.
Gord
I can't even explain why copying 1.05 from a cell then paste special brings
up the incorrect dialog...........text, unicode text.........not the regular
paste special dialog.
Gord
D
Dave Peterson
(maybe separate instances of excel?)
Gord said:I can't explain it.
I can't even explain why copying 1.05 from a cell then paste special brings
up the incorrect dialog...........text, unicode text.........not the regular
paste special dialog.
Gord
G
Gord Dibben
That was my question to OP.
Answer..........
Gord
(maybe separate instances of excel?)
D
Dave Peterson
I didn't notice that.
If it's true (I'd check again!), then I think I've read posts about an addin
causing this problem.
I'd start excel in safe mode and test it again.
Close excel
windows start button|run
excel /safe
open the file and test again.
This may not be the problem, but if the original poster is using Essbase...
Jim Thomlinson posted this...
Essbase -> Options -> Global -> Uncheck "Enable Secondary Button"
This is a wonderful feature that allows you to pivot your essbase data by
dragging and dropping the members between rows and columns. The problem is
that it takes over your ability to right click.
If it's true (I'd check again!), then I think I've read posts about an addin
causing this problem.
I'd start excel in safe mode and test it again.
Close excel
windows start button|run
excel /safe
open the file and test again.
This may not be the problem, but if the original poster is using Essbase...
Jim Thomlinson posted this...
Essbase -> Options -> Global -> Uncheck "Enable Secondary Button"
This is a wonderful feature that allows you to pivot your essbase data by
dragging and dropping the members between rows and columns. The problem is
that it takes over your ability to right click.
S
S1L1Y1
I had ASAP program but I removed it.
Sol
Sol
Dave Peterson said:I didn't notice that.
If it's true (I'd check again!), then I think I've read posts about an
addin
causing this problem.
I'd start excel in safe mode and test it again.
Close excel
windows start button|run
excel /safe
open the file and test again.
This may not be the problem, but if the original poster is using
Essbase...
Jim Thomlinson posted this...
Essbase -> Options -> Global -> Uncheck "Enable Secondary Button"
This is a wonderful feature that allows you to pivot your essbase data by
dragging and dropping the members between rows and columns. The problem is
that it takes over your ability to right click.
S
S1L1Y1
I forgot to ask if you think because I had ASAP causes the problem if I
removed it how do I fix the problem?
Sol
removed it how do I fix the problem?
Sol
S1L1Y1 said:I had ASAP program but I removed it.
Sol
D
Dave Peterson
I'm pretty sure it wasn't ASAP.
But I don't recall what it was. Do you use Essbase?
But I don't recall what it was. Do you use Essbase?
I forgot to ask if you think because I had ASAP causes the problem if I
removed it how do I fix the problem?
Sol
S
S1L1Y1
I do not use Essbase
Dave Peterson said:I'm pretty sure it wasn't ASAP.
But I don't recall what it was. Do you use Essbase?
D
Dave Peterson
I still don't remember what the offending program was in those other posts.
What happens if you start excel in safe mode?
What happens if you start excel in safe mode?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.