| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Changing multiple cells by the same percentage
I have to make a price change, it involves approx. 50 different cells. They
will all increase by 9.25%. Is there a function or a formula that I can use to change the cells all at once without having to go through and change each individually? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Changing multiple cells by the same percentage
Hi
In an unused cell enter 1.0925 then copy the cell. Select the price cells, then goto Edit Paste Special Select Multiply OK Regards, Per "slindsay" skrev i meddelelsen ... I have to make a price change, it involves approx. 50 different cells. They will all increase by 9.25%. Is there a function or a formula that I can use to change the cells all at once without having to go through and change each individually? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Changing multiple cells by the same percentage
Here's a short video that demonstrates this:
http://www.contextures.com/xlVideos03.html#Paste2003 -- Biff Microsoft Excel MVP "slindsay" wrote in message ... I have to make a price change, it involves approx. 50 different cells. They will all increase by 9.25%. Is there a function or a formula that I can use to change the cells all at once without having to go through and change each individually? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing text in multiple cells by pattern | Excel Discussion (Misc queries) | |||
| changing a formula in multiple cells | Excel Worksheet Functions | |||
| Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
| help me is it possible to add to multiple cells without changing t | Excel Worksheet Functions | |||
| changing cells in multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
