Control End

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Control Home brings the cursor to Cell A1. Fine. But why Control End takes
the cursor to a distant cell, where there is no data at all, other than
selecting the end of the table or the current region? Can anyone say the
reason and how to prevent it.

Regards,

Jaleel
 
That is the last row down, last column to the right, of your spreadsheet..
If your entry furthest down is in say F250, and your rightmost entry in say
AA5, then <End><Home> will take you to AA250. If <Ctrl><End> takes you to
say AA350, or to AG 300, it means your sheet is using resources for nothing.
Go to Column AA, and delete all columns to AG. Also go to Row 250, and
delete all rows to 350. Save your file. If you try again, you should go to
AA250
 
Hi,

Thank you Kassie. It worked. I was not saving the file after deletion, but
immediately trying to see the result.

Regards,

Jaleel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reset End Cell - Excel 2007 2
Change End Point? 2
Access Form Refresh 1
How do I get to the end of a text field 2
Macros 1
I want to actually reduce the number of rows & columns in a worksh 3
Cursor position after saving 2
Excel-how do I reset the cell to which I go with a Control End? 1

Back
Top