Ctrl+Shift+Caret: Applies Scientific Format

The shortcut Ctrl+Shift+Caret (^) is to apply the scientific number format with two decimal places.

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

Step 2: Press and hold the Ctrl and Shift keys, then press the "Caret (^)" from the keyboard.

Check More Excel Shortcuts

Leave a Reply