Ctrl+Shift+Space Bar: Select Data Range

The shortcut Ctrl+Shift+Space Bar is to select the current data range. Press a second time to select the entire worksheet.

Step 1: Click any cell in the worksheet (C2);

Step 2: Press and hold the Ctrl and Shift keys, then press the Space Bar from the keyboard;

Step 3: Press the "Ctrl + Shift + Space Bar" from the keyboard again to select the whole worksheet.

Check More Excel Shortcuts

Leave a Reply