Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Relative references in arrays
Can anyone answer a question: why is it that if I select a range, type a
formula which contains a relative reference, then hit ctrl+enter, the reference contained in each cell will indeed vary according to its position in the range. However, if I hit ctrl+shift+enter, to enter an array, all cells will contain the same literal reference I typed in. What is the rationale here? Perhaps it would help me understand a bit more about arrays. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative, absolute & mixed references in many cells | Excel Worksheet Functions | |||
Named formulas in CHOOSE need to be Relative references when paste | Excel Worksheet Functions | |||
I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
Confused about relative references in named formulas | Excel Worksheet Functions | |||
Averaging using relative references across sheets | Excel Discussion (Misc queries) |