View original (French)

Ctrl+end goes too far

Solved
xuorel Posted messages 253 Registration date   Status Member Last intervention   -  
xuorel Posted messages 253 Registration date   Status Member Last intervention   -
Hello,

I have a table. When I press ctrl+end, it takes me too far.
I tried deleting and clearing the extra rows and columns, but nothing works.

Is there a solution?

Thank you

Configuration: Windows / Chrome 71.0.3578.98

1 answer

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Ctrl+END moves to the last cell of the worksheet, in the last used row of the last used column on the right


    The shortcut therefore cannot take you "too far"; it's you who placed formulas, formats or selections up to that point!
    If we had your file, we could have tried to see what is up to that point...

    --
    Retirement is great! Especially in the Caribbean...
    Raymond (INSA, AFPA)
    0
    1. m@rina Posted messages 27549 Registration date   Status Moderator Last intervention   11 562
       
      Hello,

      Just for your info, Excel keeps in memory the last used cell, even if it has been cleared in the meantime.
      You need to save, and then it will recognize the actual last cell.
      1
    2. xuorel Posted messages 253 Registration date   Status Member Last intervention  
       
      Thank you m@rina for this information.
      0