Forum Discussion
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...
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
Clear all doesn't seem to work & I cannot find the "Inquire" tab in the ribbon
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