| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying formulas with changing cells
Hi,
highlight the column where you have the formulas, hit CTRL H, find what R, replace with enter C "KenJ" wrote: Hi, I'm using Microsoft Office 2003. I have formulas in a particular column, but now I need to change from one column to another with out changing the formula. e.g =R20/12 now needs to be =C20/12. how do I do this without having to do each one separately? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying formulas with changing cells
Thanks Eduardo!!!
"Eduardo" wrote: Hi, highlight the column where you have the formulas, hit CTRL H, find what R, replace with enter C "KenJ" wrote: Hi, I'm using Microsoft Office 2003. I have formulas in a particular column, but now I need to change from one column to another with out changing the formula. e.g =R20/12 now needs to be =C20/12. how do I do this without having to do each one separately? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adjusting formulas by copying across cells w/o changing the refere | Excel Worksheet Functions | |||
| Copying formulas without changing the range | Excel Discussion (Misc queries) | |||
| copying formulas and changing cell references | Excel Discussion (Misc queries) | |||
| copying formulas but changing the column # | Excel Discussion (Misc queries) | |||
| Copying formulas without changing previous results/calculations | Excel Worksheet Functions | |||
Linear Mode
