Ctrl+Shift+Asterisk: Select Current Range

The shortcut Ctrl+Shift+Asterisk (*) is to select the current range around the active cell, which is the same as Ctrl + Asterisk (*).

Step 1: Select any cell in the worksheet;

Step 2: Press and hold the "Ctrl" and "Shift" keys, then press the Asterisk (*) key from the top of the alphanumeric area.

Check More Excel Shortcuts

Leave a Reply