E
Eagledove
I would appreciate help on this matter otherwise i have to do it manually.
cheers
Michelle
cheers
Michelle
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.
G
Gary Keramidas
one way
With Columns("A")
.ColumnWidth = .ColumnWidth * 0.9
End With
With Columns("A")
.ColumnWidth = .ColumnWidth * 0.9
End With
I
imageswords.br
Hi there,
do you mean the column width or the values in the column?
If its the former, then Gary's post is what you need.
Otherwise there are a number of ways...
You could use an array formula like this:
1 - Select the cells you want to decrease by 10%.
2 - Copy and paste to an unused section of the work book - Leave the
cells selected once you have pasted!!!
3 - Enter and = sign in the active cell and then select the cells you
want to decrease by 10% AGAIN. You should now have something like
=A1:A30 in your Activecell. Now enter * 0.9 so you have =A1:A30 * 0.9
in the active cell.
4 - Now is the magic bit! Hold down Ctrl + Shift then press Enter. All
your figures are pasted into the unused section.
5 - Copy these value and then Edit>Paste Special>Values over the
original values.
Kind regards
Bernie Russell
do you mean the column width or the values in the column?
If its the former, then Gary's post is what you need.
Otherwise there are a number of ways...
You could use an array formula like this:
1 - Select the cells you want to decrease by 10%.
2 - Copy and paste to an unused section of the work book - Leave the
cells selected once you have pasted!!!
3 - Enter and = sign in the active cell and then select the cells you
want to decrease by 10% AGAIN. You should now have something like
=A1:A30 in your Activecell. Now enter * 0.9 so you have =A1:A30 * 0.9
in the active cell.
4 - Now is the magic bit! Hold down Ctrl + Shift then press Enter. All
your figures are pasted into the unused section.
5 - Copy these value and then Edit>Paste Special>Values over the
original values.
Kind regards
Bernie Russell
G
Gary Keramidas
i didn't understand what they wanted. yours is probably what they wanted.
M
muddan madhu
suppose u have data
A1 B1
100 =A1*10/100
drag it down.
then copy the values in B1 , select A1 then Go to Edit | pastespecial
| values | subtract | ok
A1 B1
100 =A1*10/100
drag it down.
then copy the values in B1 , select A1 then Go to Edit | pastespecial
| values | subtract | ok
G
Gord Dibben
Type .9 in an unused cell.
Copy that cell.
Select the range to change and Edit>Paste Special>Multiply>OK>Esc
Gord Dibben MS Excel MVP
Copy that cell.
Select the range to change and Edit>Paste Special>Multiply>OK>Esc
Gord Dibben MS Excel MVP