Ctrl+Y: Repeat the Last Command
The shortcut Ctrl+Y is to repeat the last command or action, if possible. In this example, we are going to highlight the cells. Step 1: Click any cell in …
Category: Excel Shortcuts
Ctrl+Space Bar: Selects the Entire Column
The shortcut of Ctrl+Space Bar is to select the entire column. Please refer to "Shift+Space Bar" if you want to use the shortcut to select the row. Step 1: …
Ctrl+Shift+Up Arrow: Extend to First Nonblank Cell in the Column
The shortcut Ctrl+Shift+Up Arrow is to extend the selection to the first nonblank cell in the column, or to the next nonblank cell if the next cell is blank. …
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); …
Ctrl+Shift+Right Arrow: Extend to Last Nonblank Cell in a Row
The shortcut Ctrl+Shift+Right Arrow is to extend the selection to the last nonblank cell in the same row, or if the next cell is blank, to the next nonblank …
Ctrl+Shift+Page Up: Current Cell Previous Sheet
The shortcut Ctrl+Shift+Page Up is to select the current active cell in the previous sheet. Step 1: The cursor is now in cell E4 in Sheet2; Step 2: Press …