I have looked at the different solutions but none work or they are not applicable. This happened in the middle of an Excel session. I can use Ctrl-Shift+Arrow to select but this does not work in a formula.
Example I have a range of data from B2:B14 in C2 I type =sum( then position the cursor on B2 and hit Ctrl-Shift-ArrowDown. Normally this results in C2 = sum(B2:B14) instead I get sum(B2) and the array from C2 all the way to last cell in column C2 are selected.
Scroll lock is not on, Lotus compatibility is off, executed Office repair. Nothing helps.
Any suggestions most welcome