Ctrl+Shift+8: Select the Current Range

The shortcut Ctrl+Shift+8 is to select the current range around the active cell. Please also refer to Ctrl+Shift+Asterisk (*).

Step 1: Select any cell in the worksheet;

This image has an empty alt attribute; its file name is excelctrlasteri001.jpg

Step 2: Press and hold the "Ctrl" and "Shift" keys, then press number 8 in the alphanumeric area.

Check More Excel Shortcuts

Leave a Reply