How can I increase the cell data in several columns by 15%
thanks chaps
"Danny@Kendal" wrote:
The cells don't have to be adjacent or even on the same sheet.
Unless you are using every possible column in Excel then you can insert one
column, copy and "paste special" the values then delete the inserted column
which leaves things just as they were.
Alternatively, type in 1.15 in any spare cell. Select that cell and choose
"copy".
Now select all the values you want to increase by 15%, choose "paste
special" and select the "multiply" option.
HTH
p.s. I'm only top-posting because that's the way this thread is going.
"Sian" wrote in message
...
Thanks, unfortunately that doesn't work as the columns that I need to
change
are all next to each other, in the middle of a large spreadsheet full of
different data, and there aren't any adjacent cells that are free.
"Philip Reece-Heal" wrote:
If the value to be increased was in A1, use a formula in an adjacent
column:- =A1*1.15 and copy that formula down for all cells that you need
Regards
Philip
"Sian" wrote in message
...
I have been given a worksheet in which all the figures in 12 columns
need
to
be increased by 15% and can't figure out what the correct formula would
be -
any help much appreciated!
|