Hi guys,
I have just come across something I have not quite seen before.
I am working with an Excel workbook, and the Ctrl + arrow key function is not working as I would expect. When used it goes the furthest populated cell rather than the next populated cell. So when I am in cell B1 and expect to go to cell B15 when I use Ctrl + down, it ends up in cell B15000, which is the last cell with a value in it.
Now I know that the data is pasted into the Excel sheet from another -non Microsoft- programme. I have tried copying all the data and then using paste-special-values, which worked with similar problems, but that doesn't do anything.
It's not like the data is just one big block that looks like it takes up the whole thing, because it will still sort according to columns. The Find function also works, which suggests it does recognise values in cells. And yet the Ctrl + arrow keys don't work.
Does anybody have any idea what might be going on here? Any suggestions would be most welcome.
Bookmarks