Control End
 

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

Control End
 

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

"Jaleel" wrote:

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

Control End
 

Hi,

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

Regards,

Jaleel

"kassie" wrote:

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

"Jaleel" wrote:

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

Control End
 

Glad I could help Jaleel. Thanks for the feedback

"Jaleel" wrote:

Hi,

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

Regards,

Jaleel

"kassie" wrote:

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

"Jaleel" wrote:

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