Ctrl+Shift+At Sign: Applies Time Format

The shortcut Ctrl+Shift+At Sign (@) is to apply the time format with hour, minute, and AM or PM.

Step 1: Select the data you want to add time format;

Step 2: Press and hold the Ctrl and Shift keys, then press the "At Sign (@)" from the keyboard.

Check More Excel Shortcuts

Leave a Reply