I haven't been using excel as much for quite a while and now suddenly my normal way of writing formulas doesn't seem to work anylonger. I have a habit to refer to cells as the whole row (e.g. 5:5) instead of C:5 (if the formula is in the C column). This in order to make it easy to quickly see that it is the row number that matters - the C is just a redundant piece of information when you try to understand a model built by someone else (or myself a while ago).
However, when I do this now I get either a blank value (if using several references in the same formula) or #SPILL! if I just use one reference of the kind I used to. Is there something that has changed in excel and does this mean I am forced to refer to both the column and the row going forward (this would be quite a large step backward in my opinion)?
Bookmarks