Category: Excel Shortcuts

The shortcut Ctrl+Shift+Number Sign (#) is to apply the date format with the day, month, and year, which is the same as shortcut Ctrl+Shift+3. Step 1: Select the data …

The shortcut Ctrl+Shift+F is to bring up the "Format Cells" dialog box, which is the same as Ctrl+Shift+P . Step 1: Select the data you want to format; Step …

The shortcut Ctrl+Shift+Exclamation Point (!) is to format numbers with two decimals, thousands separator, and minus sign (-) for negative values, please also check shortcut Ctrl+Shift+1. Step 1: Select …

The shortcut Ctrl+Shift+Dollar Sign ($) is to apply the Currency format with two decimals. Please also refer to Ctrl+Shift+4. Step 1: Select the data you want to add dollar …

The shortcut Ctrl+Shift+Colon (:) is to enter the current time. To enter today's date, please refer to the shortcut "Ctrl+Semicolon". Step 1: Click any cell you want to enter …

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 …