Ctrl+Shift+End: to the Last Used Cell

The shortcut Ctrl+Shift+End is to extend the selection to the last used cell where the row or column is used, or the shortcut will select all the text from cursor to the end in the formula bar.

Step 1: Click any cell in the worksheet, e.g., A3;

Step 2: Press and hold "Ctrl" and "Shift" key, and click the "End" key from the key board.

The selection is now extended to the last used cell C5.

Check More Excel Shortcuts

Leave a Reply