Forum Discussion

Anwesh Gangula's avatar
Anwesh Gangula
Iron Contributor
Nov 09, 2017
Solved

Go to last filled cell

I know that the shortcut to go to the last dilled cell is CTRL+END. But this doesn't seem to work properly. If I have written something in a cell beyond the last cell and then deleted the contents of...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 09, 2017

    Not sure what Inquire is in all versions of Excel, but in any case you shall activate it in options -> COM add-ins.

    Without it what I did step by step

    Formatted cells with deleted values (Ctrl+End)

    Select yellow cells and Clear All them

    Ctrl+End forwards on last deleted cell

    Now Save, Close and open the file again. Ctrl+End forwards correctly

     

S Akkaz H Jaffary's avatar
S Akkaz H Jaffary
MCT
Nov 09, 2017

Try CTRL + Dn Arrow then CTRL + Right Arrow

  • Anwesh Gangula's avatar
    Anwesh Gangula
    Iron Contributor
    Nov 09, 2017
    That'll just take me to the next filled/empty cell. But I want to go to the last filled cell at the very end.

Resources