Special Edition Using Microsoft® Office XP

Troubleshooting

Resetting the Last Cell

Q1:

I pressed Ctrl+End to go to the last cell in my worksheet, but I ended up with the insertion point in a blank cell below and to the right of the actual end of the sheet. How do I convince Excel to jump to the actual end of the sheet?

A1:

When you select the last cell in a worksheet, either by using the Go To Special dialog box or by pressing Ctrl+End, Excel actually jumps to the last cell that has ever contained data or formatting. As you've seen, that can produce unexpected results, especially if you've deleted a large number of rows or columns (or both) from a list or worksheet model, or if you once placed a range of data in an out-of-the-way location and then moved or deleted it. In that case, selecting ...