[Shift+Ctrl+End] Excel Shortcut Extend Selection Cell To Last Used Cell

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
Shift + Ctrl + End	To extend the selected cell to the last worked cell in the Excel worksheet

I wish the shortcut of Excel to extend the cell selection which was used later will be benefited for you.

Please keep intouch and leave any comment(s) that we will use it for our improvement.

Bye,
Michael Leng

See more tips:

• Fill Out Respective Data 2 Cells Intervening by Non-Adjacent Cells Each
• Tricks Adding Number, Date, Letter, Etc. Excel Column with Double Click
• Turn Off / Turn On Scroll Lock Excel Tip To Lock & Unlock On Keyboard
• [Shift]+[Arrow Keys] Expanding The Current Cell To Another Active Cell