This is the powerful Excel shortcut key. I have written this article for helping some Excel program users who may seek for an Excel shortcut like this one, “How Extend Selection Cell from One To The Last Used Cell” . Now here I am going to tell you shortcut key to extend the selection from any first selected active cell and cover to the last used cell in the Excel worksheet. The selection will array from the started cell to the last used cell in a square form. All active cells within the square frame, they will be highlighted by dim background. Benefit: 1] To search for the last worked cell in the worksheet quickly. 2] To identify the range of cells between the first selected cell and the last used cell. Methods: Press the “Shift” button and keep hold it. Press the second button key “Ctrl” and hold as well. Again, press down the “End” button key. Then, release the three buttons as mentioning above lines. That is all done. Function Result
See way differential how to manage your Excel with more ease