I have many rows of data, of varying length. Say row 10 has 50 columns of data, and the most eny line has is 100.
When I am in row 10 and do End+Right Arrow, I want to go to the 50th column, but it's taking me to the 100th. It doesn't work like this when I want to go down--it stops at a blank line. I need to get to the last non-blank entry but I'm getting way past that. The skipped lines are in fact blank, not filled with a space or anything. What gives? Do I have some setting messed up? I've used Excel for decades, and I've never encountered this before.