By Allen Wyatt for Excel.Tips.Net
Jumping to the Real Last Microsoft Excel Cell
Diane wrote about a problem she was having with a file imported into Excel. The file, created by a non-Excel program, contains 50,000 records, but only the first 87 records contain any data. When the file is imported, pressing Ctrl+End moves to cell J50000 instead of cell J87. Diane was wondering how to make Excel jump to the end of the real data—J87.
The first thing to try is to simply save your workbook, get out of Excel, and then reopen the workbook. Doing so “resets” the end-of-data pointer in the workbook, and you should be fine.
If that doesn’t solve the problem, then it is very likely that the data you imported into Excel included non-printing characters, such as spaces. If these are loaded into cells, Excel sees them as data, even though you don’t. To fix the workbook by deleting the data, select row 88 (the one right after your data) and then hold down the Shift and Ctrl keys as you press the Down Arrow. All the rows from 88 through the last row in th worksheet should be selected. Press the Delete key, save the workbook, and reopen it. Ctrl+End should work fine.
This post appears with permission from Allen Wyatt and Excel.Tips.Net.