Ctrl+Shift+2: Time Format

The shortcut Ctrl+Shift+2 is to apply the time format with the hour and minute, and AM or PM.

Step 1: Select all the numbers that you want to format;

Step 2: Press and hold the Ctrl and Shift keys, then press the number 2 form the keyboard.

Check More Excel Shortcuts

Leave a Reply