Ctrl+Asterisk: Select Current Range

The shortcut Ctrl+Asterisk (*) is to select the current range around the active cell.

Step 1: Click any cell in the data range (e.g., C2);

Step 2: Press and hold the "Ctrl" key, and press the "Asterisk" sign from the keyboard. The data range will be selected.

Check More Excel Shortcuts

Leave a Reply