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 the data range and highlight it in yellow, e.g., D4;

Step 2: Select any other cell or cells, e.g., A3:A5;

Step 3: Press and hold the "Ctrl" key from the keyboard, then click "Y".

Check More Excel Shortcuts

Leave a Reply