| Home |
| Search |
| Today's Posts |
|
#7
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup for data contained in a cell | Excel Worksheet Functions | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
| Hide Cell Content if no data in previous columns | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
