When I use Ctrl-Down Arrow in Excel 2013 (as described in Go to last line with data, Excel 2007) I am taken well past the last line of data (about 1700 rows) all the way to row 1048576 - why might this be happening and what can I do to stop it so that Ctrl-Down Arrow works as expected?
Asked
Active
Viewed 1.4k times
1
Kendall Lister
- 493
1 Answers
3
If all cells below the current cell in the current column are blank, Ctrl-down arrow will take you to the last row of the spreadsheet. To get to the last row of content in that column, you can then use Ctrl-up arrow.
teylyn
- 23,615