• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 24. Excel Essentials > Troubleshooting

Troubleshooting

Resetting the Last Cell

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?

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 the Last Cell option might position the insertion point in a cell that's far beyond the actual end of the sheet. To reset the sheet so that you can truly jump to the last cell, delete all rows that are between the actual end of the sheet and the location that Excel insists on identifying as the last cell, and then repeat the process for all columns that match that definition.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint