| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Keep cell reference when moving range (matter of urgency)
I have the following problem:
In the range C1:C20 i have some data. I the range A1:A20 i have this "formula": In A10: =C10, in A11: =C11, and so on. The problem is: I want to have the ability to cut for example the range C17:C20 and paste it in the range C11:C14, WITHOUT changing the formulas in the range A1:A20. That means, I do still want the formula in A11 to be =C11 (and not =#REF). Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep my cell reference from moving even when I use the $. | Excel Worksheet Functions | |||
| Moving left of a cell reference | Excel Worksheet Functions | |||
| Moving left of a cell reference | Excel Worksheet Functions | |||
| Cell Reference with Range Name | Excel Worksheet Functions | |||
| Moving Cell Reference after Sorting | New Users to Excel | |||
Threaded Mode
