| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell References
I have a formula with a long string of cell references - ("AVERAGE" this long
string of cell references"). I want to copy the cell references one column space to the right and instruct it to use the same set of references, only one column space to the right of each original cell reference. For example, series B3,G3,L3, etc. would become series C3, H3, M3, etc. The OFFSET function in help is similiar but not the same as what I want to do here. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell References
hi
change your cell references from reletive to absolute ie from A1 to $A$1. this way they will keep the origional reference. Regards FSt1 "DOUG ECKERT" wrote: I have a formula with a long string of cell references - ("AVERAGE" this long string of cell references"). I want to copy the cell references one column space to the right and instruct it to use the same set of references, only one column space to the right of each original cell reference. For example, series B3,G3,L3, etc. would become series C3, H3, M3, etc. The OFFSET function in help is similiar but not the same as what I want to do here. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Displaying multiple cell references in 1 cell | Excel Discussion (Misc queries) | |||
| How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
| Changing Cell References To a Different Worksheet in the Same Cell | Excel Worksheet Functions | |||
| Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) | |||
Linear Mode
