|
Posted to microsoft.public.excel.misc
|
|
|
How can I increase the cell data in several columns by 15%
thanks chaps
"broro183" wrote:
Hi Sian,
This is a useful method which I have just read about in the past
month...
Type 1.15 in a blank cell (can be in another workbook), [enter], select
& copy the cell (or [ctrl+c]), select the range that you want to be
increased by 15%, edit - paste special - multiply - [enter] (or
[alt+e+s+m] [enter]).
This works on values or formulae, try it on a copy of your file first.
Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...
--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=507575
|